1655 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: 4d9e33551315611a7e8a8a68cb55a245a9b78b1b42aa10969d42ace0057d6dc4" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14730 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14916 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12288966" +"ListingId": "W12288966" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T17:46:47Z" +"RFModificationTimestamp": "2025-07-17T13:24:55Z" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7P 4M5" +"UnparsedAddress": "1508 Upper Middle Road 6, Burlington, ON L7P 4M5" +"Coordinates": array:2 [ 0 => -79.8445274 1 => 43.3567356 ] +"Latitude": 43.3567356 +"Longitude": -79.8445274 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautifully maintained three-bedroom, four-bathroom townhome in Burlington's sought-after Tyandaga neighbourhood. Within walking distance to schools, shopping, restaurants, banks, community centre, library, Bruce Trail, and Tim Hortons. This rare offering features a double car garage with inside entry, 2,200 square feet of impeccably finished living space and blends elegance, comfort and function. The bright main floor boasts hardwood floors, a spacious living room with patio doors to a private terrace and a formal dining area perfect for entertaining. The updated white, eat-in kitchen includes granite countertops, ample storage and a smart layout. The main-level primary bedroom (currently used as a family room) features a three-piece ensuite, offering flexible living options. Upstairs, two generously sized bedrooms share a renovated bath with a Calacatta marble vanity, and a spa-like bubble tub surrounded by Carrara marble. The fully finished basement provides great versatility, with a large flex space ideal for a home office or gym, a cozy rec room with wood-burning fireplace, wet bar and two-piece bathroom - perfect for entertaining or relaxing. Located in a quiet, tree-lined community, this home combines timeless charm with modern updates. Ideal for families, professionals, or downsizers seeking space, style, and location in one of Burlington's most established neighbourhoods. RSA." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AssociationAmenities": array:3 [ 0 => "BBQs Allowed" 1 => "Indoor Pool" 2 => "Outdoor Pool" ] +"AssociationFee": "630.0" +"AssociationFeeIncludes": array:3 [ 0 => "Common Elements Included" 1 => "Building Insurance Included" 2 => "Parking Included" ] +"Basement": array:1 [ 0 => "Full" ] +"BuildingName": "Halton Standard Condominium" +"CityRegion": "Tyandaga" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-16T18:17:30.472403+00:00" +"CrossStreet": "Brant St" +"Directions": "Dundas St to Brant St to Upper Middle Rd" +"Exclusions": "Main Level Primary Bed Wall Unit, Mirror at Gold Sink, Bedroom Window Swag" +"ExpirationDate": "2025-09-24" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"FireplaceFeatures": array:1 [ 0 => "Wood" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "CVAC Attachments, GDO Remotes (x2), Basement Fridge, Electrical Light Fixtures. All inclusions in "As In" condition. Built-in Microwave, Carbon Monoxide Detector, Central Vac Garage Door Opener, Refrigerator, Stove, Washer, Window Coverings, Dishwasher, Dryer" +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "Bar Fridge" 2 => "Garburator" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-16" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-16T17:46:47Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-16T17:46:47Z" +"OriginalListPrice": 899900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2721928" +"ParcelNumber": "258790018" +"ParkingFeatures": array:2 [ 0 => "Inside Entry" 1 => "Underground" ] +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-16T17:46:47Z" +"Roof": array:1 [ 0 => "Asphalt Rolled" ] +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper Middle" +"StreetNumber": "1508" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3517.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UnitNumber": "6" +"Zoning": "RL5-183" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12288966')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240202020023006" +"SurveyType": "None" +"BalconyType": "Terrace" +"RentalItems": "HOT WATER HEATER" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"WaterMeterYN": true +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Burlington, ON L7P 4M5, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CondoCorpNumber": 124 +"DenFamilyroomYN": true +"LivingAreaRange": "1400-1599" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 2 +"PropertyFeatures": array:6 [ 0 => "Golf" 1 => "Park" 2 => "Place Of Worship" 3 => "Public Transit" 4 => "Rec./Commun.Centre" 5 => "School" ] +"SquareFootSource": "LBO PROVIDED" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-297-7777" +"StatusCertificateYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2025-07-16T17:46:47Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2025-07-16T17:46:49.062213Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:48 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "9a3c44a4-bf29-4a43-89aa-10aa024206cd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/da3c4517faed3a55a6c0d319013f8baf.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 765015 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-da3c4517faed3a55a6c0d319013f8baf.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "9a3c44a4-bf29-4a43-89aa-10aa024206cd" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "9a3c44a4-bf29-4a43-89aa-10aa024206cd" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "eb654a7d-4ec1-4772-a2a3-48d299978720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/68201096816bd694106d9d0bbf2762c9.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 795862 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-68201096816bd694106d9d0bbf2762c9.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "eb654a7d-4ec1-4772-a2a3-48d299978720" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "eb654a7d-4ec1-4772-a2a3-48d299978720" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "31129afd-59c7-4148-adfd-bedb146c5d9d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/0b4c9c62f06b146ab926b68127f4b5d2.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 950565 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-0b4c9c62f06b146ab926b68127f4b5d2.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "31129afd-59c7-4148-adfd-bedb146c5d9d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "31129afd-59c7-4148-adfd-bedb146c5d9d" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "0ac8fe24-0586-4d4d-b96f-95cc6c85930a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/8af2724767a0d94b8099ad7621c84c6d.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 693672 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-8af2724767a0d94b8099ad7621c84c6d.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "0ac8fe24-0586-4d4d-b96f-95cc6c85930a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "0ac8fe24-0586-4d4d-b96f-95cc6c85930a" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "7319518b-b235-4ad7-9565-ff6fcaea560c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/327b546ad6e996b6f4c84bf88768ea00.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 526474 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-327b546ad6e996b6f4c84bf88768ea00.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "7319518b-b235-4ad7-9565-ff6fcaea560c" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "7319518b-b235-4ad7-9565-ff6fcaea560c" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "6229e28a-b142-4bb1-bd7e-9413be0969c9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/8d9154ff2177113787077ea80ee5eafa.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 390496 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-8d9154ff2177113787077ea80ee5eafa.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "6229e28a-b142-4bb1-bd7e-9413be0969c9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "6229e28a-b142-4bb1-bd7e-9413be0969c9" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "bf3a8d08-3a98-413a-8975-f54b280de0af" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/5766865e06bbb15508729de896d96543.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 387130 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-5766865e06bbb15508729de896d96543.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "bf3a8d08-3a98-413a-8975-f54b280de0af" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "bf3a8d08-3a98-413a-8975-f54b280de0af" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "1438caf6-2ab2-4ad3-82d4-180764e306d4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/01495332c758c3b836597f4b2caefde3.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 517434 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-01495332c758c3b836597f4b2caefde3.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "1438caf6-2ab2-4ad3-82d4-180764e306d4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "1438caf6-2ab2-4ad3-82d4-180764e306d4" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "96761337-a4f3-4ca0-abb7-3d145a6b0b21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/87f95c502336ecd55bce27fdc23ffa64.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 521663 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-87f95c502336ecd55bce27fdc23ffa64.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "96761337-a4f3-4ca0-abb7-3d145a6b0b21" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "96761337-a4f3-4ca0-abb7-3d145a6b0b21" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "72299559-c226-4622-b8c0-a2c323c14e60" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/6259e977e7ef43552f730a068063f9ec.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 491949 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-6259e977e7ef43552f730a068063f9ec.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "72299559-c226-4622-b8c0-a2c323c14e60" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "72299559-c226-4622-b8c0-a2c323c14e60" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "6eda0be0-17c7-4511-b025-8893a06312d7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/7631adf4f649ab53a9c4f39f9c815aa8.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 395028 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-7631adf4f649ab53a9c4f39f9c815aa8.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "6eda0be0-17c7-4511-b025-8893a06312d7" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "6eda0be0-17c7-4511-b025-8893a06312d7" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "9142227a-2b22-47ee-b8b4-f0479b4b5ea4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/34f39cae2e9e0adb8a24837ccb1d6a33.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 408976 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-34f39cae2e9e0adb8a24837ccb1d6a33.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "9142227a-2b22-47ee-b8b4-f0479b4b5ea4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "9142227a-2b22-47ee-b8b4-f0479b4b5ea4" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "3a444042-4b95-4332-ba05-e1e81584984b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/0ac09f388aadbd1e3016859a2a01583c.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 260649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-0ac09f388aadbd1e3016859a2a01583c.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3a444042-4b95-4332-ba05-e1e81584984b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3a444042-4b95-4332-ba05-e1e81584984b" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "08ab11c4-ce7b-41d4-be0c-88ea1f42eba3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/8d6f86938e25916f012a3b870cc027f3.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 394224 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-8d6f86938e25916f012a3b870cc027f3.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "08ab11c4-ce7b-41d4-be0c-88ea1f42eba3" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "08ab11c4-ce7b-41d4-be0c-88ea1f42eba3" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "d2eea4ac-46d5-45ae-a5f3-214bab3a3962" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/e155c3ebc9b7d20e2fdc7a16aeaabf5b.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 379794 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-e155c3ebc9b7d20e2fdc7a16aeaabf5b.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "d2eea4ac-46d5-45ae-a5f3-214bab3a3962" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "d2eea4ac-46d5-45ae-a5f3-214bab3a3962" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 15 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "cb62aedd-eaab-4687-a34a-13319fbf592e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/dd89cc90959a3bc6c5d4fc83b460d2f6.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 492737 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-dd89cc90959a3bc6c5d4fc83b460d2f6.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "cb62aedd-eaab-4687-a34a-13319fbf592e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "cb62aedd-eaab-4687-a34a-13319fbf592e" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 16 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "0a63ca70-061d-406c-8d5e-c043e5a4274e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/3293fb0e0f5adee835560ed2ffa78b2c.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 514475 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-3293fb0e0f5adee835560ed2ffa78b2c.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "0a63ca70-061d-406c-8d5e-c043e5a4274e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "0a63ca70-061d-406c-8d5e-c043e5a4274e" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 17 => array:26 [ "Order" => 17 "ImageOf" => null "MediaKey" => "b51b255c-a721-496f-8539-a665266d1303" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/453e01b8ff69bfa40133495308250640.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 537076 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-453e01b8ff69bfa40133495308250640.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b51b255c-a721-496f-8539-a665266d1303" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b51b255c-a721-496f-8539-a665266d1303" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 18 => array:26 [ "Order" => 18 "ImageOf" => null "MediaKey" => "387b73ce-0dc5-47fc-a05a-c1a44dd252b1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/629e82d1d60f695760d4489ca9e6b9b4.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 484145 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-629e82d1d60f695760d4489ca9e6b9b4.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "387b73ce-0dc5-47fc-a05a-c1a44dd252b1" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "387b73ce-0dc5-47fc-a05a-c1a44dd252b1" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 19 => array:26 [ "Order" => 19 "ImageOf" => null "MediaKey" => "59915d70-09d7-499d-b352-81f5d46b26db" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/9469f14c274b93ee75d9585e531b890c.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 394399 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-9469f14c274b93ee75d9585e531b890c.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "59915d70-09d7-499d-b352-81f5d46b26db" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "59915d70-09d7-499d-b352-81f5d46b26db" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 20 => array:26 [ "Order" => 20 "ImageOf" => null "MediaKey" => "4fae1b3b-f553-41ad-b712-43db1644153e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/ef91121a61ae94a7d8c30db2292112dd.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 374856 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-ef91121a61ae94a7d8c30db2292112dd.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4fae1b3b-f553-41ad-b712-43db1644153e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "W12288966" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4fae1b3b-f553-41ad-b712-43db1644153e" "ModificationTimestamp" => "2025-07-16T17:46:47.786059Z" "MediaModificationTimestamp" => "2025-07-16T17:46:47.786059Z" ] 21 => array:26 [ "Order" => 21 "ImageOf" => null "MediaKey" => "7725d130-951f-4d8f-a239-3791a3933a60" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W12288966/20425dda54c7caeaf06929877187c3f7.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 369221 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W12288966/thumbnail-20425dda54c7caeaf06929877187c3f7.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1368 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "7725d130-951f-4d8f-a239-3791a3933a60" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" …5 ] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14917 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12238998" +"ListingId": "W12238998" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T16:55:26Z" +"RFModificationTimestamp": "2025-07-16T17:07:13Z" +"ListPrice": 1199000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7M 1W4" +"UnparsedAddress": "3354 Bristol Drive, Burlington, ON L7M 1W4" +"Coordinates": array:2 [ 0 => -79.8041935 1 => 43.3691539 ] +"Latitude": 43.3691539 +"Longitude": -79.8041935 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located in the sought-after Palmer community, this beautifully updated 3+1 bedroom raised bungalow is an entertainers dream. With approximately 2,200 sq ft of finished living space and thousands invested in professional landscaping, the backyard oasis features a saltwater pool and a custom-built Tiki Hut with a fully equipped outdoor kitchen - complete with a gas BBQ, gas stovetop, fridge, built-in storage, and multiple seating areas designed for relaxation and entertaining. Inside, you're welcomed into a bright and spacious living and dining area, alongside a sun-filled eat-in kitchen with walkout to a private side deck that leads seamlessly to the backyard retreat. The fully finished lower level includes a fourth bedroom, a large recreation room with a cozy wood-burning fireplace, a bar, and a 3-piece bathroom - perfect for guests or extended family. Ideally located just steps to elementary schools, parks, shopping, and transit, this exceptional home offers the perfect blend of comfort, style, and outdoor luxury living." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow-Raised" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Palmer" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Halton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-23T13:45:56.628840+00:00" +"CrossStreet": "PALMER /WALKERS" +"DirectionFaces": "North" +"Directions": "Palmer to Wiltshire Ave to Bristol Drive" +"ExpirationDate": "2025-10-20" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Wood" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Dishwasher, Dryer, Garage Door Opener, Pool Equipment, Smoke Detector, Washer, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-20" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-16T16:55:26Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-23T13:20:20Z" +"OriginalListPrice": 1289000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2598306" +"OtherStructures": array:1 [ 0 => "Gazebo" ] +"ParcelNumber": "071670061" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-23T13:20:20Z" +"PoolFeatures": array:1 [ 0 => "Inground" ] +"PreviousListPrice": 1289000.0 +"PriceChangeTimestamp": "2025-07-16T16:55:25Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SoilType": array:1 [ 0 => "Other" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "BRISTOL" +"StreetNumber": "3354" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4809.0" +"TaxLegalDescription": "PCL 1-1, SEC M121; LT 1, PL M121; S/T H49600. CITY OF BURLINGTON" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Level" ] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Pool" ] +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.0 +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12238998')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240209090363500" +"SurveyType": "None" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"WaterMeterYN": true +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 2 +"PropertyFeatures": array:4 [ 0 => "Level" 1 => "Public Transit" 2 => "School" 3 => "Wooded/Treed" ] +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2025-06-23T13:20:20Z" +"SystemModificationTimestamp": "2025-07-16T16:55:28.506331Z" +"Media": array:20 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14923 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12288555" +"ListingId": "W12288555" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T16:13:06Z" +"RFModificationTimestamp": "2025-07-17T07:47:25Z" +"ListPrice": 1999900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L 5N1" +"UnparsedAddress": "4302 Shoreacres Place, Burlington, ON L7L 5N1" +"Coordinates": array:2 [ 0 => -79.758902 1 => 43.359924 ] +"Latitude": 43.359924 +"Longitude": -79.758902 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Timeless elegance are the hallmarks of this iconic home situated on a tranquil peaceful ravine setting in prestigious Shoreacres. This property is a masterpiece of functionality, offering an extraordinary lifestyle in one of Burlingtons coveted neighbourhoods. The home has all the must haves including an open concept eat-in kitchen with a large island which overlooks the great room with fireplace creating a welcoming atmosphere for family and guests. Spacious separate dining and living room. The primary bedroom is a luxurious sanctuary with custom closets, spa-like ensuite and balcony. Down the hall, you will find the additional bedrooms which are all generous in size. An amazing self contained private nanny or in-law suite accessible by a 2nd staircase. Finished lower level rec room, gym and plenty of storage. Ideal teenage haven. The south facing rear yard is a true oasis. Beautifully landscaped grounds include a deck with hot-tub, patio, lush greenery and privacy. This location cannot be beat! Within minutes to the the lake, GO, shopping, restaurants and top rated schools." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Shoreacres" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-16T16:23:58.259032+00:00" +"CrossStreet": "Shoreacres Rd" +"DirectionFaces": "South" +"Directions": "SHOREACRES ROAD TO SHOREACRES PLACE" +"ExpirationDate": "2025-10-31" +"ExteriorFeatures": array:2 [ 0 => "Hot Tub" 1 => "Privacy" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Gas Stove, Hot Tub Equipment, Refrigerator, Stove, Washer, Window Coverings" +"InteriorFeatures": array:2 [ 0 => "Auto Garage Door Remote" 1 => "In-Law Suite" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-16T16:13:06Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-16T16:13:06Z" +"OriginalListPrice": 1999900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2721614" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-07-16T16:13:06Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "SHOREACRES" +"StreetNumber": "4302" +"StreetSuffix": "Place" +"TaxAnnualAmount": "9475.35" +"TaxLegalDescription": "PCL 22-1 , SEC M211 ; LT 22 , PL M211 ; S/T H125471 BURLINGTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/4302_shoreacres_pl_burlington_on/" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 122.0 +"LotWidth": 70.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12288555')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Burlington, ON L7L 5N1, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 8 +"PropertyFeatures": array:6 [ 0 => "Hospital" 1 => "Lake/Pond" 2 => "Park" 3 => "Public Transit" 4 => "Ravine" 5 => "School" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-297-7777" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2025-07-16T16:13:06Z" +"SystemModificationTimestamp": "2025-07-16T16:13:08.389203Z" +"Media": array:47 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14920 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12287878" +"ListingId": "W12287878" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T13:57:15Z" +"RFModificationTimestamp": "2025-07-17T13:24:50Z" +"ListPrice": 1995000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 1.8 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7T 0B5" +"UnparsedAddress": "266 Sumach Drive, Burlington, ON L7T 0B5" +"Coordinates": array:2 [ 0 => -79.8669862 1 => 43.3042909 ] +"Latitude": 43.3042909 +"Longitude": -79.8669862 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Real Broker Ontario Ltd." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located on a stunning 1.8-acre lot backing onto peaceful green space, this impressive all-brick two-storey home offers exceptional living space and versatility. With five bedrooms, four full bathrooms, and two full kitchens, its ideal for large families or multi-generational living. The main floor showcases a private office/den, formal dining room, spacious family room with fireplace, convenient laundry, and a bright eat-in kitchen with stainless steel appliances, tiled backsplash, island, and walkout to a covered back porch. Upstairs, the primary suite features a walk-in closet and a spacious 5-piece ensuite. The fully finished walkout basement includes a second kitchen, additional bedroom, 3-piece bath, cozy recreational room with fireplace, and direct access to the backyard. Located just steps from parks and trails, and close to transit, highways, schools, and amenities this is a rare opportunity with endless potential. Don't miss it!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished with Walk-Out" 1 => "Separate Entrance" ] +"CityRegion": "Bayview" +"CoListOfficeName": "Real Broker Ontario Ltd." +"CoListOfficePhone": "888-311-1172" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-16T14:07:56.550465+00:00" +"CrossStreet": "Lemonville and Sumach" +"DirectionFaces": "South" +"Directions": "Lemonville Rd to Sumach Dr" +"ExpirationDate": "2025-10-24" +"ExteriorFeatures": array:2 [ 0 => "Deck" 1 => "Privacy" ] +"FireplaceFeatures": array:1 [ 0 => "Wood" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "all existing light fixtures and appliances" +"InteriorFeatures": array:2 [ 0 => "In-Law Capability" 1 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-07-16" +"LotSizeSource": "MPAC" +"MainOfficeKey": "536900" +"MajorChangeTimestamp": "2025-07-16T13:57:15Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-16T13:57:15Z" +"OriginalListPrice": 1995000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2714692" +"ParcelNumber": "071240010" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2025-07-16T13:57:15Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sumach" +"StreetNumber": "266" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "10760.76" +"TaxLegalDescription": "PT LT 9 , CON 1 , PART 2 , 20R9331 ; BURLINGTON/E FLAM TWP" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%+hst" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/266_sumach_dr_burlington_on/" +"Zoning": "R2.4, PC" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 249.97 +"LotShape": "Irregular" +"LotWidth": 99.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12287878')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240201010611200" +"SurveyType": "Unknown" +"LaundryLevel": "Main Level" +"KitchensTotal": 2 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"short_address": "Burlington, ON L7T 0B5, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 15 +"RoomsBelowGrade": 8 +"LotSizeAreaUnits": "Acres" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-07-16T13:57:15Z" +"SystemModificationTimestamp": "2025-07-16T13:57:16.44261Z" +"Media": array:38 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14915 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12273042" +"ListingId": "W12273042" +"PropertyType": "Residential Lease" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T13:43:53Z" +"RFModificationTimestamp": "2025-07-16T14:18:12Z" +"ListPrice": 3750.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7M 0K9" +"UnparsedAddress": "3346 Mikalda Road, Burlington, ON L7M 0K9" +"Coordinates": array:2 [ 0 => -79.8206917 1 => 43.4109024 ] +"Latitude": 43.4109024 +"Longitude": -79.8206917 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE TERREQUITY GOLD REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this bright, spacious and private end-unit townhome, located in the family-friendly community of Alton Village. Offering approximately 1,734 sq. ft. of well-designed living space, this home features 3+1 bedrooms and 3.5 bathrooms. Enjoy quality finishes throughout, including laminate and hardwood flooring, California shutters, stainless steel appliances, and upgraded lighting with motion sensors. The basement bathroom includes a relaxing jacuzzi tub, perfect for unwinding. The open-concept kitchen and family room with a cozy fireplace create an inviting space for everyday living and entertaining. The fully finished basement is flooded with natural light and can easily serve as a fourth bedroom or a spacious recreation area including a wet bar Ideally located just 3 minutes from Highway 407 and within walking distance to top-rated schools, parks, grocery stores, restaurants, shopping, and a state-of-the-art community centre. This corner house features a private backyard and a unique fenced side yard with lots of trees and planters to grow your own vegetables and flowers. The enclosed front porch allows you to enjoy the view of your garden and extends your outside experience into early spring and fall." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Alton" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Halton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-09T15:16:32.344376+00:00" +"CrossStreet": "Appleby Line & Dundas St." +"DirectionFaces": "West" +"Directions": "Appleby Line - Thomas Alton Blvd to Mikalda Rd" +"Exclusions": "None" +"ExpirationDate": "2025-09-30" +"ExteriorFeatures": array:2 [ 0 => "Deck" 1 => "Porch Enclosed" ] +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Fridge, Stove, Microwave, Washer & Dryer" +"InteriorFeatures": array:9 [ 0 => "Auto Garage Door Remote" 1 => "Floor Drain" 2 => "On Demand Water Heater" 3 => "Primary Bedroom - Main Floor" 4 => "Storage" 5 => "Sump Pump" 6 => "Ventilation System" 7 => "Water Heater Owned" 8 => "Water Meter" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ 0 => "In Basement" 1 => "Laundry Room" 2 => "Sink" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "429200" +"MajorChangeTimestamp": "2025-07-16T13:43:53Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-09T15:03:52Z" +"OriginalListPrice": 3850.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2679192" +"OtherStructures": array:2 [ 0 => "Fence - Full" 1 => "Garden Shed" ] +"ParcelNumber": "072022472" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-07-09T15:03:53Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 3850.0 +"PriceChangeTimestamp": "2025-07-16T13:43:53Z" +"RentIncludes": array:2 [ 0 => "Central Air Conditioning" 1 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:5 [ 0 => "Alarm System" 1 => "Carbon Monoxide Detectors" 2 => "Cold Alarm" 3 => "Heat Detector" 4 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mikalda" +"StreetNumber": "3346" +"StreetSuffix": "Road" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "1/2 Month's Rent + HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 140.7 +"LotShape": "Pie" +"LotWidth": 58.01 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12273042')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240203030918298" +"SurveyType": "Unknown" +"ElectricYNA": "Available" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 3 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"PossessionDate": "2025-08-15" +"PossessionType": "1-29 days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 1 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Rec./Commun.Centre" 5 => "School" ] +"LotSizeRangeAcres": "< .50" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Ground" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-07-09T15:03:53Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-07-16T13:43:56.164402Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:16 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14894 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12151241" +"ListingId": "W12151241" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T13:13:14Z" +"RFModificationTimestamp": "2025-07-16T13:20:14Z" +"ListPrice": 1797000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L 7K5" +"UnparsedAddress": "2170 Coldwater Street, Burlington, ON L7L 7K5" +"Coordinates": array:2 [ 0 => -79.7835302 1 => 43.4035148 ] +"Latitude": 43.4035148 +"Longitude": -79.7835302 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to your dream home in Burlingtons sought-after Orchard neighbourhood! This stunning detached residence offers nearly 4,000 sq ft of beautifully finished living space and backs directly onto serene green space - your private backyard oasis awaits. Enjoy summer days in the saltwater pool and unwind year-round in the jacuzzi hot tub. Inside, youll find tasteful updates throughout, including brand new countertops and a stylish backsplash in the kitchen, and all new windows that flood the home with natural light. Upstairs offers three generously sized bedrooms along with an expansive primary bedroom, complete with a luxurious ensuite. The fully finished basement adds even more living space, including a bonus bedroom perfect for guests or a home office. This is a rare combination of comfort, elegance, and lifestyle in one of Burlingtons premier family communities." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Orchard" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Brick Front" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-05-15T17:55:22.769230+00:00" +"CrossStreet": "Sutton" +"DirectionFaces": "South" +"Directions": "Upper Middle to Sutton, left on Coldwater Street" +"ExpirationDate": "2025-09-01" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, Window Coverings, Hot Tub, Smart Thermostat" +"InteriorFeatures": array:2 [ 0 => "Auto Garage Door Remote" 1 => "Rough-In Bath" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-16T13:13:14Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-05-15T17:00:31Z" +"OriginalListPrice": 1848000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2397762" +"ParcelNumber": "071842894" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-05-15T17:00:32Z" +"PoolFeatures": array:2 [ 0 => "Inground" 1 => "Salt" ] +"PreviousListPrice": 1848000.0 +"PriceChangeTimestamp": "2025-07-16T13:13:14Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:4 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" 3 => "List Salesperson" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Coldwater" +"StreetNumber": "2170" +"StreetSuffix": "Street" +"TaxAnnualAmount": "7225.86" +"TaxAssessedValue": 787000 +"TaxLegalDescription": "LT 89, PL 20M854; BURLINGTON. S/T RT HR201288. S/T EASE HR186333 OVER PT 76, 20R15026. S/T EASE HR188054 OVER PT 76, 20R15026, S/T RIGHT HR258044" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://viralrealestate.media/2170-coldwater-st" +"VirtualTourURLBranded2": "https://my.matterport.com/show/?m=Ww F2e MZHQEB" +"VirtualTourURLUnbranded2": "https://vimeo.com/1084464024" +"Zoning": "RO3, O2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 99.41 +"LotWidth": 41.54 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12151241')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240209090202678" +"SurveyType": "Unknown" +"RentalItems": "None" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Hot Water Tank-Gas" ] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-08-30" +"PossessionType": "90+ days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 9 +"PropertyFeatures": array:6 [ 0 => "Public Transit" 1 => "School" 2 => "Park" 3 => "Ravine" 4 => "Library" 5 => "School Bus Route" ] +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"ShowingAppointments": "Broker Bay or 905-297-7777" +"MediaChangeTimestamp": "2025-05-15T17:00:32Z" +"SystemModificationTimestamp": "2025-07-16T13:13:18.265826Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14893 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12287645" +"ListingId": "W12287645" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T13:03:10Z" +"RFModificationTimestamp": "2025-07-17T13:24:48Z" +"ListPrice": 770000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7N 2Z9" +"UnparsedAddress": "453 Woodview Road 7, Burlington, ON L7N 2Z9" +"Coordinates": array:2 [ 0 => -79.7743871 1 => 43.3488068 ] +"Latitude": 43.3488068 +"Longitude": -79.7743871 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this stunning and spacious 3-bedroom corner-unit townhome located in South Burlingtons desirable Woodview Park neighborhood!This bright and beautifully maintained home offers a fantastic layout, ideal for families or professionals. Enjoy easy access to top-rated schools, parks, public transit, and all the amenities you need. The nearby Centennial Bike Path offers a scenic route for walking or cycling to downtown Burlingtons vibrant shops, restaurants, and the lakefront.The finished lower level adds versatility with a recreation room and a flexible space perfect for a playroom, home gym, or office. Enjoy a private driveway and attached garage, plus ample visitor parking for your guests convenience.Tucked away in a well-managed enclave surrounded by mature trees, this home offers both privacy and community charm.Extras include: Fridge Stove Dishwasher Washer & Dryer All electrical light fixtures All window coverings All bathroom mirrors.Enjoy summer living in comfort and style as this one wont last!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AssociationFee": "598.0" +"AssociationFeeIncludes": array:3 [ 0 => "Water Included" 1 => "Building Insurance Included" 2 => "Parking Included" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Roseland" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-16T13:08:56.913658+00:00" +"CrossStreet": "NEW STREET TO WOODVIEW" +"Directions": "NEW STREET" +"ExpirationDate": "2026-07-16" +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Auto Garage Door Remote" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-14" +"LotSizeSource": "MPAC" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2025-07-16T13:03:10Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-16T13:03:10Z" +"OriginalListPrice": 770000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2719900" +"ParcelNumber": "079160093" +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-16T13:03:10Z" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Woodview" +"StreetNumber": "453" +"StreetSuffix": "Road" +"TaxAnnualAmount": "2848.75" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% +HST" +"TransactionType": "For Sale" +"UnitNumber": "7" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12287645')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240207070615758" +"SurveyType": "None" +"BalconyType": "None" +"RentalItems": "hot water tank" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"LegalStories": "1" +"ParkingType1": "Owned" +"KitchensTotal": 2 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Burlington, ON L7N 2Z9, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-09-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 17 +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 2 +"SquareFootSource": "AS PER SELLER" +"PossessionDetails": "30-60-90" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "33" +"MediaChangeTimestamp": "2025-07-16T13:03:10Z" +"PropertyManagementCompany": "WILSON BLANCHARD" +"SystemModificationTimestamp": "2025-07-16T13:03:11.993677Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:34 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14892 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12227397" +"ListingId": "W12227397" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T12:42:36Z" +"RFModificationTimestamp": "2025-07-16T12:46:37Z" +"ListPrice": 1227000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L 5A3" +"UnparsedAddress": "4300 Longmoor Drive, Burlington, ON L7L 5A3" +"Coordinates": array:2 [ 0 => -79.7688832 1 => 43.36542 ] +"Latitude": 43.36542 +"Longitude": -79.7688832 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 4300 Longmoor Drive, Burlington! Pride of ownership shines in this beautifully 2286 SQ FT, updated 3-bedroom, 2.5-bath side-split family home with a double garage, nestled in the highly sought-after Longmoor neighbourhood of South Burlington, near the scenic, tree-lined banks of Shoreacres Creek. It's conveniently located just minutes from Appleby GO Station, QEW, Nelson Rec Centre & Pool, top-rated schools, shopping, parks, and the Centennial Bike Path. This spacious upper level features a bright eat-in kitchen with a skylight and ample cabinetry, flowing into a generous dining area and living room, great for family gatherings. Three well-sized bedrooms, including a primary bedroom with a private 2-piece ensuite, and a main bathroom with dual sinks for added convenience. The main floor family room showcases a cozy gas fireplace and sliding doors onto a large patio. The renovated lower level (2023) is filled with natural light from above-grade windows, rec room, 4th bedroom, 3-piece bath, garage access, and a spacious crawl space for extra storage. Enjoy your ultra-private backyard retreat, beautifully landscaped with a rare heated 18 x 36 in-ground pool and diving board, perfect for entertaining or relaxing. Recent updates include: windows (2015/16), fence (2018), pool liner & heater (2018), garage door (2018), A/C (2019), washing machine (2021), sliding & backyard doors (2022), attic insulation upgrade (2023), basement renovation (2023), and roof (2023). Don't miss this exceptional opportunity to own a spacious, beautifully maintained home in one of Burlington's most desirable communities. Book your private showing today!" +"ArchitecturalStyle": array:1 [ 0 => "Sidesplit" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Shoreacres" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-17T20:10:14.783944+00:00" +"CrossStreet": "Appleby Line & New" +"DirectionFaces": "South" +"Directions": "Appleby Line - west on Longmoor Dr" +"Exclusions": "Hot Water Heater" +"ExpirationDate": "2025-09-17" +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Fridge, Stovetop, Wall Oven, D/W, Micro, Washer, Dryer, Hood Fan (Light non-functional), All Window Covers, All Electrical Light Fixtures, Family Room Shelving Units, All Pool Equipment, All Backyard Furniture, Garage Door Opener (2) & Remotes (4)" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-17" +"LotSizeSource": "MPAC" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2025-06-17T19:45:43Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-17T19:45:43Z" +"OriginalListPrice": 1227000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2569788" +"ParcelNumber": "070310170" +"ParkingFeatures": array:2 [ 0 => "Private Double" 1 => "Front Yard Parking" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-06-17T19:45:44Z" +"PoolFeatures": array:1 [ 0 => "Inground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Longmoor" +"StreetNumber": "4300" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5435.16" +"TaxLegalDescription": "LT 165 , PL 1528 ; S/T 357475 BURLINGTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://youtu.be/XM9OJEQ9_vw" +"Zoning": "R3.2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.0 +"LotWidth": 60.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12227397')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "240209090527405" +"SurveyType": "None" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 10 +"PropertyFeatures": array:5 [ 0 => "Park" 1 => "Fenced Yard" 2 => "Public Transit" 3 => "School" 4 => "Rec./Commun.Centre" ] +"PossessionDetails": "TBD/Flexible" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Upper" +"WashroomsType2Level": "Upper" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2025-06-17T19:45:44Z" +"SystemModificationTimestamp": "2025-07-16T12:42:39.00322Z" +"Media": array:48 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14891 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12287478" +"ListingId": "W12287478" +"PropertyType": "Residential Lease" +"PropertySubType": "Other" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T10:49:41Z" +"RFModificationTimestamp": "2025-07-17T13:24:47Z" +"ListPrice": 1895.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7R 3T3" +"UnparsedAddress": "2350 Queensway Drive 1, Burlington, ON L7R 3T3" +"Coordinates": array:2 [ 0 => -79.8074382 1 => 43.348152 ] +"Latitude": 43.348152 +"Longitude": -79.8074382 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ABOUTOWNE REALTY CORP." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located at 2350 Queensway Drive, Burlington, this newly renovated and clean one-bedroom, one-bath apartment is perfect for those seeking comfort and convenience. The modern updates offer a fresh and inviting space. Situated close to major highways like the QEW and 403, commuting is a breeze. Public transportation options are easily accessible, and you'll find a variety of amenities nearby, including grocery stores, restaurants, and parks. Enjoy a peaceful neighborhood with quick access to the vibrant downtown Burlington area, shopping centers, and waterfront attractions." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"Basement": array:1 [ 0 => "Apartment" ] +"CityRegion": "Freeman" +"ConstructionMaterials": array:1 [ 0 => "Brick Front" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CreationDate": "2025-07-16T10:53:27.617983+00:00" +"CrossStreet": "QUEENSWAY AND CLETA" +"DirectionFaces": "South" +"Directions": "QUEENSWAY AND CLETA" +"ExpirationDate": "2025-12-31" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Furnished": "Unfurnished" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Coin Operated" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-16" +"MainOfficeKey": "083600" +"MajorChangeTimestamp": "2025-07-16T10:49:41Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-16T10:49:41Z" +"OriginalListPrice": 1895.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2719804" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-07-16T10:49:41Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Flat" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queensway" +"StreetNumber": "2350" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "1/2 MONTH'S RENT" +"TransactionType": "For Lease" +"UnitNumber": "1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12287478')" +"GarageType": "None" +"HeatSource": "Other" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Burlington, ON L7R 3T3, CA" +"ContractStatus": "Available" +"PossessionDate": "2025-08-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DenFamilyroomYN": true +"DepositRequired": true +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 5 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Flat" +"MediaChangeTimestamp": "2025-07-16T10:49:41Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-07-16T10:49:41.985298Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:31 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14890 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12287297" +"ListingId": "W12287297" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-16T02:23:32Z" +"RFModificationTimestamp": "2025-07-16T15:25:45Z" +"ListPrice": 1900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 4676.14 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Burlington" +"PostalCode": "L7L 6Z7" +"UnparsedAddress": "5358 Applegarth Drive Lower, Burlington, ON L7L 6Z7" +"Coordinates": array:2 [ 0 => -79.7966835 1 => 43.3248924 ] +"Latitude": 43.3248924 +"Longitude": -79.7966835 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Lepage Real Estate Associates" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Be the first to live in this brand new LEGAL lower level suite in Burlington's sought after Orchard community. Rent includes heat, hydro, water! Separate entrance and fully self-contained, soundproofed suite. Bright with ample natural light and beautifully finished in a current style including: LVP flooring, smooth ceilings, pot lights and matte black hardware throughout. Open concept kitchen with breakfast area, white cabinetry, quartz counters, full size stainless steel appliances, and centre island. Ensuite front loading washer and dryer. Stylish 3 piece bathroom with large walk-in shower and trendy details. Comfortably sized rooms including a separate bedroom. Parking available on the driveway for one vehicle. Window blinds will be installed by the Landlord. Water softening system in the home for added benefit. Amazing location, next door to greenspace at Emerson Park + nearby Bronte Creek Provincial Park. Transit, grocery, numerous restaurants, shopping all within moments of the home. No smokers, no pets. Only A+ Tenant applicants will be considered. Available for immediate occupancy." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Apartment" 1 => "Separate Entrance" ] +"CityRegion": "Orchard" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CreationDate": "2025-07-16T02:10:21.956599+00:00" +"CrossStreet": "Sutton Dr & Easton Rd" +"DirectionFaces": "West" +"Directions": "Use Google Maps" +"Exclusions": "Cable TV. Internet is negotiable." +"ExpirationDate": "2025-10-15" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Heat, hydro and water utilities, stainless steel fridge, stove, dishwasher, microwave/range-hood, white front loading washer and dryer. All existing light fixtures, window blinds (to be installed)." +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "101200" +"MajorChangeTimestamp": "2025-07-16T02:04:02Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-16T02:04:02Z" +"OriginalListPrice": 1900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2712932" +"ParcelNumber": "071842076" +"ParkingFeatures": array:1 [ 0 => "Mutual" ] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-07-16T02:04:03Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:7 [ 0 => "Central Air Conditioning" 1 => "Grounds Maintenance" 2 => "Exterior Maintenance" 3 => "Hydro" 4 => "Parking" 5 => "Water" 6 => "Heat" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Applegarth" +"StreetNumber": "5358" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "Half Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "Lower" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 84.45 +"LotWidth": 54.82 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12287297')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "240209090216696" +"SurveyType": "None" +"HoldoverDays": 60 +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 4 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:5 [ 0 => "Park" 1 => "Public Transit" 2 => "Place Of Worship" 3 => "Rec./Commun.Centre" 4 => "School" ] +"PossessionDetails": "Immediate/TBA" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Basement" +"MediaChangeTimestamp": "2025-07-16T02:04:03Z" +"PortionPropertyLease": array:1 [ 0 => "Basement" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-07-16T02:23:33.447879Z" +"VendorPropertyInfoStatement": true +"Media": array:25 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 166 +count: 1655 +after_key: "" } ] ]
