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=154968&$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 {#24563 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24659 +post_id: "1470315" +post_author: 1 +"ListingKey": "29819994" +"ListingId": "40833780" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-30T17:45:37Z" +"RFModificationTimestamp": "2026-06-30T18:19:11Z" +"ListPrice": 949900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 4332.0 +"BuildingAreaTotal": 0 +"City": "Caledonia" +"PostalCode": "N3W1E1" +"UnparsedAddress": "9 FLEMING Crescent, Caledonia, Ontario N3W1E1" +"Coordinates": array:2 [ 0 => -79.9370088 1 => 43.0741038 ] +"Latitude": 43.0741038 +"Longitude": -79.9370088 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Prime Ravine lot in Caledonia's most up and coming neighborhood. This 4 bedroom ( all w ensuites) 3.5 bathroom home features approx 3000 sq ft of living space above grade. Plus an unspoiled basement with walkout to backyard oasis with tons of outdoor seating on the spacious deck, a hottub and an above ground pool. Can't think of a better place to enjoy the summer with the family. Bonus** no rear neighbor's for extra privacy plus Potential in-law suite with separate entrance. The main level has a great layout with open concept Kitchen and Family room , inside entry from garage to main floor laundry, a private dining room and sliding door out to the deck/bbq area looking over the previously mentioned Oasis. Come see this beautiful home in person and see for yourself just how spectacular it truly is. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Hot Tub" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" 7 => "Garage door opener" 8 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T20:22:01.482524+00:00" +"Directions": "Fleming Cr Near Thompson Rd" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Vinyl siding" 2 => "Other" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1967916" +"ListOfficeKey": "284639" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Paved driveway" 1 => "Sump Pump" 2 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T19:01:54Z" +"PhotosCount": 37 +"PoolFeatures": array:1 [ 0 => "Above ground pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-30T17:13:16Z" +"Stories": "2.0" +"StreetName": "FLEMING" +"StreetNumber": "9" +"StreetSuffix": "Crescent" +"SubdivisionName": "631 - Caledonia North East" +"TaxAnnualAmount": "7587" +"VirtualTourURLUnbranded": "https://youriguide.com/9_fleming_cres_haldimand_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:16 [ 0 => array:11 [ "RoomKey" => "1672007300" "RoomType" => "Storage" "ListingId" => "40833780" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "47'0'' x 33'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.54Z" ] 1 => array:11 [ "RoomKey" => "1672007301" "RoomType" => "Bedroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "12'1'' x 18'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.54Z" ] 2 => array:11 [ "RoomKey" => "1672007302" "RoomType" => "5pc Bathroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "5'6'' x 12'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 3 => array:11 [ "RoomKey" => "1672007303" "RoomType" => "Bedroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "14'6'' x 16'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 4 => array:11 [ "RoomKey" => "1672007304" "RoomType" => "3pc Bathroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "5'11'' x 9'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 5 => array:11 [ "RoomKey" => "1672007305" "RoomType" => "Bedroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "11'5'' x 12'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 6 => array:11 [ "RoomKey" => "1672007306" "RoomType" => "Full bathroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "13'5'' x 9'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 7 => array:11 [ "RoomKey" => "1672007307" "RoomType" => "Office" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "9'4'' x 8'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 8 => array:11 [ "RoomKey" => "1672007308" "RoomType" => "Primary Bedroom" "ListingId" => "40833780" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "13'6'' x 15'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 9 => array:11 [ "RoomKey" => "1672007309" "RoomType" => "Kitchen" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "16'3'' x 8'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.55Z" ] 10 => array:11 [ "RoomKey" => "1672007310" "RoomType" => "Breakfast" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "14'5'' x 11'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.56Z" ] 11 => array:11 [ "RoomKey" => "1672007311" "RoomType" => "Laundry room" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "6'6'' x 7'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.56Z" ] 12 => array:11 [ "RoomKey" => "1672007312" "RoomType" => "Great room" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "19'3'' x 19'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.56Z" ] 13 => array:11 [ "RoomKey" => "1672007313" "RoomType" => "Dining room" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "10'8'' x 13'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.56Z" ] 14 => array:11 [ "RoomKey" => "1672007314" "RoomType" => "2pc Bathroom" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "5'7'' x 5'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.56Z" ] 15 => array:11 [ "RoomKey" => "1672007315" "RoomType" => "Foyer" "ListingId" => "40833780" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29819994" "RoomLength" => null "RoomDimensions" => "5'0'' x 9'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-30T17:13:16.57Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29819994/9-fleming-crescent-caledonia" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "H A7A" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 42.0 +"AboveGradeFinishedArea": 3011 +"BelowGradeFinishedArea": 1321 +"OriginalEntryTimestamp": "2026-05-28T19:01:54.5Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1256108" +"ListOfficeNationalAssociationId": "1344653" +"Media": array:37 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29819994_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/051a12519d0ab4832cb1e18110565e62.webp" "MediaSize" => 102803 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-051a12519d0ab4832cb1e18110565e62.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Two-story residence featuring a stone and siding facade" "PreferredPhotoYN" => true "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29819994_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/4cfa5aed22c8ddac919cea32bc2abb92.webp" "MediaSize" => 154469 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-4cfa5aed22c8ddac919cea32bc2abb92.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary two-story residence featuring a stone and siding facade" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29819994_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/77dca81a529c222f0c637e8a523859b6.webp" "MediaSize" => 139633 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-77dca81a529c222f0c637e8a523859b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Stone facade with prominent covered porch and double entry doors" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29819994_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/471c9fdc6b91749310dadc1a5004976f.webp" "MediaSize" => 58457 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-471c9fdc6b91749310dadc1a5004976f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary powder room featuring a decorative accent wall with vertical paneling, a wall-mounted sink with brushed nickel faucet, a frameless beveled mirror, and recessed lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29819994_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/d55f19d819feb585048834ec2b75e3ac.webp" "MediaSize" => 73286 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-d55f19d819feb585048834ec2b75e3ac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dining area featuring wood-finish flooring, white walls, and a recessed ceiling" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29819994_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/bb0e773ee5f062833c2b44df06a1c513.webp" "MediaSize" => 76545 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-bb0e773ee5f062833c2b44df06a1c513.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious living area featuring wood-finish flooring, a white mantel fireplace, and two windows with white plantation shutters" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29819994_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/a2ec0eda080b3ab88da77977e0980d04.webp" "MediaSize" => 82554 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-a2ec0eda080b3ab88da77977e0980d04.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious living area featuring wood-finish flooring, a white mantel fireplace, and multiple windows with plantation shutters" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29819994_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/cf964d4f2011cbd2236cfb2f53343001.webp" "MediaSize" => 76865 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-cf964d4f2011cbd2236cfb2f53343001.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept living area with wood-finish flooring, recessed lighting, and crown molding" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29819994_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/dd5bc0ea7d6c549a191497226ce5c48a.webp" "MediaSize" => 71278 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-dd5bc0ea7d6c549a191497226ce5c48a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring an island with a gas cooktop, white cabinetry, a stainless steel refrigerator, white quartz countertops, and a mosaic tile backsplash" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29819994_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/f02e3003ce2ad80a88b3dc50abe7dbe4.webp" "MediaSize" => 78065 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-f02e3003ce2ad80a88b3dc50abe7dbe4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary kitchen featuring white cabinetry, a stone-finish backsplash, and a central island with a gas range" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29819994_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/bfd8408ea0d3974910a0500300f25231.webp" "MediaSize" => 76398 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-bfd8408ea0d3974910a0500300f25231.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Contemporary kitchen featuring stainless steel appliances, white cabinetry, and large format marble-look tile flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29819994_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/3179b4a02941cf8dbcca2c6cd53793b5.webp" "MediaSize" => 153809 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-3179b4a02941cf8dbcca2c6cd53793b5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Elevated wood deck with baluster railing, providing an expansive outdoor living area" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29819994_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/d695fcd67c18573104ffd8aec4cb0067.webp" "MediaSize" => 193139 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-d695fcd67c18573104ffd8aec4cb0067.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Elevated wood deck with black metal balusters and post cap lighting" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29819994_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/a9586a553a55096654cfd4cf0a07566d.webp" "MediaSize" => 61114 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-a9586a553a55096654cfd4cf0a07566d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious room with light gray carpeting and white walls" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29819994_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/2869b5c55156997262cac4dd17218220.webp" "MediaSize" => 77124 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-2869b5c55156997262cac4dd17218220.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Carpeted room featuring a ceiling-mounted light fixture and a wall-mounted television" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29819994_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/8e3b7d665a610bfcb585bd36777d10f4.webp" "MediaSize" => 55598 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-8e3b7d665a610bfcb585bd36777d10f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a glass-enclosed shower, a built-in tub with deck-mounted fixtures, and a vanity with a light-toned countertop" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29819994_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/77df70c946b5cfb991a3c34c5113aa85.webp" "MediaSize" => 61996 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-77df70c946b5cfb991a3c34c5113aa85.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dual vanity with white cabinetry, light countertops, and integrated sinks" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29819994_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/9bed531389b518c0a7329dd4a7db822d.webp" "MediaSize" => 82543 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-9bed531389b518c0a7329dd4a7db822d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Wall-to-wall carpeting and neutral wall tones" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29819994_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/7d8349c1cb0bbff8d10bd9d062b62f10.webp" "MediaSize" => 78711 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-7d8349c1cb0bbff8d10bd9d062b62f10.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Carpeted bedroom featuring a flush-mount ceiling light and a dresser with mirror" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29819994_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/99035192d664f112e508eb50d92664c6.webp" "MediaSize" => 65500 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-99035192d664f112e508eb50d92664c6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Dual oval LED-backlit mirrors accent a textured dark feature wall above a double vanity with a marble-finish countertop" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29819994_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/7cdc831a7152bc3efdf70b0316ebca33.webp" "MediaSize" => 77926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-7cdc831a7152bc3efdf70b0316ebca33.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Light-filled interior space featuring two windows with horizontal blinds, neutral wall paint, and gray carpet flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29819994_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/8e7ab6eee5ead118ef30000d911bb1ff.webp" "MediaSize" => 71731 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-8e7ab6eee5ead118ef30000d911bb1ff.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Carpeted room featuring white walls, window with white plantation shutters, and a ceiling-mounted light fixture" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29819994_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/3b566eab657b3b94a42037d1fcd0600e.webp" "MediaSize" => 68794 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-3b566eab657b3b94a42037d1fcd0600e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a dark wood-finish vanity with a light-colored countertop, an undermount sink, and a large wall-mounted mirror" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29819994_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/f1f06f79046a727c286a71eb4326f5de.webp" "MediaSize" => 128769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-f1f06f79046a727c286a71eb4326f5de.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious unfinished basement offering exposed wood joists, concrete flooring, and multiple windows" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29819994_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/c9945117ca4426f314977bf2211f0405.webp" "MediaSize" => 156446 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-c9945117ca4426f314977bf2211f0405.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Spacious outdoor deck featuring a hot tub, a covered seating area, and a green space beyond the perimeter fencing" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29819994_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/be34235006472e8427b6c1bff6420821.webp" "MediaSize" => 162162 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-be34235006472e8427b6c1bff6420821.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Expansive wood-finish deck featuring a built-in above-ground pool and surrounding black metal fencing" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29819994_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/47bfd9754e9c8c3fb73e77a679090158.webp" "MediaSize" => 168687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-47bfd9754e9c8c3fb73e77a679090158.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Multi-level wood deck featuring an above-ground pool, a covered hot tub, and a privacy railing with decorative post caps" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29819994_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/964464eb6eab601e70b5b68ffbfbbf44.webp" "MediaSize" => 170650 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-964464eb6eab601e70b5b68ffbfbbf44.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Expansive multi-level wood deck featuring a built-in hot tub, multiple shaded dining areas, and integrated lighting on railing posts" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29819994_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/0e84f1959aa31c39cbb1af6a1c1360f2.webp" "MediaSize" => 158858 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-0e84f1959aa31c39cbb1af6a1c1360f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Wood-plank deck featuring a dark wood railing with black balusters and integrated solar post cap lights" "PreferredPhotoYN" => false "ResourceRecordId" => "40833780" "ResourceRecordKey" => "29819994" "ModificationTimestamp" => "2026-05-28T19:01:54.5Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29819994_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29819994/55d1c12453c70fa9b58de8cb533f62b9.webp" "MediaSize" => 151007 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29819994/thumbnail-55d1c12453c70fa9b58de8cb533f62b9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Outdoor wood deck featuring a covered hot tub, a second-story wooden deck overhead, and a sliding glass door entry" "PreferredPhotoYN" => false …3 ] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] ] +"DaysOnMarket": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29819994')" +"ID": "1470315" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24515 +post_id: "1461529" +post_author: 1 +"ListingKey": "29807624" +"ListingId": "40833773" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:25:49Z" +"RFModificationTimestamp": "2026-06-02T16:36:25Z" +"ListPrice": 519900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 1684.0 +"BuildingAreaTotal": 0 +"City": "Thorold" +"PostalCode": "L2V4M1" +"UnparsedAddress": "24 TARA Crescent, Thorold, Ontario L2V4M1" +"Coordinates": array:2 [ 0 => -79.224764 1 => 43.1088947 ] +"Latitude": 43.1088947 +"Longitude": -79.224764 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 24 Tara Crescent in Thorold! This spacious semi-detached home offers an excellent opportunity for families, investors, or those seeking multi-generational living. Featuring 2+3 bedrooms and a fully finished basement, this property provides exceptional living space and versatility. The main floor boasts bright and inviting principal rooms, large windows allowing for plenty of natural light, and a functional layout ideal for everyday living. Upstairs features a 4-piece bathroom, while the finished basement includes an additional 3-piece bathroom, offering added convenience and flexibility. This property is licensed to rent as a single dwelling unit and also offers excellent potential for room-by-room rentals, making it an outstanding investment opportunity with strong income potential. Ideally located in the desirable Confederation Heights neighbourhood, just minutes from Brock University, Niagara College, Mel Swart Park, Lake Gibson, shopping, restaurants, transit, and quick highway access. A fantastic opportunity in the growing Niagara Region whether you’re looking for a family home, student rental, or income-generating investment property! (id:62650)" +"Appliances": array:3 [ 0 => "Washer" 1 => "Dishwasher" 2 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T19:36:15.401873+00:00" +"Directions": "Keefer Rd & Confederation Ave" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1967871" +"ListOfficeKey": "284635" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "Paved driveway" ] +"PhotosChangeTimestamp": "2026-05-26T19:09:57Z" +"PhotosCount": 42 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:15:18Z" +"Stories": "1.0" +"StreetName": "TARA" +"StreetNumber": "24" +"StreetSuffix": "Crescent" +"SubdivisionName": "558 - Confederation Heights" +"TaxAnnualAmount": "3577" +"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/29807624/24-tara-crescent-thorold" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R2" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 3 +"FrontageLengthNumeric": 26.0 +"AboveGradeFinishedArea": 844 +"BelowGradeFinishedArea": 840 +"OriginalEntryTimestamp": "2026-05-26T19:09:56.97Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1255709" +"ListOfficeNationalAssociationId": "1344652" +"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": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29807624')" +"ID": "1461529" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24647 +post_id: "1472043" +post_author: 1 +"ListingKey": "29819995" +"ListingId": "40833772" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-20T19:40:07Z" +"RFModificationTimestamp": "2026-06-20T19:45:58Z" +"ListPrice": 1249000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2388.0 +"BuildingAreaTotal": 0 +"City": "Windsor" +"PostalCode": "N8N3T2" +"UnparsedAddress": "351 OLD TECUMSEH Road, Windsor, Ontario N8N3T2" +"Coordinates": array:2 [ 0 => -82.8321708 1 => 42.3133994 ] +"Latitude": 42.3133994 +"Longitude": -82.8321708 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Situated in one of Tecumseh’s most desirable neighbourhoods near prestigious Russell Woods, this stunning custom-built ranch offers the perfect balance of upscale design and everyday comfort. Featuring 4 spacious bedrooms and 3 beautifully appointed bathrooms, this home showcases exceptional craftsmanship and thoughtfully curated finishes throughout. Step inside to a bright open-concept layout designed for modern living and effortless entertaining. The chef-inspired kitchen flows seamlessly into the dining and living areas and is complete with premium finishes, a walk-in pantry, and convenient main floor laundry. Soaring 9-ft ceilings extend throughout the home, while the living room impresses with an 11-ft ceiling and a striking three-sided glass fireplace that creates a warm yet sophisticated focal point. Outdoor living is just as impressive with a fully landscaped backyard retreat featuring a large covered patio, a sun-filled pergola seating area perfect for relaxing and taking in the beautiful sunrises, low-maintenance turf grass, and a full irrigation system servicing both the front and back yards for easy maintenance year-round. The oversized 2.5-car garage and expansive driveway provide ample space for vehicles, storage, and recreational equipment. The partially finished basement presents endless possibilities to expand your living space and tailor it to your lifestyle. Combining luxury, functionality, and an unbeatable location, this exceptional property is truly a rare opportunity you won’t want to miss. (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" 6 => "Window Coverings" 7 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T23:16:17.653617+00:00" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Stucco" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2192195" +"ListOfficeKey": "55164" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Visual exposure" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T23:09:48Z" +"PhotosCount": 49 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-20T19:32:49Z" +"Stories": "1.0" +"StreetName": "OLD TECUMSEH" +"StreetNumber": "351" +"StreetSuffix": "Road" +"SubdivisionName": "Lakeshore" +"TaxAnnualAmount": "8600" +"VirtualTourURLUnbranded": "https://vimeo.com/1196093526?fl=ip&fe=ec" +"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/29819995/351-old-tecumseh-road-windsor" +"ParkingTotal": 14 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1976321" +"CommonInterest": "Freehold" +"CoListOfficeKey": "55164" +"GeocodeManualYN": true +"SecurityFeatures": array:2 [ 0 => "Alarm system" 1 => "Smoke Detectors" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 75.0 +"AboveGradeFinishedArea": 2388 +"OriginalEntryTimestamp": "2026-05-28T19:01:54.77Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1441192" +"ListOfficeNationalAssociationId": "1003546" +"CoListAgentNationalAssociationId": "1262785" +"CoListOfficeNationalAssociationId": "1003546" +"Media": array:49 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] ] +"DaysOnMarket": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29819995')" +"ID": "1472043" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24533 +post_id: "1462364" +post_author: 1 +"ListingKey": "29807937" +"ListingId": "40833771" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T23:50:33Z" +"RFModificationTimestamp": "2026-06-09T23:52:25Z" +"ListPrice": 1350000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 50.9 +"LivingArea": 3371.0 +"BuildingAreaTotal": 0 +"City": "Pelham" +"PostalCode": "L0S1C0" +"UnparsedAddress": "678 CHANTLER Road, Pelham, Ontario L0S1C0" +"Coordinates": array:2 [ 0 => -79.349524 1 => 42.9966391 ] +"Latitude": 42.9966391 +"Longitude": -79.349524 +"YearBuilt": 1990 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 678 Chantler Road, Fenwick, a rare opportunity to own a stunning 50-acre estate within easy reach of Niagara's world class wineries. Nestled among rolling farmland in the peaceful community of Pelham, this fully furnished, income generating property offers the perfect blend of country living & savvy investment. The home is a spacious single family detached residence offering over 3,300 square feet of living space, built in 1990 & thoughtfully maintained throughout. All major systems have been updated within the past five years, including a heat pump installed in winter 2023/2024, a brand-new water heater (spring 2026), a 5-year-old roof, & kitchen and laundry appliances replaced within the past three years. The property is being sold fully furnished & is move in ready from day one. One of the crown jewels of this estate is its picturesque pond, complete with an island, offering a truly magical backdrop that has made this property a sought after destination for short term rental guests. The property holds an official short term rental licence with a 10-person occupancy limit & is legally permitted to operate under OPA zoning. Over the past five years, the property has generated significant rental income. Sellers are happy to share full income details with serious buyers. Beyond the rental income, approximately 30 acres of the property are rented out under a signed farming contract generating an additional $1,500 in annual income, making the total income profile of this estate exceptionally compelling. The property is serviced by a concrete cistern of approximately 4,000 gallons with water, a septic system sufficient for the home & last pumped in fall 2025, & a 500 gallon propane tank. Whether you are looking for a primary residence, a weekend retreat, or a turnkey investment property, 678 Chantler Road delivers on every front. Properties of this calibre, size, & income potential rarely come to market in Niagara. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Crawl space" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"ConstructionMaterials": array:1 [ 0 => "Wood frame" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T21:21:21.592280+00:00" +"ExteriorFeatures": array:2 [ 0 => "Wood" 1 => "Other" ] +"FireplaceFeatures": array:4 [ 0 => "Wood" 1 => "Electric" 2 => "Other - See remarks" 3 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:4 [ 0 => "Heat Pump" 1 => "Baseboard heaters" 2 => "Forced air" 3 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525426" +"ListOfficeKey": "293261" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Country residential" ] +"LotSizeDimensions": "50.9" +"PhotosChangeTimestamp": "2026-05-26T19:50:45Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:40:44Z" +"Stories": "2.0" +"StreetName": "CHANTLER" +"StreetNumber": "678" +"StreetSuffix": "Road" +"SubdivisionName": "664 - Fenwick" +"TaxAnnualAmount": "9094.37" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019e64c7-00d0-7245-ae8e-74969b5da22b" +"WaterSource": array:1 [ 0 => "Cistern" ] +"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/29807937/678-chantler-road-pelham" +"ParkingTotal": 15 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "A1" +"BedroomsAboveGrade": 6 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 2521.0 +"AboveGradeFinishedArea": 3371 +"OriginalEntryTimestamp": "2026-05-26T19:50:44.81Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1063673" +"ListOfficeNationalAssociationId": "1424570" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29807937')" +"ID": "1462364" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24532 +post_id: "1469177" +post_author: 1 +"ListingKey": "29818926" +"ListingId": "40833769" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-21T20:40:05Z" +"RFModificationTimestamp": "2026-06-21T20:44:14Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.126 +"LivingArea": 3218.0 +"BuildingAreaTotal": 0 +"City": "Barrie" +"PostalCode": "L4N0L3" +"UnparsedAddress": "12 BUMAN Court, Barrie, Ontario L4N0L3" +"Coordinates": array:2 [ 0 => -79.6481688 1 => 44.3706557 ] +"Latitude": 44.3706557 +"Longitude": -79.6481688 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Beautiful family home on a quiet, family-friendly court in the highly sought-after Tollendal community in southeast Barrie, steps to Lake Simcoe, Tyndale Park, trails, and waterfront amenities Approx. 4+1 bedrooms and 4 bathrooms with a functional family layout and spacious principal rooms Bright main level featuring formal living and dining areas, updated kitchen with quartz countertops and backsplash, walk-in pantry, and family room with gas fireplace and walkout to large deck Renovated bathrooms throughout, offering a modern and refreshed finish Upper level includes 4 spacious bedrooms, highlighted by a primary suite with walk-in closet and spa-like ensuite Finished walk-out basement with higher ceilings and large windows, offering exceptional additional living space including a kitchen, rec room, office area, storage room, and a 3-piece bathroom Basement also features a sauna and swim spa with powerful jets creating a current for swimming in place and exercise, heated for year-round use; often includes a separate relaxation area for a true lifestyle and entertainment retreat Extensive upgrades (2024–2026): quartz kitchen countertops, asphalt driveway, interlock, cedar deck and railings, electrical panel upgrade, and refinished hardwood flooring Double-car garage with 40-amp service and EV-ready capability Close to schools, parks, shopping, and a short drive to Barrie GO Transit Approx. 3,218 sq ft total finished space (incl. walkout basement) vs ~2,321 sq ft above grade (iGUIDE) (id:62650)" +"Appliances": array:3 [ 0 => "Water softener" 1 => "Sauna" 2 => "Central Vacuum" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T18:16:44.147450+00:00" +"Directions": "Dock Rd/Buman Crt" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Fencing": array:1 [ 0 => "Partially fenced" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2253558" +"ListOfficeKey": "292918" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Paved driveway" 2 => "Automatic Garage Door Opener" ] +"LotSizeDimensions": "0.126" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-31T01:40:34Z" +"PhotosCount": 41 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-21T20:33:48Z" +"Stories": "2.0" +"StreetName": "BUMAN" +"StreetNumber": "12" +"StreetSuffix": "Court" +"SubdivisionName": "BA12 - South" +"TaxAnnualAmount": "8188" +"VirtualTourURLUnbranded": "https://youriguide.com/oafit_12_buman_ct_barrie_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:16 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29818926/12-buman-court-barrie" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R2" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 47.0 +"AboveGradeFinishedArea": 2322 +"BelowGradeFinishedArea": 897 +"OriginalEntryTimestamp": "2026-05-28T17:31:19.84Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1492544" +"ListOfficeNationalAssociationId": "1419429" +"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": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29818926')" +"ID": "1469177" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24643 +post_id: "1462713" +post_author: 1 +"ListingKey": "29808341" +"ListingId": "40833767" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T20:30:41Z" +"RFModificationTimestamp": "2026-06-02T20:34:06Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1583.0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1T0C1" +"UnparsedAddress": "635 SAGINAW Parkway Unit# 2, Cambridge, Ontario N1T0C1" +"Coordinates": array:2 [ 0 => -80.2800223 1 => 43.3918377 ] +"Latitude": 43.3918377 +"Longitude": -80.2800223 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "MODERN OPEN-CONCEPT TOWNHOME WITH NO REAR NEIGHBOURS. #2-635 Saginaw Parkway, nestled within the highly sought-after and exquisite Saginaw Woods community of Cambridge. From the moment you step up to this beautifully designed contemporary townhome, you are greeted by an atmosphere of pristine cleanliness. The main level introduces a bright, welcoming foyer that seamlessly flows into an open-concept layout. At the heart of the home is a modern kitchen outfitted with rich dark cabinetry, sleek granite countertops, stainless steel appliances, and a convenient breakfast bar that overlooks the dining area. This airy, cohesive space effortlessly transitions into a sun-drenched living room, creating the perfect environment for both everyday family life and entertaining. The true showpiece of the main level awaits just beyond the living room, where an impressive three-pane-wide sliding glass door opens up to a private raised deck. Step outside to enjoy complete tranquility with absolutely no rear neighbors—just a peaceful backdrop of lush, mature trees and a sprawling green lawn. Back inside, the thoughtful layout continues to the upper level, which houses a versatile open loft space perfect for a home office, alongside a convenient second-floor laundry area. 2 generously sized bedrooms share a bright, full bathroom, while the primary suite serves as a genuine sanctuary. This spacious retreat features a walk-in closet, and a beautifully appointed ensuite bathroom complete with a modern dark-wood vanity, granite countertop, and a large glass-enclosed walk-in shower. Offering an unfinished basement ready for your personal touch, this home is perfectly situated in a friendly neighbourhood renowned for its outstanding schools, picturesque walking paths, bike lanes, and quick access to the 401. (id:62650)" +"Appliances": array:1 [ 0 => "Water softener" ] +"AssociationFee": "348" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Landscaping" 1 => "Insurance" 2 => "Parking" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T22:58:53.212155+00:00" +"Directions": "FRANKLIN/TOWNLINE ROAD" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1750694" +"ListOfficeKey": "285293" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-26T20:50:29Z" +"PhotosCount": 27 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T20:19:34Z" +"Stories": "2.0" +"StreetName": "SAGINAW" +"StreetNumber": "635" +"StreetSuffix": "Parkway" +"SubdivisionName": "33 - Clemens Mills/Saginaw" +"TaxAnnualAmount": "4959.95" +"VirtualTourURLUnbranded": "https://youriguide.com/2_635_saginaw_pkwy_cambridge_on/" +"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/29808341/635-saginaw-parkway-unit-2-cambridge" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"ZoningDescription": "RM4" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 1583 +"OriginalEntryTimestamp": "2026-05-26T20:50:28.63Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1066261" +"ListOfficeNationalAssociationId": "1349925" +"Media": array:27 [ 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] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29808341')" +"ID": "1462713" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24642 +post_id: "1461903" +post_author: 1 +"ListingKey": "29807168" +"ListingId": "40833763" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T23:50:33Z" +"RFModificationTimestamp": "2026-06-09T23:52:25Z" +"ListPrice": 779000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2250.0 +"BuildingAreaTotal": 0 +"City": "Thorold" +"PostalCode": "L2V1M1" +"UnparsedAddress": "150 HODGKINS Avenue, Thorold, Ontario L2V1M1" +"Coordinates": array:2 [ 0 => -79.2018365 1 => 43.0898427 ] +"Latitude": 43.0898427 +"Longitude": -79.2018365 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "TO BE BUILT: Customize this home from the ground up! Photos shown are from a similar home by the same builder a few houses down, offering a great sense of the layout, craftsmanship, and vision possible here. Set on a beautiful lot backing onto forest views with no rear neighbours, this is a rare opportunity to build a custom home in a stunning natural setting.Offering approximately 2,600 square feet, this thoughtfully designed 2-storey home blends function and comfort. The main floor features a welcoming foyer with porcelain tile, open-concept living, laminate or vinyl flooring in non-tiled areas, and a stylish kitchen with quartz countertops, large island, and seamless flow to the dining and living spaces. Patio doors open to your private backyard with peaceful forest views. Also on the main floor: a 2-piece bath and versatile fourth bedroom ideal for guests, office, or flex space.Upstairs offers three spacious bedrooms, a full 4-piece bath, laundry room, and a primary suite with walk-through closet and 5-piece ensuite with fibreglass shower and soaker tub.The unfinished basement is ready for future living space, gym, rec room, or extra bedrooms. Attached garage with inside access. Exterior elevation and final finishes to be determined by builder. Photos are from a previously completed model and may show optional upgrades and finishes available through the builder. (id:62650)" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T19:43:30.341551+00:00" +"Directions": "Allanburg rd to Hodgkins" +"ExteriorFeatures": array:1 [ 0 => "Other" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1738832" +"ListOfficeKey": "299401" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-26T18:32:35Z" +"PhotosCount": 24 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:40:44Z" +"Stories": "2.0" +"StreetName": "HODGKINS" +"StreetNumber": "150" +"StreetSuffix": "Avenue" +"SubdivisionName": "556 - Allanburg/Thorold South" +"TaxAnnualAmount": "1302.28" +"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/29807168/150-hodgkins-avenue-thorold" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1D-40" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 39.0 +"AboveGradeFinishedArea": 2250 +"OriginalEntryTimestamp": "2026-05-26T18:32:35.71Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1178468" +"ListOfficeNationalAssociationId": "1472476" +"Media": array:24 [ 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] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29807168')" +"ID": "1461903" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25073 +post_id: "1463729" +post_author: 1 +"ListingKey": "29809979" +"ListingId": "40833759" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:25:51Z" +"RFModificationTimestamp": "2026-06-02T16:36:11Z" +"ListPrice": 500000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 810.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2G0E4" +"UnparsedAddress": "15 WELLINGTON Street S Unit# 1909, Kitchener, Ontario N2G0E4" +"Coordinates": array:2 [ 0 => -80.5031319 1 => 43.4534445 ] +"Latitude": 43.4534445 +"Longitude": -80.5031319 +"YearBuilt": 2023 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this stunning corner-unit condo on the 19th floor of Station Park's highly anticipated Union Towers – Tower Two, featuring 2 spacious bedrooms, 2 bathrooms, and breathtaking floor-to-ceiling windows with panoramic views of Belmont Village. Complete with an underground parking space and locker, this modern suite offers unmatched amenities, including a two-lane bowling alley with a chic lounge, entertainment space with a bar, pool table, and foosball, a private hydropool swim spa and hot tub, a fully equipped fitness center with a yoga/pilates studio and Peloton room, a pet washing station, landscaped outdoor terrace with cabanas, BBQs, and social seating, a concierge desk, private dining room with gourmet kitchen, and the secure Snaile mail system for packages and food deliveries. Future amenities include an outdoor skating rink, vibrant restaurants, retail shops, and a grocery store. Perfectly located in Kitchener-Waterloo's Innovation District, Station Park offers a luxury lifestyle surrounded by tech hubs, shopping, dining, and entertainment—urban living at its finest. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave Built-in" ] +"AssociationFee": "645.18" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:4 [ 0 => "Property Management" 1 => "Heat" 2 => "Insurance" 3 => "Residential Manager" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:2 [ 0 => "Concrete block" 1 => "Concrete Walls" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-27T05:17:40.449736+00:00" +"Directions": "King and Wellington Streets in Kitchener" +"ExteriorFeatures": array:3 [ 0 => "Concrete" 1 => "Brick" 2 => "Aluminum siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2104716" +"ListOfficeKey": "283928" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Southern exposure" 1 => "Balcony" ] +"ParkingFeatures": array:3 [ 0 => "Underground" 1 => "None" 2 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-05-27T04:00:31Z" +"PhotosCount": 28 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:15:25Z" +"Stories": "1.0" +"StreetDirSuffix": "South" +"StreetName": "WELLINGTON" +"StreetNumber": "15" +"StreetSuffix": "Street" +"SubdivisionName": "313 - Downtown Kitchener/W. Ward" +"TaxAnnualAmount": "3446" +"View": "View (panoramic)" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"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": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29809979/15-wellington-street-s-unit-1909-kitchener" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:2 [ 0 => "Exercise Centre" 1 => "Party Room" ] +"ZoningDescription": "C3 & C5" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 810 +"OriginalEntryTimestamp": "2026-05-27T04:00:31.18Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1374070" +"ListOfficeNationalAssociationId": "1336904" +"Media": array:28 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29809979')" +"ID": "1463729" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24569 +post_id: "1468664" +post_author: 1 +"ListingKey": "29817602" +"ListingId": "40833757" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-06T20:30:44Z" +"RFModificationTimestamp": "2026-06-06T20:48:03Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 2603.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7T4A3" +"UnparsedAddress": "758 FRANCIS Road, Burlington, Ontario L7T4A3" +"Coordinates": array:2 [ 0 => -79.8206625 1 => 43.3189219 ] +"Latitude": 43.3189219 +"Longitude": -79.8206625 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautifully renovated raised bungalow in Burlington's desirable Aldershot community, offering exceptional space, versatility, and an ideal family-friendly location. The bright and inviting main level features an open-concept layout designed for both everyday living and entertaining, seamlessly connecting the living, dining, and kitchen areas. The updated kitchen offers modern finishes, ample cabinetry, and excellent functionality, while the spacious sunroom addition provides an expansive secondary living area filled with natural light and views of the backyard. Freshly painted throughout, the main level also features 3 generously sized bedrooms and 2 full bathrooms, including a primary ensuite rarely found in bungalows of this style and neighbourhood. The fully finished lower level offers outstanding flexibility with an additional living space, 2 additional bedrooms, a full 3-piece bathroom, and a second kitchen, making it ideal for older children, multi-generational living, or a potential income opportunity. This property offers both privacy and exceptional outdoor access, situated on a generous 55 ft x 129 ft lot backing directly onto the Francis Road Bikeway, Greenwood Park and with Earl Court Park conveniently located across the street, further enhances the home's desirable setting. Ideally located with easy access to the QEW, 403, and 407, commuting is effortless, while Aldershot GO Station is just minutes away. Schools, parks, trails, shopping, and everyday amenities are all close at hand, along with Joseph Brant Hospital. Enjoy proximity to Burlington's vibrant Lakeshore, lined with cafés, restaurants, boutique shopping, and waterfront attractions, as well as the Royal Botanical Gardens, scenic local trails, and nearby golf courses including Burlington Golf & Country Club. Don't miss this rare opportunity to own a spacious, move-in ready bungalow in one of Burlington's most convenient and established communities. (id:62783)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Raised bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T17:04:34.858656+00:00" +"Directions": "South of Cedar Ave. on Francis across from Earl Park" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stucco" 2 => "Vinyl siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceFeatures": array:2 [ 0 => "Wood" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1949898" +"ListOfficeKey": "283099" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T15:19:31Z" +"PhotosCount": 50 +"PoolFeatures": array:1 [ 0 => "Above ground pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-06T20:22:14Z" +"Stories": "1.0" +"StreetName": "FRANCIS" +"StreetNumber": "758" +"StreetSuffix": "Road" +"SubdivisionName": "303 - Aldershot South" +"TaxAnnualAmount": "6199" +"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/vd/248800591" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:16 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29817602/758-francis-road-burlington" +"ParkingTotal": 3 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Alarm system" ] +"ZoningDescription": "R3.1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 55.0 +"AboveGradeFinishedArea": 1550 +"BelowGradeFinishedArea": 1053 +"OriginalEntryTimestamp": "2026-05-28T15:19:31.67Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1244193" +"ListOfficeNationalAssociationId": "1324631" +"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": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29817602')" +"ID": "1468664" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24602 +post_id: "1471521" +post_author: 1 +"ListingKey": "29820186" +"ListingId": "40833755" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T23:50:36Z" +"RFModificationTimestamp": "2026-06-09T23:51:58Z" +"ListPrice": 1669000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 4113.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L7N1" +"UnparsedAddress": "5444 SUNDIAL Road, Burlington, Ontario L7L7N1" +"Coordinates": array:2 [ 0 => -79.7943585 1 => 43.4107384 ] +"Latitude": 43.4107384 +"Longitude": -79.7943585 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Discover luxury living in The Orchard! 5444 Sundial Road is a stunning 4+1 bedroom executive residence blending modern sophistication with family warmth. Situated on a premium lot with no neighbors on one side and across from Twelve Mile Trail, this property offers rare privacy and a backyard oasis with a shimmering saltwater inground pool and tranquil waterfall feature. With the prestigious R-2000 designation, this home offers exceptional energy efficiency, superior air quality, and year-round comfort. Step inside and your eyes are drawn to spectacular 20 ft vaulted ceilings in the formal living room, creating an airy, sun-drenched first impression. The seamless main floor layout offers a separate family room with a cozy gas fireplace and a versatile flex room, ideal for a sophisticated home office or custom bar area. The chef’s kitchen is a showstopper, featuring premium finishes and flowing effortlessly into the formal dining room—perfect for hosting family and friends. The main floor laundry provides direct access to the professionally renovated double garage, complete with tool storage, BBQ area, lounge space, and mounted TV. Upstairs, the primary suite is a true sanctuary with an expansive walk-in closet and spa-like 4-piece ensuite. Three additional generously sized bedrooms and a beautiful family bathroom complete the second level. The professionally finished basement features a sleek custom wet bar with quartz counters, two wine fridges, and a contemporary ethanol fireplace. With an additional bedroom, this level is ideal for a guest suite, teen retreat, office, or home gym. Your private backyard oasis awaits—a summer dream with a saltwater inground pool surrounded by low-maintenance patio stones. Siding onto the trail-rich landscape of The Orchard, you are steps from top-rated schools, shopping, Appleby GO, 407, and QEW. This is the one you’ve been waiting for! (id:62650)" +"Appliances": array:8 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave" 6 => "Window Coverings" 7 => "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-28T23:23:02.282904+00:00" +"Directions": "Dundas Street to Sutton Drive to Sundial Road" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1968432" +"ListOfficeKey": "283457" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T19:31:58Z" +"PhotosCount": 49 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:40:45Z" +"Stories": "2.0" +"StreetName": "SUNDIAL" +"StreetNumber": "5444" +"StreetSuffix": "Road" +"SubdivisionName": "352 - Orchard" +"TaxAnnualAmount": "8183.16" +"VirtualTourURLUnbranded": "https://youriguide.com/5444_sundial_rd_burlington_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"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/29820186/5444-sundial-road-burlington" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1974543" +"CommonInterest": "Freehold" +"CoListOfficeKey": "283457" +"GeocodeManualYN": true +"ZoningDescription": "RO3" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 54.0 +"AboveGradeFinishedArea": 2829 +"BelowGradeFinishedArea": 1284 +"OriginalEntryTimestamp": "2026-05-28T19:31:58.32Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1256115" +"ListOfficeNationalAssociationId": "1330157" +"CoListAgentNationalAssociationId": "1261397" +"CoListOfficeNationalAssociationId": "1330157" +"Media": array:49 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] ] +"DaysOnMarket": 36 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820186')" +"ID": "1471521" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24536 +post_id: "1462772" +post_author: 1 +"ListingKey": "29808823" +"ListingId": "40833754" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:25:51Z" +"RFModificationTimestamp": "2026-06-02T16:36:12Z" +"ListPrice": 1499999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3823.0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8G3H5" +"UnparsedAddress": "39 HILTS Drive, Stoney Creek, Ontario L8G3H5" +"Coordinates": array:2 [ 0 => -79.7217122 1 => 43.2110251 ] +"Latitude": 43.2110251 +"Longitude": -79.7217122 +"YearBuilt": 1981 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Rare opportunity to own a substantially upgraded RAVINE-BACKING BUNGALOW in Stoney Creek’s sought-after PLATEAU neighbourhood. Offering approximately 3,500 SQ FT OF FINISHED LIVING SPACE, this home has seen over $500,000 IN UPGRADES and features a custom kitchen, renovated bathrooms, finished on-site WHITE OAK HARDWOOD, SKYLIGHTS, GAS FIREPLACE, and a beautifully RE-FINISHED BASEMENT. The WALK-OUT LOWER LEVEL extends the living space and opens to a private backyard retreat with an IN-GROUND POOL, HOT TUB, SHED, and an impressive approx. 2,000 SQ FT CEDAR DECK, ideal for entertaining or relaxing against a serene ravine backdrop. Major updates include ROOF, HVAC, 200-AMP ELECTRICAL, plumbing, drywall, and framing, offering real value beyond the finishes. A rare turnkey bungalow in one of Stoney Creek’s most desirable family neighbourhoods. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" 4 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T22:26:39.171826+00:00" +"Directions": "Maple Ave to Hilts Drive" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2109697" +"ListOfficeKey": "289618" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Ravine" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-26T21:49:52Z" +"PhotosCount": 42 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:15:27Z" +"Stories": "1.0" +"StreetName": "HILTS" +"StreetNumber": "39" +"StreetSuffix": "Drive" +"SubdivisionName": "517 - Highway Valley/Dewitt" +"TaxAnnualAmount": "6424" +"View": "View of water" +"VirtualTourURLUnbranded": "https://northernmediagroup.hd.pics/39-Hilts-Dr/idx" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:17 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29808823/39-hilts-drive-stoney-creek" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "OS, R2" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 58.0 +"AboveGradeFinishedArea": 2131 +"BelowGradeFinishedArea": 1692 +"OriginalEntryTimestamp": "2026-05-26T21:49:52.47Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"BelowGradeFinishedAreaSource": "Listing Brokerage" +"ListAgentNationalAssociationId": "1378389" +"ListOfficeNationalAssociationId": "1379562" +"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": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29808823')" +"ID": "1462772" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24578 +post_id: "1460859" +post_author: 1 +"ListingKey": "29806993" +"ListingId": "40833753" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-03T19:55:06Z" +"RFModificationTimestamp": "2026-07-03T20:15:06Z" +"ListPrice": 929000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1286.0 +"BuildingAreaTotal": 0 +"City": "Guelph" +"PostalCode": "N1G1L6" +"UnparsedAddress": "90 DEAN Avenue, Guelph, Ontario N1G1L6" +"Coordinates": array:2 [ 0 => -80.2436801 1 => 43.5290119 ] +"Latitude": 43.5290119 +"Longitude": -80.2436801 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Perfect for buyers seeking the ease of single-floor living without sacrificing the privacy and freedom of a detached home, this beautifully updated property offers the ideal alternative to condo living. Featuring a thoughtfully redesigned open-concept layout, the home includes 3 spacious bedrooms and bright, functional living spaces designed for modern comfort and entertaining. Situated on a generous lot in Guelph’s highly desirable Old University neighbourhood, you’ll enjoy close proximity to excellent schools, shopping, parks, and the University of Guelph. Step outside to your own private retreat — a fully fenced backyard complete with a stunning new outdoor living space, landscape lighting, and hot tub, creating a tranquil setting to relax year-round. The detached garage offers incredible versatility with a heated garage/gym configuration that could easily be converted back to a tandem 2-car garage, workshop, or even explore future ADU potential. With parking for up to 6 vehicles, this property combines lifestyle, flexibility, and location in one exceptional package. (id:62650)" +"Appliances": array:9 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Hot Tub" 4 => "Dishwasher" 5 => "Stove" 6 => "Dryer" 7 => "Window Coverings" 8 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "None" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-26T18:38:20.609295+00:00" +"ExteriorFeatures": array:1 [ 0 => "Vinyl siding" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1739492" +"ListOfficeKey": "299910" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-05-27T14:43:05Z" +"PhotosCount": 39 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-03T19:49:38Z" +"Stories": "1.0" +"StreetName": "DEAN" +"StreetNumber": "90" +"StreetSuffix": "Avenue" +"SubdivisionName": "6 - Dovercliffe Park/Old University" +"TaxAnnualAmount": "6877" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" ] +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/90-Dean-Ave/idx" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:8 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29806993/90-dean-avenue-guelph" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1B" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1286 +"OriginalEntryTimestamp": "2026-05-26T18:10:00.45Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1178809" +"ListOfficeNationalAssociationId": "1478803" +"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": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29806993')" +"ID": "1460859" } ] +success: true +page_size: 12 +page_count: 16743 +count: 200913 +after_key: "" } "RF Response Time" => "0.22 seconds" ] ]