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 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.
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:13 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=12/Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=12&$expand=Media/Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=12/Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=12&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25169 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25178 +post_id: "84510" +post_author: 1 +"ListingKey": "27428257" +"ListingId": "XH4200905" +"PropertyType": "Farm" +"PropertySubType": "Agriculture" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:55Z" +"ListPrice": 2999990.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 2 +"BedroomsTotal": 7.0 +"LotSizeArea": 43.35 +"LivingArea": 3469.0 +"BuildingAreaTotal": 0 +"City": "Onondaga" +"PostalCode": "N3W2G9" +"UnparsedAddress": "4 Middleport Road, Onondaga, Ontario N3W2G9" +"Coordinates": array:2 [ 0 => -80.07203 1 => 43.104774 ] +"Latitude": 43.104774 +"Longitude": -80.07203 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Welcome to your dream estate! This custom-built bungalow offers over 5,500 sq ft of luxurious living space, set on 43 acres of picturesque land. The meticulously designed home boasts three distinct living spaces, perfect for intergenerational living or hosting guests. The main floor features an open concept layout with a high-end kitchen flowing into the great room. A natural gas double-sided fireplace enhances the living room and outdoor balcony, that overlooks the heated saltwater pool. Four generously sized bedrooms include a primary suite with a 5-piece ensuite and walk-in closet, plus three more bedrooms, one with a 3-piece ensuite and two sharing a Jack and Jill 5-piece bathroom. The upstairs loft offers a private escape with a kitchenette, bedroom, 3-piece bath, and separate entrance. The basement features a separate entrance as well, two bedrooms, 3-piece bath, kitchenette, and large living area. It also connects to a lower 4th garage with a 2-piece bathroom. Property highlights include a 50' x 84' barn, perfect hobby farm set-up and a 5,659 sq ft shop with offices and a spacious workshop. The shop includes two washrooms and a spacious loft for storage. This home offers many rare amenities and is a must-see. Contact us today for more details and don't miss out on the opportunity to own this one-of-a-kind property! Additional features available in supplements. (id:62650)" +"Appliances": array:2 [ 0 => "Water softener" 1 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 2 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"CreationDate": "2024-09-17T22:55:19.680314+00:00" +"Directions": "Highway # 54 to Middleport Road" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stone" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1862527" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Crushed stone driveway" 1 => "Carpet Free" 2 => "Country residential" 3 => "In-Law Suite" ] +"LotSizeDimensions": "43.35" +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Detached Garage" ] +"PhotosChangeTimestamp": "2025-08-14T14:41:43Z" +"PhotosCount": 48 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:27Z" +"Stories": "1.0" +"StreetName": "MIDDLEPORT" +"StreetNumber": "4" +"StreetSuffix": "Road" +"SubdivisionName": "2124 - Middleport/Onondaga" +"TaxAnnualAmount": "7931.84" +"VirtualTourURLUnbranded": "https://vimeo.com/988205772" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Rooms": array:24 [ 0 => array:11 [ "RoomKey" => "1482735151" "RoomType" => "Storage" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "7'4'' x 11'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.71Z" ] 1 => array:11 [ "RoomKey" => "1482735152" "RoomType" => "Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "14'11'' x 17'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.71Z" ] 2 => array:11 [ "RoomKey" => "1482735153" "RoomType" => "Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "10'11'' x 12'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.71Z" ] 3 => array:11 [ "RoomKey" => "1482735154" "RoomType" => "Family room" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "31'8'' x 50'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.71Z" ] 4 => array:11 [ "RoomKey" => "1482735155" "RoomType" => "Kitchen" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "20'1'' x 11'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.71Z" ] 5 => array:11 [ "RoomKey" => "1482735156" "RoomType" => "3pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.71Z" ] 6 => array:11 [ "RoomKey" => "1482735157" "RoomType" => "2pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.72Z" ] 7 => array:11 [ "RoomKey" => "1482735158" "RoomType" => "3pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "7'9'' x 5'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.72Z" ] 8 => array:11 [ "RoomKey" => "1482735159" "RoomType" => "Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "15'6'' x 13'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.72Z" ] 9 => array:11 [ "RoomKey" => "1482735160" "RoomType" => "Kitchen" "ListingId" => "XH4200905" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "10'10'' x 12'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.72Z" ] 10 => array:11 [ "RoomKey" => "1482735161" "RoomType" => "2pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "5'9'' x 6'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.72Z" ] 11 => array:11 [ "RoomKey" => "1482735162" "RoomType" => "Laundry room" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "6'9'' x 10'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 12 => array:11 [ "RoomKey" => "1482735163" "RoomType" => "5pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "17'9'' x 12'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 13 => array:11 [ "RoomKey" => "1482735164" "RoomType" => "Primary Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "23'5'' x 17'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 14 => array:11 [ "RoomKey" => "1482735165" "RoomType" => "3pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 15 => array:11 [ "RoomKey" => "1482735166" "RoomType" => "Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "13'9'' x 17'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 16 => array:11 [ "RoomKey" => "1482735167" "RoomType" => "Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "15'6'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 17 => array:11 [ "RoomKey" => "1482735168" "RoomType" => "5pc Bathroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 18 => array:11 [ "RoomKey" => "1482735169" "RoomType" => "Bedroom" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "13'9'' x 11'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 19 => array:11 [ "RoomKey" => "1482735170" "RoomType" => "Dining room" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "13'9'' x 13'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 20 => array:11 [ "RoomKey" => "1482735171" "RoomType" => "Breakfast" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "8'7'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 21 => array:11 [ "RoomKey" => "1482735172" "RoomType" => "Pantry" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "16'0'' x 11'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 22 => array:11 [ "RoomKey" => "1482735173" "RoomType" => "Kitchen" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "18'11'' x 13'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.73Z" ] 23 => array:11 [ "RoomKey" => "1482735174" "RoomType" => "Living room" "ListingId" => "XH4200905" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428257" "RoomLength" => null "RoomDimensions" => "18'11'' x 20'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.74Z" ] ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27428257/4-middleport-road-onondaga" +"ParkingTotal": 15 +"ZoningDescription": "A" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 2601.0 +"AboveGradeFinishedArea": 3469 +"OriginalEntryTimestamp": "2024-09-17T16:58:22.09Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"Media": array:48 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6125164439" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/7fddc726b8700c30abe4145000a448ff.webp" "MediaSize" => 77812 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-7fddc726b8700c30abe4145000a448ff.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.02Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6125164445" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/883f548675078c3a21cf463d29754a60.webp" "MediaSize" => 62068 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-883f548675078c3a21cf463d29754a60.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.72Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6125164449" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/4e7a994db4e124255103d9322acdf903.webp" "MediaSize" => 151610 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-4e7a994db4e124255103d9322acdf903.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.23Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6125164452" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/5db7c3cd5b42002566af7d5bc7f01f35.webp" "MediaSize" => 50523 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-5db7c3cd5b42002566af7d5bc7f01f35.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.27Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6125164457" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/065e06bcf4c72a3b837c584ac137d605.webp" "MediaSize" => 90992 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-065e06bcf4c72a3b837c584ac137d605.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.43Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6125164463" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/e3ff503958f08037238a7880ea108d3c.webp" "MediaSize" => 34353 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-e3ff503958f08037238a7880ea108d3c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.24Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6125164467" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/140cde07554d4290669c4d8731c8b473.webp" "MediaSize" => 135349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-140cde07554d4290669c4d8731c8b473.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.2Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6125164471" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/c6cf977fd5b2714b056ab11a1d1560dd.webp" "MediaSize" => 69665 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-c6cf977fd5b2714b056ab11a1d1560dd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.71Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6125164476" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/c91892894406cef5dcf052bf1f5b4991.webp" "MediaSize" => 136138 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-c91892894406cef5dcf052bf1f5b4991.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.41Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6125164478" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/2acb76379d5eac17967bf1f764f892fc.webp" "MediaSize" => 67584 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-2acb76379d5eac17967bf1f764f892fc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.24Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6125164489" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/314cbf1560d2638e7e6e89b93f236477.webp" "MediaSize" => 140656 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-314cbf1560d2638e7e6e89b93f236477.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.01Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6125164494" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/3ec63d8d8e8ddc9f51903863fd39b762.webp" "MediaSize" => 146975 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-3ec63d8d8e8ddc9f51903863fd39b762.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.24Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6125164500" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/61955e6022f9f5b23c872738f379f119.webp" "MediaSize" => 57126 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-61955e6022f9f5b23c872738f379f119.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.6Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6125164504" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/6ac42012bedd2fc9c1528d6e4e1233ad.webp" "MediaSize" => 68980 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-6ac42012bedd2fc9c1528d6e4e1233ad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.8Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6125164508" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/f64c516d356d366669458afcf0671fa4.webp" "MediaSize" => 134701 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-f64c516d356d366669458afcf0671fa4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.21Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6125164517" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/312dacfbe4272bd09ec58a40257b1a11.webp" "MediaSize" => 72152 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-312dacfbe4272bd09ec58a40257b1a11.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.02Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6125164520" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/0d6e63762c6cb263a3d61294b29367f6.webp" "MediaSize" => 90766 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-0d6e63762c6cb263a3d61294b29367f6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.61Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6125164521" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/23cbd5864220d8f8fe3762c2637bbde0.webp" "MediaSize" => 143518 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-23cbd5864220d8f8fe3762c2637bbde0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.76Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6125164523" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/8831006ed8fe5b54b7d8a3d1e705ed4f.webp" "MediaSize" => 168928 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-8831006ed8fe5b54b7d8a3d1e705ed4f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.02Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6125164525" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/efca2a6591029d214e392ca4ee9a4b23.webp" "MediaSize" => 98004 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-efca2a6591029d214e392ca4ee9a4b23.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.41Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6125164527" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/a36c0e861d53089b95f6efe31f1ad61f.webp" "MediaSize" => 87048 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-a36c0e861d53089b95f6efe31f1ad61f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.24Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6125164529" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/0eeca46e9eaf501d17f3558c6f9804bf.webp" "MediaSize" => 96762 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-0eeca46e9eaf501d17f3558c6f9804bf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.21Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6125164530" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/a6a144a54b41335abee82cc60535fbc4.webp" "MediaSize" => 76375 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-a6a144a54b41335abee82cc60535fbc4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.61Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6125164535" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/e9805f2b531f4d09c66bc65c419a4881.webp" "MediaSize" => 82679 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-e9805f2b531f4d09c66bc65c419a4881.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.73Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6125164540" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/cabc7b004d6ae204e06c495c3f9c62c3.webp" "MediaSize" => 72095 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-cabc7b004d6ae204e06c495c3f9c62c3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.62Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6125164545" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/1d1d1197a5f4dceb480b9177da908b57.webp" "MediaSize" => 61856 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-1d1d1197a5f4dceb480b9177da908b57.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.61Z" ] 26 => array:13 [ "Order" => 26 "MediaKey" => "6125164549" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/36eb89b93fb69c9c5880ed3009655e01.webp" "MediaSize" => 93765 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-36eb89b93fb69c9c5880ed3009655e01.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:32.25Z" ] 27 => array:13 [ "Order" => 27 "MediaKey" => "6125164554" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/1c1d53c3c1c943ffe7430f195bbe6cbf.webp" "MediaSize" => 63380 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-1c1d53c3c1c943ffe7430f195bbe6cbf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.61Z" ] 28 => array:13 [ "Order" => 28 "MediaKey" => "6125164558" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/0aaa7ba47ccf3a421395763a3e437a26.webp" "MediaSize" => 131893 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-0aaa7ba47ccf3a421395763a3e437a26.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.21Z" ] 29 => array:13 [ "Order" => 29 "MediaKey" => "6125164562" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/3a7141e90a759de35085fbba111a787f.webp" "MediaSize" => 75518 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-3a7141e90a759de35085fbba111a787f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:32.25Z" ] 30 => array:13 [ "Order" => 30 "MediaKey" => "6125164566" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/a1ea5af03669f5fa3ef872e5b93529b1.webp" "MediaSize" => 95882 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-a1ea5af03669f5fa3ef872e5b93529b1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:32.28Z" ] 31 => array:13 [ "Order" => 31 "MediaKey" => "6125164570" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/7d7062d765ddf96013e73330f63cdaf6.webp" "MediaSize" => 97782 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-7d7062d765ddf96013e73330f63cdaf6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:32.24Z" ] 32 => array:13 [ "Order" => 32 "MediaKey" => "6125164574" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/8d9e3b0069d3950514a12b146492cc85.webp" "MediaSize" => 82447 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-8d9e3b0069d3950514a12b146492cc85.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.24Z" ] 33 => array:13 [ "Order" => 33 "MediaKey" => "6125164577" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/584b982efe51a17af0d58386345b3cc6.webp" "MediaSize" => 146499 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-584b982efe51a17af0d58386345b3cc6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.2Z" ] 34 => array:13 [ "Order" => 34 "MediaKey" => "6125164580" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/d8c97dacb8045eee99fed3009b752b93.webp" "MediaSize" => 89025 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-d8c97dacb8045eee99fed3009b752b93.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:32.24Z" ] 35 => array:13 [ "Order" => 35 "MediaKey" => "6125164583" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/bb5c28450c799451695d71e1157033e8.webp" "MediaSize" => 88824 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-bb5c28450c799451695d71e1157033e8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:32.24Z" ] 36 => array:13 [ "Order" => 36 "MediaKey" => "6125164586" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/6637e082cdecd3caf81e069f06f6cf00.webp" "MediaSize" => 84832 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-6637e082cdecd3caf81e069f06f6cf00.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.23Z" ] 37 => array:13 [ "Order" => 37 "MediaKey" => "6125164589" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/7383334eded6246f8676e1fa8a4456b9.webp" "MediaSize" => 80594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-7383334eded6246f8676e1fa8a4456b9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.33Z" ] 38 => array:13 [ "Order" => 38 "MediaKey" => "6125164592" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/3d97d086e4806c77c12e3ce5b33a24d4.webp" "MediaSize" => 179699 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-3d97d086e4806c77c12e3ce5b33a24d4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.02Z" ] 39 => array:13 [ "Order" => 39 "MediaKey" => "6125164595" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/54e2f346aaa8dde90869d7961f7c5113.webp" "MediaSize" => 146935 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-54e2f346aaa8dde90869d7961f7c5113.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.01Z" ] 40 => array:13 [ "Order" => 40 "MediaKey" => "6125164598" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/6adf9aa9824b0dfc60b25e86110871ff.webp" "MediaSize" => 153292 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-6adf9aa9824b0dfc60b25e86110871ff.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.02Z" ] 41 => array:13 [ "Order" => 41 "MediaKey" => "6125164601" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/ab4da3d91efa35a41168afb05582cd31.webp" "MediaSize" => 101361 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-ab4da3d91efa35a41168afb05582cd31.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.19Z" ] 42 => array:13 [ "Order" => 42 "MediaKey" => "6125164603" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/b4ef6827403b0e909fca38f21b3c2209.webp" "MediaSize" => 160316 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-b4ef6827403b0e909fca38f21b3c2209.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:41.71Z" ] 43 => array:13 [ "Order" => 43 "MediaKey" => "6125164605" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/b3944b7873d1d619a760ef13da5925ef.webp" "MediaSize" => 56918 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-b3944b7873d1d619a760ef13da5925ef.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:40.61Z" ] 44 => array:13 [ "Order" => 44 "MediaKey" => "6125164607" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/e77c62bdbec1ed5f918e92e871a6eb00.webp" "MediaSize" => 84671 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-e77c62bdbec1ed5f918e92e871a6eb00.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.01Z" ] 45 => array:13 [ "Order" => 45 "MediaKey" => "6125164608" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/ca42a59acf1d5327bd2b95f9133e7409.webp" "MediaSize" => 74786 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-ca42a59acf1d5327bd2b95f9133e7409.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:42.2Z" ] 46 => array:13 [ "Order" => 46 "MediaKey" => "6125164611" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/5be78f64c28e8b97ac42f22e9d5fb359.webp" "MediaSize" => 98312 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-5be78f64c28e8b97ac42f22e9d5fb359.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:43.02Z" ] 47 => array:13 [ "Order" => 47 "MediaKey" => "6125164614" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428257/b51728fa07a1d9266395cf064a0c2d46.webp" "MediaSize" => 100706 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428257/thumbnail-b51728fa07a1d9266395cf064a0c2d46.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200905" "ResourceRecordKey" => "27428257" "ModificationTimestamp" => "2025-08-14T14:41:31.23Z" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27428257')" +"ID": "84510" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25176 +post_id: "84511" +post_author: 1 +"ListingKey": "27428265" +"ListingId": "XH4200875" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:55Z" +"ListPrice": 2999990.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 2 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 3469.0 +"BuildingAreaTotal": 0 +"City": "Onondaga" +"PostalCode": "N3W2G9" +"UnparsedAddress": "4 Middleport Road, Onondaga, Ontario N3W2G9" +"Coordinates": array:2 [ 0 => -80.07203 1 => 43.104774 ] +"Latitude": 43.104774 +"Longitude": -80.07203 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Welcome to your dream estate! This custom-built bungalow offers over 5,500 sq ft of luxurious living space, set on 43 acres of picturesque land. The meticulously designed home boasts three distinct living spaces, perfect for intergenerational living or hosting guests. The main floor features an open concept layout with a high-end kitchen flowing into the great room. A natural gas double-sided fireplace enhances the living room and outdoor balcony, that overlooks the heated saltwater pool. Four generously sized bedrooms include a primary suite with a 5-piece ensuite and walk-in closet, plus three more bedrooms, one with a 3-piece ensuite and two sharing a Jack and Jill 5-piece bathroom. The upstairs loft offers a private escape with a kitchenette, bedroom, 3-piece bath, and separate entrance. The basement features a separate entrance as well, two bedrooms, 3-piece bath, kitchenette, and large living area. It also connects to a lower 4th garage with a 2-piece bathroom. Property highlights include a 50' x 84' barn, perfect hobby farm set-up and a 5,659 sq ft shop with offices and a spacious workshop. The shop includes two washrooms and a spacious loft for storage. This home offers many rare amenities and is a must-see. Contact us today for more details and don't miss out on the opportunity to own this one-of-a-kind property! Additional features available in supplements. (id:62650)" +"Appliances": array:2 [ 0 => "Water softener" 1 => "Garage door opener" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 2 +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"CreationDate": "2024-09-17T22:52:49.553152+00:00" +"Directions": "Highway # 54 to Middleport Road" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stone" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1862527" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Crushed stone driveway" 1 => "Carpet Free" 2 => "Country residential" 3 => "In-Law Suite" ] +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Detached Garage" ] +"PhotosChangeTimestamp": "2025-08-14T13:51:21Z" +"PhotosCount": 50 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:27Z" +"Stories": "1.0" +"StreetName": "MIDDLEPORT" +"StreetNumber": "4" +"StreetSuffix": "Road" +"SubdivisionName": "2124 - Middleport/Onondaga" +"TaxAnnualAmount": "7931.84" +"VirtualTourURLUnbranded": "https://vimeo.com/988205772" +"WaterSource": array:1 [ 0 => "Cistern" ] +"Rooms": array:24 [ 0 => array:11 [ "RoomKey" => "1482735175" "RoomType" => "Storage" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "7'4'' x 11'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.95Z" ] 1 => array:11 [ "RoomKey" => "1482735176" "RoomType" => "Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "14'11'' x 17'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.95Z" ] 2 => array:11 [ "RoomKey" => "1482735177" "RoomType" => "Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "10'11'' x 12'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.95Z" ] 3 => array:11 [ "RoomKey" => "1482735178" "RoomType" => "Family room" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "31'8'' x 50'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.95Z" ] 4 => array:11 [ "RoomKey" => "1482735179" "RoomType" => "Kitchen" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "20'1'' x 11'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.95Z" ] 5 => array:11 [ "RoomKey" => "1482735180" "RoomType" => "3pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 6 => array:11 [ "RoomKey" => "1482735181" "RoomType" => "2pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 7 => array:11 [ "RoomKey" => "1482735182" "RoomType" => "3pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "7'9'' x 5'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 8 => array:11 [ "RoomKey" => "1482735183" "RoomType" => "Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "15'6'' x 13'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 9 => array:11 [ "RoomKey" => "1482735184" "RoomType" => "Kitchen" "ListingId" => "XH4200875" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "10'10'' x 12'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 10 => array:11 [ "RoomKey" => "1482735185" "RoomType" => "2pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "5'9'' x 6'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 11 => array:11 [ "RoomKey" => "1482735186" "RoomType" => "Laundry room" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "6'9'' x 10'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 12 => array:11 [ "RoomKey" => "1482735187" "RoomType" => "5pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "17'9'' x 12'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 13 => array:11 [ "RoomKey" => "1482735188" "RoomType" => "Primary Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "23'5'' x 17'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.96Z" ] 14 => array:11 [ "RoomKey" => "1482735189" "RoomType" => "3pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 15 => array:11 [ "RoomKey" => "1482735190" "RoomType" => "Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "13'9'' x 17'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 16 => array:11 [ "RoomKey" => "1482735191" "RoomType" => "Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "15'6'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 17 => array:11 [ "RoomKey" => "1482735192" "RoomType" => "5pc Bathroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 18 => array:11 [ "RoomKey" => "1482735193" "RoomType" => "Bedroom" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "13'9'' x 11'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 19 => array:11 [ "RoomKey" => "1482735194" "RoomType" => "Dining room" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "13'9'' x 13'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 20 => array:11 [ "RoomKey" => "1482735195" "RoomType" => "Breakfast" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "8'7'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 21 => array:11 [ "RoomKey" => "1482735196" "RoomType" => "Pantry" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "16'0'' x 11'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 22 => array:11 [ "RoomKey" => "1482735197" "RoomType" => "Kitchen" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "18'11'' x 13'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] 23 => array:11 [ "RoomKey" => "1482735198" "RoomType" => "Living room" "ListingId" => "XH4200875" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "27428265" "RoomLength" => null "RoomDimensions" => "18'11'' x 20'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-08-22T14:02:27.97Z" ] ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27428265/4-middleport-road-onondaga" +"ParkingTotal": 15 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"ZoningDescription": "A" +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 2 +"FrontageLengthNumeric": 2601.0 +"AboveGradeFinishedArea": 3469 +"OriginalEntryTimestamp": "2024-09-17T16:58:24.24Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"Media": array:50 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6125124102" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/39687ce49ebcf67ac06cc5e69da12046.webp" "MediaSize" => 149902 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428265/thumbnail-39687ce49ebcf67ac06cc5e69da12046.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200875" "ResourceRecordKey" => "27428265" "ModificationTimestamp" => "2025-08-14T13:51:20.7Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6125124105" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/dd98ca6d3ea3a2f69c4bbf61f2581377.webp" "MediaSize" => 74715 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428265/thumbnail-dd98ca6d3ea3a2f69c4bbf61f2581377.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200875" "ResourceRecordKey" => "27428265" "ModificationTimestamp" => "2025-08-14T13:51:19.44Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6125124107" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/f0214b541f85c71a9d00903f4adeb357.webp" "MediaSize" => 162482 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428265/thumbnail-f0214b541f85c71a9d00903f4adeb357.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200875" "ResourceRecordKey" => "27428265" "ModificationTimestamp" => "2025-08-14T13:51:21.7Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6125124109" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/fda431fec13d4cd95d47accc73d04664.webp" "MediaSize" => 133165 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428265/thumbnail-fda431fec13d4cd95d47accc73d04664.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200875" "ResourceRecordKey" => "27428265" "ModificationTimestamp" => "2025-08-14T13:51:18.48Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6125124111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/e9df05f97c1bbcdb48b5833eed368219.webp" "MediaSize" => 50372 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428265/thumbnail-e9df05f97c1bbcdb48b5833eed368219.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200875" "ResourceRecordKey" => "27428265" "ModificationTimestamp" => "2025-08-14T13:51:19.57Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6125124113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/345209acf86784e6dda9cd5a21272b0c.webp" "MediaSize" => 57029 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/27428265/thumbnail-345209acf86784e6dda9cd5a21272b0c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "XH4200875" "ResourceRecordKey" => "27428265" "ModificationTimestamp" => "2025-08-14T13:51:19.44Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6125124115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/27428265/523b75b952c507b44c301cf20e12c635.webp" …10 ] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27428265')" +"ID": "84511" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25179 +post_id: "60031" +post_author: 1 +"ListingKey": "27428550" +"ListingId": "XH4200083" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:55Z" +"ListPrice": 15.95 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 16002.0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7N3G2" +"UnparsedAddress": "3215 NORTH SERVICE Road, Burlington, Ontario L7N3G2" +"Coordinates": array:2 [ 0 => -79.798115 1 => 43.358652 ] +"Latitude": 43.358652 +"Longitude": -79.798115 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Freestanding office building, recently updated with class A finishes. Prominent QEW signage exposure. 11,749 SF, plus 4,253 SF lower level with additional 2,000 SF lower level storage included in net rent free. 80 parking spots. Occupancy available September 2025. (id:62650)" +"AssociationFeeIncludes": array:1 [ 0 => "Other, See Remarks" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2024-10-26T09:14:00.107915+00:00" +"Directions": "North Service Rd / Guelph Ln" +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524767" +"ListOfficeKey": "247136" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "1" +"PhotosChangeTimestamp": "2024-09-17T20:29:50Z" +"PhotosCount": 1 +"Sewer": array:2 [ 0 => "Sanitary sewer" 1 => "Storm sewer" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:28Z" +"StreetName": "NORTH SERVICE" +"StreetNumber": "3215" +"StreetSuffix": "Road" +"SubdivisionName": "353 - Palmer" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27428550/3215-north-service-road-burlington" +"LeaseAmount": 15.95 +"LeasePerUnit": "square feet" +"CoListAgentKey": "2014285" +"CoListOfficeKey": "247136" +"ZoningDescription": "BC1" +"FrontageLengthNumeric": 0.0 +"OriginalEntryTimestamp": "2024-09-17T16:59:25.35Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:1 [ 0 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27428550')" +"ID": "60031" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25175 +post_id: "99351" +post_author: 1 +"ListingKey": "27428775" +"ListingId": "XH4199312" +"PropertyType": "Commercial Sale" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-16T20:25:59Z" +"RFModificationTimestamp": "2025-09-17T00:18:59Z" +"ListPrice": 925000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7M0P8" +"UnparsedAddress": "6650 Appleby Line, Burlington, Ontario L7M0P8" +"Coordinates": array:2 [ 0 => -79.899669 1 => 43.462025 ] +"Latitude": 43.462025 +"Longitude": -79.899669 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Established over three decades ago, this thriving patio flower business is now available for sale. Specializing in direct-to-business flower planting and service, they have consistently achieved seven-figure earnings annually. The current owner is committed to assisting in a smooth transition by offering invaluable resources, connections, and existing contracts. With the potential for exponential growth and long-standing client relationships already in place, this efficient and well-managed business is primed for continued success. While the owner has never actively pursued new clientele, the opportunity to expand into untapped markets is vast. Don't miss your chance to acquire this turnkey operation from retiring owners. Financial statements are available upon signing a non-disclosure agreement (NDA). (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2024-09-19T08:55:56.421731+00:00" +"Directions": "This is a sale of Businees" +"Heating": array:1 [ 0 => "No heat" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1982606" +"ListOfficeKey": "283457" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "No Driveway" ] +"PhotosChangeTimestamp": "2024-09-17T20:16:22Z" +"PhotosCount": 4 +"Sewer": array:1 [ 0 => "No sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-09-16T20:03:44Z" +"StreetName": "APPLEBY" +"StreetNumber": "6650" +"StreetSuffix": "Line" +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27428775/6650-appleby-line-burlington" +"FrontageLengthNumeric": 0.0 +"OriginalEntryTimestamp": "2024-09-17T17:00:37.48Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:4 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27428775')" +"ID": "99351" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25177 +post_id: "99353" +post_author: 1 +"ListingKey": "27428966" +"ListingId": "XH4198557" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-28T20:40:32Z" +"RFModificationTimestamp": "2025-11-28T20:48:36Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8E6B8" +"UnparsedAddress": "15 McCollum Road E, Stoney Creek, Ontario L8E6B8" +"Coordinates": array:2 [ 0 => -79.630903 1 => 43.226408 ] +"Latitude": 43.226408 +"Longitude": -79.630903 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Your Last Chance to buy a large Luxury/Executive Building lot in this Area - there are no more. This is a large Unserviced Lot, (Services are on the Street). Build that Dream Home here in Winona. Walk to the Lake or to the Marina or the Trout Pond at Fifty Point Park. This Lot was just Created and there will be no more. Available Immediately. Amazing Neighborhood. Survey, Setback and Refundable Works Deposit info attached here - Check with Listing Agent for explanations. Property Tax Information Pending. Buyer to conduct their own Due Diligence regarding the suitability of the property for their intended Use. (id:62650)" +"CommunityFeatures": array:1 [ 0 => "Quiet Area" ] +"CreationDate": "2024-09-17T20:20:36.901780+00:00" +"Directions": "From the QEW Niagara, Take Fifty Rd. N. (toward Lake Ontario). Turn Rt. at McCollum Rd." +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1892993" +"ListOfficeKey": "55078" +"LotFeatures": array:3 [ 0 => "Cul-de-sac" 1 => "Level lot" 2 => "Level" ] +"PhotosChangeTimestamp": "2024-09-17T20:03:15Z" +"PhotosCount": 1 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-11-28T20:22:59Z" +"StreetDirSuffix": "East" +"StreetName": "MCCOLLUM" +"StreetNumber": "15" +"StreetSuffix": "Road" +"SubdivisionName": "519 - Winona" +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27428966/15-mccollum-road-e-stoney-creek" +"GeocodeManualYN": true +"ZoningDescription": "RRE." +"FrontageLengthNumeric": 134.0 +"OriginalEntryTimestamp": "2024-09-17T17:01:25.16Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:1 [ 0 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27428966')" +"ID": "99353" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25180 +post_id: "68813" +post_author: 1 +"ListingKey": "27428984" +"ListingId": "XH4198485" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:57Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 1500.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N1P6" +"UnparsedAddress": "13 Augusta Street, Hamilton, Ontario L8N1P6" +"Coordinates": array:2 [ 0 => -79.870422 1 => 43.251833 ] +"Latitude": 43.251833 +"Longitude": -79.870422 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Amazing opportunity to have your business in the heart of Hamilton on the corner of James and Augusta Streets! Zoning allows for many retail, service, hospitality & office uses. Over 1500 sq. ft. of main floor space that provides character and charm. Large front yard can be converted into a patio. Fully finished basement for extra office and storage space. 2 tandem parking spots on site. Gross lease plus utilities. (id:62650)" +"AssociationFeeIncludes": array:1 [ 0 => "Insurance" ] +"BuildingAreaUnits": "square feet" +"BusinessType": "Personal Services" +"CreationDate": "2024-10-31T16:13:14.110715+00:00" +"Directions": "James Street to Augusta" +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525198" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "1" +"PhotosChangeTimestamp": "2024-09-17T20:01:53Z" +"PhotosCount": 9 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:30Z" +"StreetName": "AUGUSTA" +"StreetNumber": "13" +"StreetSuffix": "Street" +"SubdivisionName": "142 - Corktown" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27428984/13-augusta-street-hamilton" +"ParkingTotal": 2 +"TotalActualRent": 6500 +"ExistingLeaseType": array:1 [ 0 => "Net" ] +"ZoningDescription": "C5" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 42.0 +"OriginalEntryTimestamp": "2024-09-17T17:01:29.35Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:9 [ 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] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27428984')" +"ID": "68813" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181 +post_id: "82408" +post_author: 1 +"ListingKey": "27429114" +"ListingId": "XH4197898" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:57Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 30160.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L0B5" +"UnparsedAddress": "65 BRANT Street, Hamilton, Ontario L8L0B5" +"Coordinates": array:2 [ 0 => -79.838905 1 => 43.265511 ] +"Latitude": 43.265511 +"Longitude": -79.838905 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Excellent opportunity to lease this vacant land (approx 0.70 acres) just south of Burlington St and east of Wentworth St N. Fully fenced lot with hydro available. M6 (light industrial) lot allows for many uses. Conveniently located close to QEW, 403, and city center. (id:62650)" +"AssociationFeeIncludes": array:1 [ 0 => "Other, See Remarks" ] +"BuildingAreaUnits": "square feet" +"BusinessType": "Other" +"CreationDate": "2024-10-31T16:05:56.216183+00:00" +"Directions": "Burlington St, south on Dickson to Brant St" +"Heating": array:1 [ 0 => "No heat" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2054759" +"ListOfficeKey": "289276" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "1" +"PhotosChangeTimestamp": "2024-09-17T19:51:58Z" +"PhotosCount": 10 +"Sewer": array:1 [ 0 => "No sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:31Z" +"StreetName": "BRANT" +"StreetNumber": "65" +"StreetSuffix": "Street" +"SubdivisionName": "210 - North Sherman" +"WaterSource": array:1 [ 0 => "None" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27429114/65-brant-street-hamilton" +"TotalActualRent": 5500 +"SecurityFeatures": array:1 [ 0 => "None" ] +"ExistingLeaseType": array:1 [ 0 => "Gross" ] +"ZoningDescription": "M6 - Light Industrial" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 132.0 +"OriginalEntryTimestamp": "2024-09-17T17:01:59.6Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:10 [ 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] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27429114')" +"ID": "82408" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25174 +post_id: "31041" +post_author: 1 +"ListingKey": "27429279" +"ListingId": "XH4196873" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-05T15:55:25Z" +"RFModificationTimestamp": "2025-09-06T00:50:44Z" +"ListPrice": 15.95 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 58202.0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8E2S8" +"UnparsedAddress": "555 BARTON Street, Stoney Creek, Ontario L8E2S8" +"Coordinates": array:2 [ 0 => -79.707318 1 => 43.224829 ] +"Latitude": 43.224829 +"Longitude": -79.707318 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Building has been well0maintained and lends itself to light manufacturing, heavy equipment sales and leasing operations, warehousing and distribution and heavy outside storage requirements. The property is 58,202 SF and comes with a large parking lot with an additional 1.50 acres in the back for outside storage. Excellent exposure along Barton, with great connectivity to all major industrial/commercial neighbourhoods in Stoney Creek as well as the QEW highway. Occupancy is November 2024. (id:62650)" +"AssociationFeeIncludes": array:1 [ 0 => "Other, See Remarks" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2024-10-20T00:37:02.869690+00:00" +"Directions": "Barton St. & Fuitland Rd." +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2032701" +"ListOfficeKey": "247136" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "1" +"PhotosChangeTimestamp": "2024-09-17T19:37:28Z" +"PhotosCount": 1 +"Sewer": array:2 [ 0 => "Sanitary sewer" 1 => "Storm sewer" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-09-05T15:42:24Z" +"StreetName": "BARTON" +"StreetNumber": "555" +"StreetSuffix": "Street" +"SubdivisionName": "512 - Guernsey/Westmeria/Industrial" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27429279/555-barton-street-stoney-creek" +"LeaseAmount": 15.95 +"LeasePerUnit": "square feet" +"CoListAgentKey": "2199253" +"CoListOfficeKey": "247136" +"ZoningDescription": "M3/M2" +"FrontageLengthNumeric": 0.0 +"OriginalEntryTimestamp": "2024-09-17T17:02:41.55Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:1 [ 0 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27429279')" +"ID": "31041" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25173 +post_id: "99361" +post_author: 1 +"ListingKey": "27490331" +"ListingId": "XH4192067" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:53Z" +"RFModificationTimestamp": "2025-08-22T14:49:20Z" +"ListPrice": 1260000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 3000.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8T3S7" +"UnparsedAddress": "348 UPPER OTTAWA Street, Hamilton, Ontario L8T3S7" +"Coordinates": array:2 [ 0 => -79.827198 1 => 43.231226 ] +"Latitude": 43.231226 +"Longitude": -79.827198 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Welcome to this purpose-built four-unit property, conveniently situated near the scenic Mountain Brow and many amenities. With two interior staircases connecting its units, it offers ease of access and privacy. Featuring a 2-bedroom unit with a den, eat-in kitchen and Livingroom, and two large 1-bedroom units on the second floor and a spacious 1-bedroom unit in the basement, a total of four units. It's an ideal investment opportunity. Residents can enjoy the convenience of on-site laundry facilities and on-site parking spaces, ensuring a stress-free living experience. With its prime location and diverse range of units, this income property presents an exceptional opportunity for investors seeking a lucrative addition to their portfolio or homeowners looking to supplement their income. (id:62650)" +"ArchitecturalStyle": array:1 [ 0 => "2 Level" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BusinessType": "Residential" +"CreationDate": "2024-10-31T15:51:33.130383+00:00" +"Directions": "348 Upper Ottawa close to Mountain Brow" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Radiant heat" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1523889" +"ListOfficeKey": "54891" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "No Driveway" ] +"PhotosChangeTimestamp": "2024-10-02T11:47:47Z" +"PhotosCount": 1 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:36Z" +"Stories": "2.0" +"StreetName": "UPPER OTTAWA" +"StreetNumber": "348" +"StreetSuffix": "Street" +"SubdivisionName": "250 - Sunninghill" +"TaxAnnualAmount": "5266" +"VirtualTourURLUnbranded": "https://www.venturehomes.ca/easydownload.asp?tourid=67686" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27490331/348-upper-ottawa-street-hamilton" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "Fourplex" ] +"FrontageLengthNumeric": 50.0 +"AboveGradeFinishedArea": 3000 +"OriginalEntryTimestamp": "2024-10-02T11:47:47.66Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"Media": array:1 [ 0 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27490331')" +"ID": "99361" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172 +post_id: "60032" +post_author: 1 +"ListingKey": "27429947" +"ListingId": "XH4190753" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-27T17:30:52Z" +"RFModificationTimestamp": "2025-10-24T23:58:20Z" +"ListPrice": 899000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1488.0 +"BuildingAreaTotal": 0 +"City": "Carlisle" +"PostalCode": "L0R1H1" +"UnparsedAddress": "1352 CENTRE Road, Flamborough, Ontario L0R1H1" +"Coordinates": array:2 [ 0 => -79.969732 1 => 43.386768 ] +"Latitude": 43.386768 +"Longitude": -79.969732 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Located in sought after Carlisle this picturesque property combines a tranquil rural retreat with the conveniences of nearby amenities. Lovingly cared for (ONE owner home), structurally sound & with a functional floor plan, this home presents a perfect canvas for your creative vision. Spacious 1488 sq ft 4 level side split features a living room with a large picture window & a fireplace insert, separate dining room & eat-in kitchen. 3 spacious bedrooms, primary with double closets. For those that work from home there is a main floor den. Conveniently located at the back door is a 2pce bath. On the lower level is a huge rec room with a wood burning fireplace. Extended single car garage has an inside entry. Mature tiered backyard has views across open farmland to forested areas. Plenty of room for kids & pets to play. Whether you're seeking a peaceful country retreat or a home for your extended family this property presents endless possibilities. For the golfers, Dragon Fire & Carlisle Golf & Country Clubs are just around the corner. Equestrian lovers, Flamborough is home to an abundance of horse facilities. Library, arena & baseball diamonds are just minutes down the road. Easy commute to many centres of Commerce (Toronto to London) and just a short drive to major highways and GO Trains (Milton & Burlington). Home inspection Report available. Don't miss out on this opportunity!!! (id:62650)" +"Basement": array:2 [ 0 => "Partially finished" 1 => "Partial" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:1 [ 0 => "Community Centre" ] +"ConstructionMaterials": array:1 [ 0 => "Wood frame" ] +"CreationDate": "2024-09-17T18:37:05.430098+00:00" +"Directions": "CENTRE RD BETWEEN PROGRESTON RD & THE 8TH CONC EAST" +"ExteriorFeatures": array:2 [ 0 => "Wood" 1 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:2 [ 0 => "Oil" 1 => "Boiler" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525314" +"ListOfficeKey": "283457" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Conservation/green belt" 1 => "Crushed stone driveway" 2 => "Country residential" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2024-09-17T18:28:09Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-09-27T17:02:59Z" +"StreetName": "CENTRE" +"StreetNumber": "1352" +"StreetSuffix": "Road" +"SubdivisionName": "044 - Flamborough East" +"TaxAnnualAmount": "5416.72" +"VirtualTourURLUnbranded": "https://youtu.be/0Wkb5VftRao?si=SDn3xuH2ZNvaooAq" +"WaterSource": array:2 [ 0 => "Drilled Well" 1 => "Well" ] +"Rooms": array:12 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27429947/1352-centre-road-carlisle" +"ParkingTotal": 6 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1525315" +"CommonInterest": "Freehold" +"CoListAgentKey2": "1677992" +"CoListOfficeKey": "268714" +"CoListOfficeKey2": "268714" +"ZoningDescription": "1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 100.0 +"AboveGradeFinishedArea": 1488 +"OriginalEntryTimestamp": "2024-09-17T17:06:55.47Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"Media": array:50 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27429947')" +"ID": "60032" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25171 +post_id: "68814" +post_author: 1 +"ListingKey": "27429955" +"ListingId": "XH4190704" +"PropertyType": "Other" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:57Z" +"ListPrice": 1.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 15000.0 +"BuildingAreaTotal": 0 +"City": "Waterdown" +"PostalCode": "L8B1Z2" +"UnparsedAddress": "39 Mallard Trail, Waterdown, Ontario L8B1Z2" +"Coordinates": array:2 [ 0 => -79.87683 1 => 43.343976 ] +"Latitude": 43.343976 +"Longitude": -79.87683 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Discover the epitome of suburban sophistication at 39 Mallard Trail, this unmatched opportunity is presented to you in a sought after growing neighborhood of Waterdown. This building permit ready development is waiting to be built for you. Featuring over 15,000 ft.² that includes 7 spacious beautifully designed residential units along with 5 commercial units complete with 13 surface parking spaces. 39 Mallard Trail is located in the heart of Waterdown South secondary plan, which is the largest residential development project currently underway in Canada. Directly across the street is Trend Living (774 units) which is expected to be completed by the end of 2024, as well as a future condo development that will consist of 600 suites, ensuring high traffic for commercial use. Permitted uses include but not limited to, clinical (dental physicians, etc. ), place of recreation, restaurant, convenience or fast food, finance institutions and more. Each 2 to 3 bedroom residential unit boasts over 1300 ft.² with two floors of living space. Convenience is key - within an eight minute drive time you will find Walmart, Aldershot GO station, Highway 403 and the QEW, with Hamilton airport only 24 minutes away. In less than 15 minutes, you can be in downtown Hamilton or Burlington. Designed by award winning developer, New Horizon Development Group, this project sets a new standard for suburban living with its dynamic architecture. (id:62650)" +"BuildingAreaUnits": "square feet" +"BusinessType": "Health Care and Social Assistance" +"CreationDate": "2024-09-17T18:36:53.761541+00:00" +"Directions": "DUNDAS TO MALLARD" +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525198" +"ListOfficeKey": "284641" +"LivingAreaUnits": "square feet" +"NumberOfUnitsTotal": "1" +"PhotosChangeTimestamp": "2024-10-03T17:10:13Z" +"PhotosCount": 4 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:37Z" +"StreetName": "MALLARD" +"StreetNumber": "39" +"StreetSuffix": "Trail" +"SubdivisionName": "461 - Waterdown East" +"TaxAnnualAmount": "1" +"WaterSource": array:2 [ 0 => "Unknown" 1 => "None" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27429955/39-mallard-trail-waterdown" +"SecurityFeatures": array:1 [ 0 => "None" ] +"ZoningDescription": "UC-13" +"FrontageLengthNumeric": 72.0 +"OriginalEntryTimestamp": "2024-09-17T17:06:57.07Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:4 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27429955')" +"ID": "68814" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170 +post_id: "99362" +post_author: 1 +"ListingKey": "27429969" +"ListingId": "XH4190512" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-22T14:15:51Z" +"RFModificationTimestamp": "2025-08-22T14:49:57Z" +"ListPrice": 865000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterdown" +"PostalCode": "L0R2H0" +"UnparsedAddress": "40-42 vacant land located at 40 42 Mill Street S, Waterdown, Ontario L0R2H0" +"Coordinates": array:2 [ 0 => -79.890618 1 => 43.333443 ] +"Latitude": 43.333443 +"Longitude": -79.890618 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of Realtors" +"PublicRemarks": "Rare infill 60 x 153 lot located in the heart of Waterdown, premium development location with municipal services along Griffin Street. Located in a highly sought-after area, commuters' dream, 5 minutes to GO Station, only steps to conservation, schools and downtown Waterdown. Seller will consider VTB financing. Subject to severance (currently underway). Seller to provide cooperation. (id:62650)" +"CreationDate": "2024-09-17T19:50:26.019245+00:00" +"Directions": "South of Dundas Street, Hwy 5 in Waterdown. Corner lot, located at the intersection of Griffin and Mill Street South." +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2191019" +"ListOfficeKey": "289709" +"PhotosChangeTimestamp": "2024-12-06T17:27:34Z" +"PhotosCount": 7 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-08-22T14:02:37Z" +"StreetDirSuffix": "South" +"StreetName": "VACANT LAND LOCATED AT 40 42 MILL" +"StreetNumber": "40" +"StreetSuffix": "Street" +"SubdivisionName": "461 - Waterdown East" +"TaxAnnualAmount": "2" +"Utilities": array:4 [ 0 => "Water" 1 => "Natural Gas" 2 => "Electricity" 3 => "Cable" ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/27429969/40-42-vacant-land-located-at-40-42-mill-street-s-waterdown" +"ZoningDescription": "R-5" +"FrontageLengthNumeric": 60.0 +"OriginalEntryTimestamp": "2024-09-17T17:07:00Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"Media": array:7 [ 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] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('27429969')" +"ID": "99362" } ] +success: true +page_size: 12 +page_count: 15660 +count: 187919 +after_key: "" } "RF Response Time" => "0.14 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27428257" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25653 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27428265" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25657 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.26 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27428550" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25654 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27428775" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25658 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27428966" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25651 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27428984" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25661 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27429114" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25650 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27429279" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25663 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.25 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27490331" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25665 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27429947" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25667 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27429955" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25669 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 27429969" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25671 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]