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=155268&$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 {#24582 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24663 +post_id: "1476184" +post_author: 1 +"ListingKey": "29823513" +"ListingId": "40834556" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:21:04Z" +"RFModificationTimestamp": "2026-06-02T16:50:00Z" +"ListPrice": 1149900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Puslinch" +"PostalCode": "N0B2J0" +"UnparsedAddress": "4053 WATSON Road S, Puslinch, Ontario N0B2J0" +"Coordinates": array:2 [ 0 => -80.0558486 1 => 43.4546889 ] +"Latitude": 43.4546889 +"Longitude": -80.0558486 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Builders, Developers & Luxury Home Visionaries! Rare, shovel-ready 1-acre estate lot (225’ frontage x 194’ depth) in prestigious Puslinch, flanked on both sides by prominent, existing luxury custom homes. This premium infill site offers a secure investment with established architectural precedent, featuring uninterrupted, elevated sunrise views over the 472-acre Mountsberg Conservation Area & Reservoir to the rear, and rolling country landscapes to the front. Bypass years of planning and save $37K–$75K+ in immediate development costs. Unlike raw, unserviced land, this property eliminates lengthy utility connection queues and features operational infrastructure: an existing drilled well, septic system, hydro hookups, established driveway/culvert, and completed boundary surveys/architectural drawings ready for immediate transfer to accelerate your build timeline. Premium Income or Live-In Structures On Site: Custom 24’x28’ Insulated Garage: Built to elite standards with 2x6 framing, durable steel roof, active 100-amp electrical panel, and an EV charging station. Features buried water/sewer conduits extended into the foundation, with the upper level structurally primed to be finished as a legal secondary suite, guest house, or luxury home studio. Active Loft Bungalow: Fully functional with an open-concept great room, updated kitchen, efficient heat pumps, and AC. Provides immediate rental income or live-in capability as a site office during your blueprint and permitting phase. Bonus Asset: Charming cordwood garden shed adds unique architectural character and immediate secure tool storage. Capture 100% of the luxury nature-views in an unmatched location that blends pristine protected nature with proven street value. Reduce your appraisal risks and build your crown jewel estate today! (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-29T16:53:17.553898+00:00" +"Directions": "Campbellville Rd/Milburough Line/Watson Rd S" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1999707" +"ListOfficeKey": "283187" +"LotFeatures": array:2 [ 0 => "Visual exposure" 1 => "Country residential" ] +"PhotosChangeTimestamp": "2026-05-29T14:30:21Z" +"PhotosCount": 31 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:13:16Z" +"StreetDirSuffix": "South" +"StreetName": "WATSON" +"StreetNumber": "4053" +"StreetSuffix": "Road" +"SubdivisionName": "22 - Rural Puslinch East" +"TaxAnnualAmount": "7266.23" +"Utilities": array:1 [ 0 => "Electricity" ] +"VirtualTourURLUnbranded": "https://vimeo.com/1127608254?share=copy&fl=sv&fe=ci" +"WaterSource": array:1 [ 0 => "Well" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29823513/4053-watson-road-s-puslinch" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "A" +"FrontageLengthNumeric": 225.0 +"OriginalEntryTimestamp": "2026-05-29T14:30:21.38Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1282013" +"ListOfficeNationalAssociationId": "1325425" +"Media": array:31 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29823513_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/cb47d50de8bc440c5973658149793543.webp" "MediaSize" => 182572 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-cb47d50de8bc440c5973658149793543.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29823513_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/67b7ab7c3f9f2e17d96f45b5b86f6f78.webp" "MediaSize" => 247290 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-67b7ab7c3f9f2e17d96f45b5b86f6f78.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29823513_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/cef1218eecba63fc32beb773fb493e03.webp" "MediaSize" => 164521 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-cef1218eecba63fc32beb773fb493e03.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29823513_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/5c4b0802f43243ccd9512e641f7619a5.webp" "MediaSize" => 221024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-5c4b0802f43243ccd9512e641f7619a5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29823513_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/074f7a3f9537617bca309e12985f2d22.webp" "MediaSize" => 168849 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-074f7a3f9537617bca309e12985f2d22.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29823513_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/93d57051f54ed2d90db15594609d7a98.webp" "MediaSize" => 197278 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-93d57051f54ed2d90db15594609d7a98.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29823513_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/c8d9bef915ab59eda83e2c3e487a0c0d.webp" "MediaSize" => 179223 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-c8d9bef915ab59eda83e2c3e487a0c0d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29823513_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/68b7e9733e6482a567f13e9a7aeed4ac.webp" "MediaSize" => 110196 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-68b7e9733e6482a567f13e9a7aeed4ac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29823513_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/d6b9783d1b26ebf68ee45e244d611288.webp" "MediaSize" => 183357 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-d6b9783d1b26ebf68ee45e244d611288.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29823513_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/bbc8fa72369111a80203565b556afbc9.webp" "MediaSize" => 166160 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-bbc8fa72369111a80203565b556afbc9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29823513_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/ea72549f5b36364dda99aa39fd8159a8.webp" "MediaSize" => 205195 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-ea72549f5b36364dda99aa39fd8159a8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29823513_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/9be9e0e884b0f4c837b07a1cdb718b54.webp" "MediaSize" => 184534 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-9be9e0e884b0f4c837b07a1cdb718b54.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29823513_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/46b335a185d1979e9420da3935b70272.webp" "MediaSize" => 97811 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-46b335a185d1979e9420da3935b70272.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29823513_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/3b47faa33fac9c34fd3352c2c317c247.webp" "MediaSize" => 93902 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-3b47faa33fac9c34fd3352c2c317c247.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29823513_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/88b48e8ac0c0b7ddbd13207214ee0fb4.webp" "MediaSize" => 95562 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-88b48e8ac0c0b7ddbd13207214ee0fb4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29823513_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/0dfae354350ae1623736380b40494090.webp" "MediaSize" => 89958 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-0dfae354350ae1623736380b40494090.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29823513_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/d7a56a22cbb368e7f00652c4664d87b6.webp" "MediaSize" => 94761 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-d7a56a22cbb368e7f00652c4664d87b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29823513_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/e6257e1fe11f0a5da0bfabfc988f2b46.webp" "MediaSize" => 89353 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-e6257e1fe11f0a5da0bfabfc988f2b46.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29823513_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/cee03afe74902f8f4425712c08ad63f5.webp" "MediaSize" => 96501 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-cee03afe74902f8f4425712c08ad63f5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29823513_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/c6de3e573ee1dd167321a990f7bdab9c.webp" "MediaSize" => 144118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-c6de3e573ee1dd167321a990f7bdab9c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29823513_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/9109266cf920f3d776afed1c5b093cbc.webp" "MediaSize" => 193499 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-9109266cf920f3d776afed1c5b093cbc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29823513_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/ce717f382600748c259a1fbc5b8ff567.webp" "MediaSize" => 62036 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-ce717f382600748c259a1fbc5b8ff567.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29823513_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/d4f1bb6147194ed98bede8bd9581fe6b.webp" "MediaSize" => 73718 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-d4f1bb6147194ed98bede8bd9581fe6b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29823513_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/da513e9bcf1101ea622044b89a1f53d0.webp" "MediaSize" => 68276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-da513e9bcf1101ea622044b89a1f53d0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29823513_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/ecc05c66dff27b952f484de1a978c29b.webp" "MediaSize" => 68103 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-ecc05c66dff27b952f484de1a978c29b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29823513_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/da5fb12c1e2785f8877b8385c44b3465.webp" "MediaSize" => 174687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-da5fb12c1e2785f8877b8385c44b3465.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29823513_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/936e1bf50cb366a15b9c81c8f9268fa2.webp" "MediaSize" => 167094 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-936e1bf50cb366a15b9c81c8f9268fa2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29823513_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/2e253574997566c9b5281cc5efe67861.webp" "MediaSize" => 156497 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-2e253574997566c9b5281cc5efe67861.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29823513_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/4fd9f812ae9ed8251c39a6eb1dc7c37f.webp" "MediaSize" => 109359 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-4fd9f812ae9ed8251c39a6eb1dc7c37f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29823513_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/5cb1fc77f050cadca9d3339593c6ecc3.webp" "MediaSize" => 118478 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-5cb1fc77f050cadca9d3339593c6ecc3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29823513_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29823513/326dd77e4faa1af01b21aa33dae509ed.webp" "MediaSize" => 113126 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29823513/thumbnail-326dd77e4faa1af01b21aa33dae509ed.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834556" "ResourceRecordKey" => "29823513" "ModificationTimestamp" => "2026-05-29T14:30:21.39Z" ] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29823513')" +"ID": "1476184" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24510 +post_id: "1471337" +post_author: 1 +"ListingKey": "29820917" +"ListingId": "40834555" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-11T16:20:07Z" +"RFModificationTimestamp": "2026-06-11T16:28:49Z" +"ListPrice": 408880.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 598.0 +"BuildingAreaTotal": 0 +"City": "Beamsville" +"PostalCode": "L3J2J3" +"UnparsedAddress": "5055 GREENLANE Road Unit# 330, Beamsville, Ontario L3J2J3" +"Coordinates": array:2 [ 0 => -79.480679 1 => 43.1807964 ] +"Latitude": 43.1807964 +"Longitude": -79.480679 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this beautifully maintained, turn-key condo offering modern finishes, exceptional accessibility, and an unbeatable location in the heart of Niagara wine country. This bright and spacious 1 bedroom plus den, barrier-free unit features an open-concept layout with large windows that fill the space with natural light, creating an inviting atmosphere throughout. The stylish kitchen is designed for both functionality and entertaining, showcasing a large quartz countertop with breakfast bar seating, soft-close cabinetry, built-in stainless steel appliances, and contemporary finishes. The kitchen flows seamlessly into the living area, enhanced by new lighting and luxury vinyl flooring throughout for a fresh, modern feel. The versatile den provides the perfect space for a home office, guest area, or additional living space, while the spacious primary bedroom offers comfort and convenience. Designed with accessibility in mind, this wheelchair-accessible unit provides barrier-free living without compromising style. Step outside to your huge private balcony overlooking the beautifully landscaped courtyard, offering a peaceful outdoor retreat rarely found in condo living. Residents enjoy low condo fees and access to fantastic building amenities including a fully equipped gym, party room, rooftop terrace, bike storage, and beautifully maintained common areas. Ideally located just minutes from the QEW, future GO Transit expansion, award-winning wineries, restaurants, shopping, parks, hiking trails, and all amenities. Conveniently situated near the Beamsville Bench wine region, downtown Beamsville, and Niagara's renowned fruit belt, this exceptional condo offers the perfect blend of comfort, convenience, and lifestyle. (id:62783)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"AssociationFee": "386.43" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Heat" 1 => "Insurance" 2 => "Parking" ] +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "Community Centre" 2 => "Industrial Park" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T22:52:11.467336+00:00" +"Directions": "Ontario St to Greenlane Rd" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Heating": array:1 [ 0 => "Geo Thermal" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524224" +"ListOfficeKey": "275989" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Balcony" 1 => "Industrial mall/subdivision" ] +"ParkingFeatures": array:2 [ 0 => "Underground" 1 => "Visitor Parking" ] +"PhotosChangeTimestamp": "2026-05-28T21:13:42Z" +"PhotosCount": 35 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-11T16:11:42Z" +"Stories": "1.0" +"StreetName": "GREENLANE" +"StreetNumber": "5055" +"StreetSuffix": "Road" +"SubdivisionName": "981 - Lincoln Lake" +"TaxAnnualAmount": "2838.09" +"VirtualTourURLUnbranded": "https://youtu.be/BjQvSavK9ws" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:8 [ 0 => array:11 [ "RoomKey" => "1657139438" "RoomType" => "Other" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "4'7'' x 20'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 1 => array:11 [ "RoomKey" => "1657139439" "RoomType" => "Bedroom" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "12'11'' x 8'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 2 => array:11 [ "RoomKey" => "1657139440" "RoomType" => "Living room" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "13'11'' x 11'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 3 => array:11 [ "RoomKey" => "1657139441" "RoomType" => "4pc Bathroom" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "7'2'' x 8'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 4 => array:11 [ "RoomKey" => "1657139442" "RoomType" => "Kitchen" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "9'6'' x 11'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 5 => array:11 [ "RoomKey" => "1657139443" "RoomType" => "Laundry room" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "3'6'' x 5'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 6 => array:11 [ "RoomKey" => "1657139444" "RoomType" => "Den" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "6'2'' x 8'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] 7 => array:11 [ "RoomKey" => "1657139445" "RoomType" => "Foyer" "ListingId" => "40834555" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29820917" "RoomLength" => null "RoomDimensions" => "3'6'' x 5'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-11T16:11:42.64Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29820917/5055-greenlane-road-unit-330-beamsville" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"BuildingFeatures": array:1 [ 0 => "Party Room" ] +"SecurityFeatures": array:1 [ 0 => "Monitored Alarm" ] +"ZoningDescription": "GC" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"AboveGradeFinishedArea": 598 +"OriginalEntryTimestamp": "2026-05-28T21:09:44.04Z" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1064132" +"ListOfficeNationalAssociationId": "1269881" +"Media": array:35 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29820917_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/a0daa55d958cd60581eef56ce3dbdd91.webp" "MediaSize" => 118384 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-a0daa55d958cd60581eef56ce3dbdd91.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.23Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29820917_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/05c7d400f596b8be655b8deb6f44fa46.webp" "MediaSize" => 137036 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-05c7d400f596b8be655b8deb6f44fa46.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:40.16Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29820917_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/6d10a7a002f5358e2235e0e0d19546b1.webp" "MediaSize" => 103465 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-6d10a7a002f5358e2235e0e0d19546b1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:42.44Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29820917_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/00b4cf09cbe84e617b3a8a3f98ae5d17.webp" "MediaSize" => 78635 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-00b4cf09cbe84e617b3a8a3f98ae5d17.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:40.69Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29820917_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/c14b98ac8f027295e194d7d8e8e4967b.webp" "MediaSize" => 77689 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-c14b98ac8f027295e194d7d8e8e4967b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:42.52Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29820917_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/76486a0473148bd7b1bd463e45832bec.webp" "MediaSize" => 51500 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-76486a0473148bd7b1bd463e45832bec.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.37Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29820917_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/b4890186ce674a14d3bc62ea69f6e20a.webp" "MediaSize" => 61170 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-b4890186ce674a14d3bc62ea69f6e20a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.35Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29820917_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/6b968af8d5fd05cd95a5d36f2b40f381.webp" "MediaSize" => 63068 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-6b968af8d5fd05cd95a5d36f2b40f381.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.22Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29820917_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/921b8e7c5cd592e891c782723880ae5c.webp" "MediaSize" => 45019 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-921b8e7c5cd592e891c782723880ae5c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:40.69Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29820917_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/78ed8db4f4c961638511b83930d6feba.webp" "MediaSize" => 71924 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-78ed8db4f4c961638511b83930d6feba.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:40.16Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29820917_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/16a29637972aa3eb16a518e5f84ffe57.webp" "MediaSize" => 71234 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-16a29637972aa3eb16a518e5f84ffe57.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29820917_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/b266ac0eafc8a96ea14d238873bcfbc2.webp" "MediaSize" => 67778 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-b266ac0eafc8a96ea14d238873bcfbc2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29820917_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/18964c31e15ce8857143876cf75454d0.webp" "MediaSize" => 68441 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-18964c31e15ce8857143876cf75454d0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29820917_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/20bdaf3a215b9ca2d80f8afe5f6817c7.webp" "MediaSize" => 55937 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-20bdaf3a215b9ca2d80f8afe5f6817c7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:40.69Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29820917_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/72b50ffbd5802e0e0b0a43c91460f215.webp" "MediaSize" => 34880 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-72b50ffbd5802e0e0b0a43c91460f215.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29820917_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/23601a8195c299d701197f4d4346fe00.webp" "MediaSize" => 29972 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-23601a8195c299d701197f4d4346fe00.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.38Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29820917_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/2806ebfe23e30842cea1062a27c71348.webp" "MediaSize" => 103840 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-2806ebfe23e30842cea1062a27c71348.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.75Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29820917_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/88d5ed7a7680cd93694e6f547594ecb5.webp" "MediaSize" => 146908 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-88d5ed7a7680cd93694e6f547594ecb5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29820917_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/0abbe7ba318831b1fd3d33f35748e0a8.webp" "MediaSize" => 86748 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-0abbe7ba318831b1fd3d33f35748e0a8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Party Room" "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29820917_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/34a26bad11d6fd6c7738b81c38eee197.webp" "MediaSize" => 78750 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-34a26bad11d6fd6c7738b81c38eee197.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Party Room" "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29820917_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/570e8d9234f57028c1845960948de142.webp" "MediaSize" => 90111 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-570e8d9234f57028c1845960948de142.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.38Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29820917_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/a384a2294bc8c2f6266abbc6fd05cbdc.webp" "MediaSize" => 92512 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-a384a2294bc8c2f6266abbc6fd05cbdc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.76Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29820917_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/bd4332f49d0582cd674c538dfce6910f.webp" "MediaSize" => 101372 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-bd4332f49d0582cd674c538dfce6910f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.63Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29820917_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/be59a0df086aafb47e370f9b6766c2f3.webp" "MediaSize" => 88228 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-be59a0df086aafb47e370f9b6766c2f3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29820917_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/35ca1bebda5b382f2f5d9eef6c9373e9.webp" "MediaSize" => 101280 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-35ca1bebda5b382f2f5d9eef6c9373e9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.39Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29820917_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/c7bd9bd38f4a425474dbdfdf7538e11a.webp" "MediaSize" => 123435 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-c7bd9bd38f4a425474dbdfdf7538e11a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.75Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29820917_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/23eec90ef071dcb2c0e8af5932c763ae.webp" "MediaSize" => 155268 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-23eec90ef071dcb2c0e8af5932c763ae.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.65Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29820917_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/5c9c7b18ccfaead180b1729dcfecbfd2.webp" "MediaSize" => 149686 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-5c9c7b18ccfaead180b1729dcfecbfd2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.66Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29820917_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/5cc7465997f6b974ef0005a1e5c82b74.webp" "MediaSize" => 149973 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-5cc7465997f6b974ef0005a1e5c82b74.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.74Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29820917_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29820917/5cecc5c627b567409831ef1579adf85f.webp" "MediaSize" => 136752 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29820917/thumbnail-5cecc5c627b567409831ef1579adf85f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40834555" "ResourceRecordKey" => "29820917" "ModificationTimestamp" => "2026-05-28T21:13:41.68Z" ] 30 => array:13 [ "Order" => 31 …12 ] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820917')" +"ID": "1471337" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24651 +post_id: "1484018" +post_author: 1 +"ListingKey": "29838608" +"ListingId": "40834553" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-05T20:20:01Z" +"RFModificationTimestamp": "2026-07-05T20:24:23Z" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1536.0 +"BuildingAreaTotal": 0 +"City": "Delhi" +"PostalCode": "N4B2M6" +"UnparsedAddress": "277 MAIN Street, Delhi, Ontario N4B2M6" +"Coordinates": array:2 [ 0 => -80.4997607 1 => 42.8520899 ] +"Latitude": 42.8520899 +"Longitude": -80.4997607 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Welcome to 277 Main Street in Delhi — a fantastic opportunity for first-time buyers, downsizers, investors, or anyone seeking the ease and convenience of main-floor living. This well-maintained home offers an abundance of space throughout, featuring 3 generously sized bedrooms, 1 bathroom, a large eat-in kitchen, separate living and dining rooms, and a spacious rear family room perfect for relaxing or entertaining. Main-floor laundry and a bright 3-season sunroom add to the home’s comfort and functionality. Recent updates, including a durable metal roof, furnace, and air conditioning, provide added peace of mind. Outside, you’ll find a large detached garage with hydro, a mostly fenced backyard ideal for children or pets, and a recently paved driveway with ample parking for multiple vehicles. Conveniently located within walking distance to schools, parks, shopping, and everyday amenities, this property combines comfort, efficiency, and value in a desirable location. Offering immediate possession — this is a wonderful opportunity to make your move with ease. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Stove" 3 => "Dryer" 4 => "Hood Fan" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Partial" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-06-02T15:04:20.160394+00:00" +"Directions": "Wellington Main St South of Downtown" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1761539" +"ListOfficeKey": "289711" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-06-02T17:51:14Z" +"PhotosCount": 36 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-05T20:13:43Z" +"Stories": "1.0" +"StreetName": "MAIN" +"StreetNumber": "277" +"StreetSuffix": "Street" +"SubdivisionName": "Delhi" +"TaxAnnualAmount": "2706.84" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=AkAVfpZJDwM" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/29838608/277-main-street-delhi" +"ParkingTotal": 7 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2199795" +"CommonInterest": "Freehold" +"CoListOfficeKey": "92544" +"GeocodeManualYN": true +"ZoningDescription": "CS" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 48.0 +"AboveGradeFinishedArea": 1536 +"OriginalEntryTimestamp": "2026-06-02T13:54:26.86Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1184595" +"ListOfficeNationalAssociationId": "1380321" +"CoListAgentNationalAssociationId": "1448689" +"CoListOfficeNationalAssociationId": "1183612" +"Media": array:36 [ 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] ] +"DaysOnMarket": 34 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29838608')" +"ID": "1484018" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24536 +post_id: "1473648" +post_author: 1 +"ListingKey": "29824671" +"ListingId": "40834552" +"PropertyType": "Commercial Sale" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T15:10:52Z" +"RFModificationTimestamp": "2026-06-02T15:25:55Z" +"ListPrice": 375000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J2Z3" +"UnparsedAddress": "402 KING Street N, Waterloo, Ontario N2J2Z3" +"Coordinates": array:2 [ 0 => -80.5263477 1 => 43.4846041 ] +"Latitude": 43.4846041 +"Longitude": -80.5263477 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Successfully operating since 2019, this is a rare chance to acquire a proven, high-performing restaurant in a prime King Street North location in Waterloo. This turnkey, well-established business offers outstanding exposure along one of the city’s busiest corridors, surrounded by dense residential, student, and commercial activity, including offices such as Manulife. Strong street presence and pylon signage provide consistent visibility and traffic. The location is just minutes from major institutions like University of Waterloo, Wilfrid Laurier University, and Conestoga College. Nearby anchors such as Farm Boy, Tim Hortons, and other big-box retailers, plus close proximity to Wholesale Club, make daily operations and supply runs convenient. The space is approximately 1,200 sq ft with around 40 indoor seats, a modern open-ceiling design, and recent upgrades including new flooring, fresh paint, and bright LED lighting. The commercial kitchen is built for volume, featuring a 15-ft hood with rough-in for an additional 15 ft (up to 30 ft total potential), walk-in cooler, convection oven, gas burners, griller, and more — suitable for high-output or multi-cuisine concepts. Revenue comes from multiple streams including dine-in, catering, tiffin services, and online delivery, backed by an impressive ~4.5? Google rating. Average sales are approximately $52,000 per month. Rent is $6,300 per month, inclusive of TMI, HST, water, and pylon signage. A true turnkey and profitable operation in a high-demand location, ready for the next owner to step in and scale further. All showings by appointment only. (id:62783)" +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2026-05-29T17:52:05.250106+00:00" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2149104" +"ListOfficeKey": "285135" +"PhotosChangeTimestamp": "2026-05-29T16:32:50Z" +"PhotosCount": 38 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T15:04:12Z" +"StreetDirSuffix": "North" +"StreetName": "KING" +"StreetNumber": "402" +"StreetSuffix": "Street" +"VirtualTourURLUnbranded": "https://www.dropbox.com/scl/fo/fus0316b4gxqgdr4whdj1/AJwsZXheM9f9g-Cjy_X-ork?rlkey=kqtrlnq2ltsokuzswk9a4hwg4&e=2&st=lblxaqeg&dl=0" +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29824671/402-king-street-n-waterloo" +"CoListAgentKey": "2249979" +"CoListAgentKey2": "2241210" +"CoListOfficeKey": "76775" +"GeocodeManualYN": true +"CoListOfficeKey2": "76775" +"OriginalEntryTimestamp": "2026-05-29T16:32:50.24Z" +"ListAgentNationalAssociationId": "1400046" +"ListOfficeNationalAssociationId": "1347769" +"CoListAgentNationalAssociationId": "1488857" +"CoListAgentNationalAssociationId2": "1479368" +"CoListOfficeNationalAssociationId": "1004341" +"CoListOfficeNationalAssociationId2": "1004341" +"Media": array:38 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29824671')" +"ID": "1473648" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24531 +post_id: "1473209" +post_author: 1 +"ListingKey": "29824269" +"ListingId": "40834550" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-12T14:50:03Z" +"RFModificationTimestamp": "2026-06-12T14:51:35Z" +"ListPrice": 2200000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.34 +"LivingArea": 2178.0 +"BuildingAreaTotal": 0 +"City": "Oakville" +"PostalCode": "L6J1X1" +"UnparsedAddress": "2048 ELMHURST Avenue, Oakville, Ontario L6J1X1" +"Coordinates": array:2 [ 0 => -79.6453143 1 => 43.4726627 ] +"Latitude": 43.4726627 +"Longitude": -79.6453143 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Exceptional opportunity in one of Southeast Oakville's most coveted neighbourhoods. Situated on a magnificent 100' x 150' lot surrounded by mature trees, this property offers endless possibilities for renovation, expansion, or the construction of a new custom home.The property's impressive dimensions and sought-after RL1-0 zoning create an exceptional canvas for future plans. With zoning permitting up to 30% lot coverage, the site provides the opportunity to create a substantial custom residence. The existing residence has been lovingly maintained by the same owner for many years. The current home offers spacious principal rooms filled with natural light, multiple living areas, generous bedroom accommodations, and a detached garage. Whether you're looking to move in, renovate to suit your lifestyle, or design and build your dream home from the ground up, this property offers remarkable flexibility in an established neighbourhood. Ideally positioned within walking distance of some of Oakville's most highly regarded schools, parks, and the lake, while remaining just minutes from downtown Oakville's vibrant shops, restaurants, and waterfront. Large premium building lots of this size are becoming increasingly rare, making this an exceptional opportunity to secure a premier property in one of the town's most prestigious enclaves. (id:62650)" +"Basement": array:2 [ 0 => "Finished" 1 => "Partial" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-29T16:39:10.764427+00:00" +"Directions": "Maple Grove Drive / Elmhurst" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1389092" +"ListOfficeKey": "94300" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "0.34" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-05-29T15:50:22Z" +"PhotosCount": 21 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-12T14:41:22Z" +"StreetName": "ELMHURST" +"StreetNumber": "2048" +"StreetSuffix": "Avenue" +"SubdivisionName": "1006 - FD Ford" +"TaxAnnualAmount": "10049" +"VirtualTourURLUnbranded": "https://www.youtube.com/embed/-AyqKzsrfr4?rel=0" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29824269/2048-elmhurst-avenue-oakville" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RL1-0" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 100.0 +"AboveGradeFinishedArea": 1458 +"BelowGradeFinishedArea": 720 +"OriginalEntryTimestamp": "2026-05-29T15:50:22.01Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"BelowGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1036012" +"ListOfficeNationalAssociationId": "1188651" +"Media": array:21 [ 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] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29824269')" +"ID": "1473209" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24647 +post_id: "1471789" +post_author: 1 +"ListingKey": "29821946" +"ListingId": "40834548" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T23:50:36Z" +"RFModificationTimestamp": "2026-06-09T23:51:57Z" +"ListPrice": 944900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2420.0 +"BuildingAreaTotal": 0 +"City": "Guelph" +"PostalCode": "N1E0J3" +"UnparsedAddress": "177 WATSON Road N, Guelph, Ontario N1E0J3" +"Coordinates": array:2 [ 0 => -80.2103665 1 => 43.5683051 ] +"Latitude": 43.5683051 +"Longitude": -80.2103665 +"YearBuilt": 2010 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to move-in ready living in Guelph's sought-after East End! Situated on a premium corner lot, this beautifully maintained family home offers the perfect blend of comfort, convenience, and natural surroundings. Ideally located close to top-rated schools, parks, scenic walking trails, public transit, shopping, and quick access to Highway 401, it's an excellent choice for families and commuters alike. Step inside to a bright and inviting open-concept main floor featuring a spacious family room, formal dining area, and convenient powder room. The functional eat-in kitchen is complete with stainless steel appliances, plenty of cabinetry, and sliding doors leading to a large pie-shaped backyard. Enjoy peaceful pond and wetland views, creating a private natural setting filled with wildlife and beautiful scenery year-round.Upstairs, the spacious primary retreat showcases a vaulted ceiling, walk-in closet, and private 4-piece ensuite. Two additional generously sized bedrooms with ample closet space and another full 4-piece bathroom complete the upper level.The fully finished basement features a separate walk-up entrance, offering incredible flexibility for an in-law suite, home office, recreation space, or potential income opportunity. This is a rare opportunity to own a move-in ready home in one of Guelph's most family-friendly neighbourhoods. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-29T00:52:59.731916+00:00" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1968230" +"ListOfficeKey": "274578" +"LivingAreaUnits": "square feet" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T23:31:10Z" +"PhotosCount": 45 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:40:13Z" +"Stories": "2.0" +"StreetDirSuffix": "North" +"StreetName": "WATSON" +"StreetNumber": "177" +"StreetSuffix": "Road" +"SubdivisionName": "11 - Grange Road" +"TaxAnnualAmount": "5968" +"Utilities": array:1 [ 0 => "Telephone" ] +"VirtualTourURLUnbranded": "https://view.jmmediaphotos.com/177_watson_pkwy_n" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:15 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29821946/177-watson-road-n-guelph" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "RL.2" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 31.0 +"AboveGradeFinishedArea": 1660 +"BelowGradeFinishedArea": 760 +"OriginalEntryTimestamp": "2026-05-28T23:31:10.05Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1255978" +"ListOfficeNationalAssociationId": "1256495" +"Media": array:45 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29821946')" +"ID": "1471789" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24646 +post_id: "1476185" +post_author: 1 +"ListingKey": "29823514" +"ListingId": "40834547" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:21:04Z" +"RFModificationTimestamp": "2026-06-02T16:50:00Z" +"ListPrice": 1149900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1088.0 +"BuildingAreaTotal": 0 +"City": "Puslinch" +"PostalCode": "N0B2J0" +"UnparsedAddress": "4053 WATSON Road S, Puslinch, Ontario N0B2J0" +"Coordinates": array:2 [ 0 => -80.0562086 1 => 43.4544323 ] +"Latitude": 43.4544323 +"Longitude": -80.0562086 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Your Dream Cottage Sanctuary With A Future Growth Path! This rare 1-acre country estate (225’x194’) in prestigious Puslinch offers the ultimate lifestyle flexibility. Move right into the charming active loft bungalow and experience instant cottage living today, while enjoying the security of a premier investment flanked by prominent luxury custom homes. An Outdoor Enthusiast’s Paradise. Located directly across from the 472-acre Mountsberg Conservation Area and Reservoir, you will enjoy uninterrupted, elevated sunrise views, world-class bird watching, pristine hiking trails, and exceptional seasonal fishing right at your doorstep. The expansive lot provides a picturesque rolling country landscape out front and a breathtaking natural canopy out back. Live, Renovate, And Grow In Stages: Active Loft Backsplit: Fully functional and highly liveable with an open-concept great room, updated kitchen, efficient heat pumps, and AC. Perfect as a primary residence, cozy country cottage, or immediate rental income generator. Custom 24’x28’ Insulated Garage / Future Guest Suite: Built to elite standards with 2x6 framing, a steel roof, a 100-amp panel, and an EV charging station. It features buried water/sewer conduits extended into the foundation, with the upper level structurally primed to be finished immediately as a legal secondary guest suite, home studio, or teen retreat as your family grows. Shovel-Ready Future Footprint: When you are ready for a larger home, the property offers a massive head start. All heavy infrastructure—drilled well, septic system, hydro hookups, and driveway—is fully operational, saving you $37K–$75K+ over raw land. Completed boundary surveys and architectural drawings are included and ready for immediate transfer. Complete with a charming cordwood garden shed for secure tool storage, this unmatched property lets you capture 100% of the luxury nature views now, with a built-in blueprint for your family's future expansions. (id:62650)" +"Basement": array:2 [ 0 => "Partially finished" 1 => "Partial" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"ConstructionMaterials": array:1 [ 0 => "Wood frame" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-29T16:53:16.581653+00:00" +"Directions": "Campbellville Rd/Milburough Line/Watson Rd S" +"ExteriorFeatures": array:3 [ 0 => "Wood" 1 => "Stone" 2 => "Stucco" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:3 [ 0 => "Heat Pump" 1 => "Baseboard heaters" 2 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1999707" +"ListOfficeKey": "283187" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Conservation/green belt" ] +"ParkingFeatures": array:2 [ 0 => "Detached Garage" 1 => "Open" ] +"PhotosChangeTimestamp": "2026-05-29T14:30:21Z" +"PhotosCount": 19 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:13:17Z" +"StreetDirSuffix": "South" +"StreetName": "WATSON" +"StreetNumber": "4053" +"StreetSuffix": "Road" +"SubdivisionName": "22 - Rural Puslinch East" +"TaxAnnualAmount": "7266.23" +"VirtualTourURLUnbranded": "https://vimeo.com/1127608254?share=copy&fl=sv&fe=ci" +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Rooms": array:7 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29823514/4053-watson-road-s-puslinch" +"ParkingTotal": 12 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "A" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 225.0 +"AboveGradeFinishedArea": 1088 +"OriginalEntryTimestamp": "2026-05-29T14:30:21.52Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1282013" +"ListOfficeNationalAssociationId": "1325425" +"Media": array:19 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29823514')" +"ID": "1476185" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25074 +post_id: "1473160" +post_author: 1 +"ListingKey": "29823921" +"ListingId": "40834546" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-05T20:30:05Z" +"RFModificationTimestamp": "2026-07-05T20:42:10Z" +"ListPrice": 848700.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 3317.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9C7B6" +"UnparsedAddress": "42 LASILA Court, Hamilton, Ontario L9C7B6" +"Coordinates": array:2 [ 0 => -79.9136577 1 => 43.2268245 ] +"Latitude": 43.2268245 +"Longitude": -79.9136577 +"YearBuilt": 1985 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Quiet court setting. Homes rarely become available here. Spacious 3 level back split in desirable family friendly West Mountain location. Large living room and dining room, each with French doors. This family home features a large eat in kitchen with moveable island and has granite counters plus stainless steel appliances. Kitchen opens to spacious family room with walkout to generous yard. Family room level also features additional bedroom/office which was previously used as a kitchen. Plumbing has been retained behind the walls making it a stand out feature for in-law or income potential. This offers a great opportunity to create a secondary suite or multi-generational living set up. 3 piece bathroom and further door to outside completes this level. Fireplace in family room has never been used by current owners and is “as is”. The foyer with neutral ceramic tile leads to the oak staircase and features a skylight. The upper level is completed by a 5 piece bathroom and 3 bedrooms including master with oversized closet. Enter the lower level with a enormous tiled rec room, an oversized cold cellar plus a newer private “mancave”. Updated furnace and air (2021), sliding patio door (2022). rear patio waterproofing (2023). Inside hall entry to 1½ car garage. Driveway could easily accommodate 4+ cars. Perfect home location for you and your family to enjoy. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-29T15:49:29.819400+00:00" +"Directions": "Garth to Limeridge, right on Bonaventure, left on Clifton Downs, right on Lasila" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1523827" +"ListOfficeKey": "55167" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Southern exposure" 2 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-06-22T22:42:29Z" +"PhotosCount": 36 +"Sewer": array:1 [ 0 => "Sanitary sewer" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-05T20:20:39Z" +"StreetName": "LASILA" +"StreetNumber": "42" +"StreetSuffix": "Court" +"SubdivisionName": "161 - Gilbert" +"TaxAnnualAmount": "6961.68" +"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/29823921/42-lasila-court-hamilton" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R3" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 44.0 +"AboveGradeFinishedArea": 2217 +"BelowGradeFinishedArea": 1100 +"OriginalEntryTimestamp": "2026-05-29T15:10:34.49Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1064798" +"ListOfficeNationalAssociationId": "1003582" +"Media": array:36 [ 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] ] +"DaysOnMarket": 38 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29823921')" +"ID": "1473160" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24540 +post_id: "1471491" +post_author: 1 +"ListingKey": "29820477" +"ListingId": "40834540" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:21:02Z" +"RFModificationTimestamp": "2026-06-02T16:50:29Z" +"ListPrice": 849900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 445.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Ancaster" +"PostalCode": "L9G3K9" +"UnparsedAddress": "227 GLANCASTER Road, Ancaster, Ontario L9G3K9" +"Coordinates": array:2 [ 0 => -79.9296832 1 => 43.2035559 ] +"Latitude": 43.2035559 +"Longitude": -79.9296832 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Imagine the opportunities! Prime 84.5 x 250 lot provides options for a wonderful family home and property or land development avenues. A really smart addition to this 3 bedroom bungalow created much needed extra space in the kitchen, dining room and main floor family room with cozy fireplace. Additional bedroom in lower level with extra full bathroom. Each exterior door brings you outside to quaint decks and patios or a large deck with plenty of space for outdoor furniture sitting amongst the shade of mature trees. Driveway can handle all the vehicles and a few toys. Great location for development consideration as an alternative. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2026-05-28T20:33:51.719047+00:00" +"Directions": "Rymal to Glancaster" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524224" +"ListOfficeKey": "275989" +"LotSizeDimensions": "445" +"PhotosChangeTimestamp": "2026-05-28T20:09:50Z" +"PhotosCount": 35 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:13:18Z" +"StreetName": "GLANCASTER" +"StreetNumber": "227" +"StreetSuffix": "Road" +"SubdivisionName": "530 - Rural Glanbrook" +"TaxAnnualAmount": "4867.9" +"Utilities": array:2 [ 0 => "Natural Gas" 1 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29820477/227-glancaster-road-ancaster" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R1" +"FrontageLengthNumeric": 85.0 +"OriginalEntryTimestamp": "2026-05-28T20:09:50.07Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1064132" +"ListOfficeNationalAssociationId": "1269881" +"Media": array:35 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] ] +"DaysOnMarket": 39 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820477')" +"ID": "1471491" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24581 +post_id: "1471490" +post_author: 1 +"ListingKey": "29820478" +"ListingId": "40834537" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T16:21:02Z" +"RFModificationTimestamp": "2026-06-02T16:50:29Z" +"ListPrice": 849900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.445 +"LivingArea": 2379.0 +"BuildingAreaTotal": 0 +"City": "Ancaster" +"PostalCode": "L9G3K9" +"UnparsedAddress": "227 GLANCASTER Road, Ancaster, Ontario L9G3K9" +"Coordinates": array:2 [ 0 => -79.9296327 1 => 43.2036055 ] +"Latitude": 43.2036055 +"Longitude": -79.9296327 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Imagine the opportunities! Prime 84.5 x 250 lot provides options for a wonderful family home and property or land development avenues. A really smart addition to this 3 bedroom bungalow created much needed extra space in the kitchen, dining room and main floor family room with cozy fireplace. Additional bedroom in lower level with extra full bathroom. Each exterior door brings you outside to quaint decks and patios or a large deck with plenty of space for outdoor furniture sitting amongst the shade of mature trees. Driveway can handle all the vehicles and a few toys. Great location for development consideration as an alternative. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T20:33:54.025223+00:00" +"Directions": "Rymal, south on Glancaster" +"ExteriorFeatures": array:2 [ 0 => "Vinyl siding" 1 => "Brick Veneer" ] +"FireplaceFeatures": array:1 [ 0 => "Insert" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524224" +"ListOfficeKey": "275989" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Corner Site" 1 => "Sump Pump" 2 => "Private Yard" ] +"LotSizeDimensions": "0.445" +"PhotosChangeTimestamp": "2026-05-28T20:09:50Z" +"PhotosCount": 35 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T16:13:18Z" +"Stories": "1.0" +"StreetName": "GLANCASTER" +"StreetNumber": "227" +"StreetSuffix": "Road" +"SubdivisionName": "530 - Rural Glanbrook" +"TaxAnnualAmount": "4867.9" +"Utilities": array:1 [ 0 => "Natural Gas" ] +"WaterSource": array:3 [ 0 => "Municipal water" 1 => "Cistern" 2 => "Well" ] +"Rooms": array:14 [ 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] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29820478/227-glancaster-road-ancaster" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 84.0 +"AboveGradeFinishedArea": 1363 +"BelowGradeFinishedArea": 1016 +"OriginalEntryTimestamp": "2026-05-28T20:09:50.32Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Assessor" +"ListAgentNationalAssociationId": "1064132" +"ListOfficeNationalAssociationId": "1269881" +"Media": array:35 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] ] +"DaysOnMarket": 39 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820478')" +"ID": "1471490" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24532 +post_id: "1471482" +post_author: 1 +"ListingKey": "29820479" +"ListingId": "40834531" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-05T20:30:05Z" +"RFModificationTimestamp": "2026-07-05T20:42:10Z" +"ListPrice": 639900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.07 +"LivingArea": 1369.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2E3W4" +"UnparsedAddress": "1089 COPPER LEAF Crescent, Kitchener, Ontario N2E3W4" +"Coordinates": array:2 [ 0 => -80.5077658 1 => 43.4016684 ] +"Latitude": 43.4016684 +"Longitude": -80.5077658 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "UPDATED 06/29 LIFT ON STAIRS REMOVED & BRAND NEW CARPET ON STAIRS AND IN PRIMARY BEDROOM. Welcome to 1089 Copper Leaf Crescent - a beautifully maintained detached home tucked into one of Kitchener's most convenient and family-friendly neighbourhoods. Offering 2 bedrooms, 2 bathrooms, and a single car garage, this home is perfect for first-time buyers, down-sizers, or anyone looking for low-maintenance living without sacrificing outdoor space and privacy. The true standout feature of this property is the incredible backyard oasis. Thoughtfully designed for maximum privacy, the owner personally planted the mature trees surrounding the yard, creating a peaceful and secluded outdoor retreat rarely found in the city. Whether enjoying quiet mornings, summer entertaining, or relaxing evenings, this backyard is truly something special. Inside, the home offers a functional and inviting layout with bright living spaces and comfortable bedrooms designed for everyday living. Located just minutes from Highway 7/8, commuting throughout Waterloo Region and beyond is incredibly convenient. You'll also love being close to an abundance of nearby amenities including Sunrise Shopping Centre, Laurentian Power Centre, grocery stores, restaurants, coffee shops, fitness facilities, and everyday essentials all within a short drive. Families will appreciate proximity to Williamsburg Public School and St. Mary's High School, making this an ideal location for a variety of lifestyles. A rare opportunity to own a detached home with a private backyard escape in an exceptionally convenient Kitchener location! (id:62650)" +"Appliances": array:1 [ 0 => "Water softener" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T20:33:32.990639+00:00" +"ExteriorFeatures": array:2 [ 0 => "Concrete" 1 => "Brick Veneer" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2184420" +"ListOfficeKey": "294047" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Conservation/green belt" ] +"LotSizeDimensions": "0.07" +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T20:09:51Z" +"PhotosCount": 28 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-05T20:20:39Z" +"Stories": "2.0" +"StreetName": "COPPER LEAF" +"StreetNumber": "1089" +"StreetSuffix": "Crescent" +"SubdivisionName": "333 - Laurentian Hills/Country Hills W" +"TaxAnnualAmount": "3975.8" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:4 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29820479/1089-copper-leaf-crescent-kitchener" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "R4" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 30.0 +"AboveGradeFinishedArea": 958 +"BelowGradeFinishedArea": 411 +"OriginalEntryTimestamp": "2026-05-28T20:09:50.94Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Assessor" +"BelowGradeFinishedAreaSource": "Assessor" +"ListAgentNationalAssociationId": "1434001" +"ListOfficeNationalAssociationId": "1435346" +"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": 39 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820479')" +"ID": "1471482" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24538 +post_id: "1470269" +post_author: 1 +"ListingKey": "29819688" +"ListingId": "40834529" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-30T14:10:10Z" +"RFModificationTimestamp": "2026-06-30T14:13:57Z" +"ListPrice": 959000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1442.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9B2M2" +"UnparsedAddress": "10 ARCHDEACON CLARK Trail, Hamilton, Ontario L9B2M2" +"Coordinates": array:2 [ 0 => -79.9092672 1 => 43.2023519 ] +"Latitude": 43.2023519 +"Longitude": -79.9092672 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to carefree luxury living in the gated community of St. Elizabeth Village. This beautifully renovated one-floor corner unit bungalow is one of the largest single-level floorplans available in the community, offering an impressive 1,442 sq ft of stylish and comfortable living space with 2 bedrooms, a den, 2 full bathrooms, and an attached garage From the moment you step inside, the soaring 12 foot ceilings in the foyer, front bedroom, and garage create a bright and spacious feel. The stunning kitchen is truly the heart of the home, featuring upgraded KitchenAid appliances, an extended peninsula perfect for gathering with family and friends, pantry pullout drawers, and a seamless view into the living and dining areas. The main bedroom is a peaceful retreat with a walk in closet and a beautifully finished ensuite complete with a walk in shower and luxurious rain head. Renovated just two years ago, this home is filled with thoughtful upgrades including engineered hardwood flooring throughout, custom wainscotting, California shutters, additional lighting, and an outdoor BBQ gas line for easy entertaining. Located just steps from the Village amenities including the pharmacy, medical clinic, woodworking shop, gym, pool, saunas, and golf simulator, this home offers the perfect blend of comfort, convenience, and community. Enjoy the freedom of maintenance free living and spend more time doing the things you love! CONDO Fees Incl: Property taxes, water, and all exterior maintenance (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Microwave Built-in" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"AssociationFee": "1182.24" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Landscaping" 1 => "Water" 2 => "Insurance" ] +"Basement": array:1 [ 0 => "None" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-05-28T19:41:34.629451+00:00" +"Directions": "Linc. to Garth Street. South East Corner of Garth Street & Rymal Road West" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1617329" +"ListOfficeKey": "262629" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Recreational" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-05-28T18:45:02Z" +"PhotosCount": 21 +"PoolFeatures": array:1 [ 0 => "Indoor pool" ] +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-30T14:04:02Z" +"Stories": "1.0" +"StreetName": "ARCHDEACON CLARK" +"StreetNumber": "10" +"StreetSuffix": "Trail" +"SubdivisionName": "169 - St. Elizabeth Village/Kennedy" +"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/29819688/10-archdeacon-clark-trail-hamilton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "Row / Townhouse" ] +"CoListAgentKey": "1525324" +"CommonInterest": "Condo/Strata" +"CoListOfficeKey": "284640" +"GeocodeManualYN": true +"BuildingFeatures": array:3 [ 0 => "Exercise Centre" 1 => "Guest Suite" 2 => "Party Room" ] +"ZoningDescription": "DE/S-664 De/S-664a" +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 10.0 +"AboveGradeFinishedArea": 1442 +"OriginalEntryTimestamp": "2026-05-28T18:40:05.12Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1159924" +"ListOfficeNationalAssociationId": "1223032" +"CoListAgentNationalAssociationId": "1136826" +"CoListOfficeNationalAssociationId": "1344651" +"Media": array:21 [ 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] ] +"DaysOnMarket": 39 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29819688')" +"ID": "1470269" } ] +success: true +page_size: 12 +page_count: 16786 +count: 201422 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]