array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29993821 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1596597"
+post_author: 1
+"ListingKey": "29993821"
+"ListingId": "W13527128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T16:45:12Z"
+"RFModificationTimestamp": "2026-07-06T19:32:24Z"
+"ListPrice": 945000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Roseland)"
+"PostalCode": "L7N1N1"
+"UnparsedAddress": "19 - 3333 NEW STREET, Burlington (Roseland), Ontario L7N1N1"
+"Coordinates": array:2 [
0 => -79.775115
1 => 43.348656
]
+"Latitude": 43.348656
+"Longitude": -79.775115
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled within the highly sought-after Roseland Green community, this fabulous 3-bedroom, 2.5-bathroom executive townhome offers a perfect blend of comfort and gracious living. The coveted Tiffany model features a double driveway and double-car garage with convenient interior access. Meticulously maintained and freshly painted throughout in May 2026, this immaculate residence offers approximately1,990 square feet of above grade living space. The gracious Living Room showcases refined coved mouldings and opens to a private patio overlooking tranquil surroundings. The bright eat-in Kitchen is enhanced by a pantry and charming bay window with picturesque views of the mature treed landscape. A standout feature of the home is the sun-filled second level Family Room, highlighted by a soaring vaulted ceiling, cozy gas fireplace, wet bar, and elegant California shutters-creating the perfect retreat for relaxation or entertaining guests. The spacious Primary Suite offers a walk-in closet and a luxurious five-piece ensuite bath, providing a private sanctuary at the end of the day. The lower level includes rough-in plumbing and an expansive unspoiled basement, presenting outstanding potential for future customization. Residents enjoy a beautifully managed, lushly landscaped enclave complete with underground irrigation throughout the common areas. Recent condominium corporation improvements include new windows (2020), new roof, exposed aggregate walkway, and front porch (2025). Ideally located just moments from Lake Ontario, scenic waterfront trails, shopping, schools, parks, transit, and an array of amenities, this distinguished residence presents a rare opportunity to enjoy luxury living in one of Burlington's most desirable communities. A wonderful opportunity in an unparalleled location! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Garage door opener"
6 => "Garage door opener remote(s)"
]
+"AssociationFee": "644.62"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:32:15.045242+00:00"
+"Directions": "Cross Streets: Pine Cove Rd. ** Directions: North off New Street opposite Pine Cove Road."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Wooded area"
2 => "Level"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T16:38:51Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T16:38:51Z"
+"Stories": "2.0"
+"StreetName": "New"
+"StreetNumber": "3333"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5736"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/193333-New-St"
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1676621280"
"RoomType" => "Living room"
"ListingId" => "W13527128"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.66
"ListingKey" => "29993821"
"RoomLength" => 4.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
1 => array:11 [
"RoomKey" => "1676621281"
"RoomType" => "Bathroom"
"ListingId" => "W13527128"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29993821"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
2 => array:11 [
"RoomKey" => "1676621282"
"RoomType" => "Other"
"ListingId" => "W13527128"
"RoomLevel" => "Basement"
"RoomWidth" => 7.3
"ListingKey" => "29993821"
"RoomLength" => 7.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
3 => array:11 [
"RoomKey" => "1676621283"
"RoomType" => "Dining room"
"ListingId" => "W13527128"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.34
"ListingKey" => "29993821"
"RoomLength" => 7.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
4 => array:11 [
"RoomKey" => "1676621284"
"RoomType" => "Kitchen"
"ListingId" => "W13527128"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.48
"ListingKey" => "29993821"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
5 => array:11 [
"RoomKey" => "1676621285"
"RoomType" => "Eating area"
"ListingId" => "W13527128"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.88
"ListingKey" => "29993821"
"RoomLength" => 3.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
6 => array:11 [
"RoomKey" => "1676621286"
"RoomType" => "Bathroom"
"ListingId" => "W13527128"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29993821"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
7 => array:11 [
"RoomKey" => "1676621287"
"RoomType" => "Family room"
"ListingId" => "W13527128"
"RoomLevel" => "Second level"
"RoomWidth" => 5.05
"ListingKey" => "29993821"
"RoomLength" => 6.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.3Z"
]
8 => array:11 [
"RoomKey" => "1676621288"
"RoomType" => "Primary Bedroom"
"ListingId" => "W13527128"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29993821"
"RoomLength" => 6.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.31Z"
]
9 => array:11 [
"RoomKey" => "1676621289"
"RoomType" => "Bathroom"
"ListingId" => "W13527128"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29993821"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.31Z"
]
10 => array:11 [
"RoomKey" => "1676621290"
"RoomType" => "Bedroom"
"ListingId" => "W13527128"
"RoomLevel" => "Second level"
"RoomWidth" => 3.02
"ListingKey" => "29993821"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.31Z"
]
11 => array:11 [
"RoomKey" => "1676621291"
"RoomType" => "Bedroom"
"ListingId" => "W13527128"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29993821"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T16:38:51.31Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Roseland"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29993821/19-3333-new-street-burlington-roseland-roseland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "RM3-30"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-06T16:38:51.26Z"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29993821_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/488c786aed9c16b574541b6e60fc84d9.webp"
"MediaSize" => 337970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-488c786aed9c16b574541b6e60fc84d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29993821_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/1f22e7f0e799a25ee2cceee78f2dd098.webp"
"MediaSize" => 315409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-1f22e7f0e799a25ee2cceee78f2dd098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29993821_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/401d3b844bacd7b3d4b4931101f3d597.webp"
"MediaSize" => 483205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-401d3b844bacd7b3d4b4931101f3d597.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29993821_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/c2d214ce74d3220c58cda27f8cb73762.webp"
"MediaSize" => 553289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-c2d214ce74d3220c58cda27f8cb73762.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29993821_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/a5ccde08378904b3ba86c054de9f1d2d.webp"
"MediaSize" => 88015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-a5ccde08378904b3ba86c054de9f1d2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29993821_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/0ce0fcec52c66411ff304b1b5c9943f3.webp"
"MediaSize" => 143466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-0ce0fcec52c66411ff304b1b5c9943f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29993821_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/08e0d3d8f44bf1fca79cc5fc11413790.webp"
"MediaSize" => 171551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-08e0d3d8f44bf1fca79cc5fc11413790.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29993821_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/4f3012abca02c50b05b492b556214efb.webp"
"MediaSize" => 159911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-4f3012abca02c50b05b492b556214efb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29993821_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/46962d69f3db2b0c73e8d2ab392f2801.webp"
"MediaSize" => 206063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-46962d69f3db2b0c73e8d2ab392f2801.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29993821_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/a896bf8d0c0d571bc43dc80c32640d32.webp"
"MediaSize" => 134359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-a896bf8d0c0d571bc43dc80c32640d32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29993821_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/62f94605fae3dabe2189d0b612d39163.webp"
"MediaSize" => 111944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-62f94605fae3dabe2189d0b612d39163.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29993821_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/8d2dd4d5bce170bd97f984e745f1bab8.webp"
"MediaSize" => 186562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-8d2dd4d5bce170bd97f984e745f1bab8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29993821_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/9d9d50e7e1832b8d832175832191ea61.webp"
"MediaSize" => 121640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-9d9d50e7e1832b8d832175832191ea61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29993821_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/bafaf514c046f68cc67ec497c0714c93.webp"
"MediaSize" => 176917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-bafaf514c046f68cc67ec497c0714c93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29993821_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/bdf63c020adc7d2d1c3ef98921abda61.webp"
"MediaSize" => 157563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-bdf63c020adc7d2d1c3ef98921abda61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29993821_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/7da96c65d8459d2ace3287c818a2ae7e.webp"
"MediaSize" => 166044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-7da96c65d8459d2ace3287c818a2ae7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29993821_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/ecd42b3909cc622c8ee435fdef8a59bb.webp"
"MediaSize" => 211535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-ecd42b3909cc622c8ee435fdef8a59bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29993821_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/63ab67175c9508e7b5c4d89536d361dd.webp"
"MediaSize" => 168983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-63ab67175c9508e7b5c4d89536d361dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29993821_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/e304a7eaf18550a76016ac3b6006a758.webp"
"MediaSize" => 234425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-e304a7eaf18550a76016ac3b6006a758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29993821_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/476c4b36329289bc785c53bc9e1a1a30.webp"
"MediaSize" => 145003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-476c4b36329289bc785c53bc9e1a1a30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29993821_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/b14b12251619273140afd62fe3b54883.webp"
"MediaSize" => 190669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-b14b12251619273140afd62fe3b54883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29993821_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/26d6def21f2a3f94cc68d74e82fb1bc5.webp"
"MediaSize" => 112168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-26d6def21f2a3f94cc68d74e82fb1bc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29993821_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/2e44cb913c642e98d52d603b016dc75d.webp"
"MediaSize" => 80346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-2e44cb913c642e98d52d603b016dc75d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29993821_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/1a1c8bf9d12d90be9427a949a5ef0a74.webp"
"MediaSize" => 140253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-1a1c8bf9d12d90be9427a949a5ef0a74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29993821_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/7e2ceffe2789e76b854b6a462da68e90.webp"
"MediaSize" => 104888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-7e2ceffe2789e76b854b6a462da68e90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29993821_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/da1e4a20a22cfd17ebdadcce695a9fcb.webp"
"MediaSize" => 118193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-da1e4a20a22cfd17ebdadcce695a9fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29993821_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/5654aa02e4b5ba493bc663f16e2e5100.webp"
"MediaSize" => 118256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-5654aa02e4b5ba493bc663f16e2e5100.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29993821_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/afef35e65a462ff4580793846f87a11e.webp"
"MediaSize" => 109046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-afef35e65a462ff4580793846f87a11e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29993821_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/07c25018e059ad72f754ba534b7179e9.webp"
"MediaSize" => 109384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-07c25018e059ad72f754ba534b7179e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29993821_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/53c4d80f0cd05e3fc337c5a6e4683f4d.webp"
"MediaSize" => 130426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-53c4d80f0cd05e3fc337c5a6e4683f4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29993821_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/e722dfb9d38c1703b640800a336f25f0.webp"
"MediaSize" => 212493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-e722dfb9d38c1703b640800a336f25f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29993821_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/4a73dce1d6d80fabe3c92cd74e738be1.webp"
"MediaSize" => 241597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-4a73dce1d6d80fabe3c92cd74e738be1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29993821_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/7b0978dcff35af096202371c82008013.webp"
"MediaSize" => 460502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-7b0978dcff35af096202371c82008013.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29993821_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/da7dbd7753b1b5e8e9f164268027a5c7.webp"
"MediaSize" => 338148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-da7dbd7753b1b5e8e9f164268027a5c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29993821_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/b589385b2b0efa90860984b24cf505f6.webp"
"MediaSize" => 440040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-b589385b2b0efa90860984b24cf505f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29993821_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/c1cd559af79c6e35a70cd41a9eecea2f.webp"
"MediaSize" => 390615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-c1cd559af79c6e35a70cd41a9eecea2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29993821_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/3afde2ea3ff8206c1904466b2c7a03f3.webp"
"MediaSize" => 446136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-3afde2ea3ff8206c1904466b2c7a03f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29993821_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/8393da15be9a6325f2c3b94fac0d1422.webp"
"MediaSize" => 507409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-8393da15be9a6325f2c3b94fac0d1422.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29993821_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/7da31de35bb4abc3836efe101424eaf1.webp"
"MediaSize" => 478341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-7da31de35bb4abc3836efe101424eaf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29993821_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/5bb16d8f1fb102b4f0323709c43f2643.webp"
"MediaSize" => 486984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-5bb16d8f1fb102b4f0323709c43f2643.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29993821_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/e4de1359ab6e2bdcfbbb9cc379a2cba6.webp"
"MediaSize" => 494913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-e4de1359ab6e2bdcfbbb9cc379a2cba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29993821_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/aa6aab9ef0756da395f702603ad7e91a.webp"
"MediaSize" => 313831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-aa6aab9ef0756da395f702603ad7e91a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29993821_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/a9b7958d1707adec2202848fa81cb497.webp"
"MediaSize" => 416762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-a9b7958d1707adec2202848fa81cb497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29993821_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29993821/42557944793c94f5fffbf85eb21b67ff.webp"
"MediaSize" => 308693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29993821/thumbnail-42557944793c94f5fffbf85eb21b67ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "W13527128"
"ResourceRecordKey" => "29993821"
"ModificationTimestamp" => "2026-07-06T16:38:51.27Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993821')"
+"ID": "1596597"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283586" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24915
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2048116" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24884
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29993821'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25279
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29993821'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25295
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29993821' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.775115 43.348656)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25368
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "1602719"
+post_author: 1
+"ListingKey": "30002500"
+"ListingId": "40845879"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T02:50:01Z"
+"RFModificationTimestamp": "2026-07-08T02:52:50Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1265.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7N2Z9"
+"UnparsedAddress": "459 WOODVIEW Road Unit# 8, Burlington, Ontario L7N2Z9"
+"Coordinates": array:2 [
0 => -79.7736734
1 => 43.3506635
]
+"Latitude": 43.3506635
+"Longitude": -79.7736734
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nature, privacy, and effortless living converge in this exceptional end-unit townhouse, gracefully nestled against the picturesque Tuck Creek ravine. Arguably the premier location within the complex, this rare offering enjoys outstanding privacy, expansive green space, and an ever-changing natural backdrop that creates a true sense of retreat. The coveted end-unit setting also accommodates an impressive 157 sq. ft. private rear deck—perfect for entertaining, peaceful morning coffee surrounded by birdsong, or evenings overlooking the tranquil ravine. In winter, step outside and enjoy the timeless tradition of pond hockey on the frozen creek. Freshly painted in timeless neutral tones, this impeccably maintained 3-bedroom, 2-bath home blends warmth, character, and functionality. The inviting living room is anchored by a striking fireplace feature wall, while custom-crafted stair railings inspired by the surrounding woodland add a distinctive architectural touch. The spacious kitchen offers abundant cabinetry, a double oven, under-counter water filtration, and generous prep space. A custom built-in sideboard with an integrated wine rack adds both elegance and function to the dining area. Inside access from the attached garage leads to a finished lower-level rec room—ideal as a media lounge, home gym, playroom, hobby space, or teenage retreat. Excellent storage includes generous bedroom closets, a utility room, and a cold cellar. Visitor parking is conveniently located beside the home, with easy access to the beautifully maintained inground pool with seasonal lifeguard supervision. Ideally situated along the Centennial Bikeway Trail and just minutes to top-rated schools, shopping, restaurants, parks, public transit, and major highways, this remarkable home offers the perfect balance of nature, convenience, and refined living. Discover one of South Burlington's best-kept secrets. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "606.43"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T01:11:08.000638+00:00"
+"Directions": "New St & Woodview Rd"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1817164"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-08T02:41:02Z"
+"PhotosCount": 36
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T02:48:03Z"
+"Stories": "2.0"
+"StreetName": "WOODVIEW"
+"StreetNumber": "459"
+"StreetSuffix": "Road"
+"SubdivisionName": "320 - Dynes"
+"TaxAnnualAmount": "3100"
+"View": "View of water"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1677841182"
"RoomType" => "Cold room"
"ListingId" => "40845879"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "4'3'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
1 => array:11 [
"RoomKey" => "1677841183"
"RoomType" => "Utility room"
"ListingId" => "40845879"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
2 => array:11 [
"RoomKey" => "1677841184"
"RoomType" => "Recreation room"
"ListingId" => "40845879"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 24'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
3 => array:11 [
"RoomKey" => "1677841185"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845879"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
4 => array:11 [
"RoomKey" => "1677841186"
"RoomType" => "Bedroom"
"ListingId" => "40845879"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
5 => array:11 [
"RoomKey" => "1677841187"
"RoomType" => "Bedroom"
"ListingId" => "40845879"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
6 => array:11 [
"RoomKey" => "1677841188"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845879"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
7 => array:11 [
"RoomKey" => "1677841189"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845879"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "4'5'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
8 => array:11 [
"RoomKey" => "1677841190"
"RoomType" => "Kitchen"
"ListingId" => "40845879"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
9 => array:11 [
"RoomKey" => "1677841191"
"RoomType" => "Dining room"
"ListingId" => "40845879"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30002500"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T02:48:03.51Z"
]
10 => array:11 [
"RoomKey" => "1677841192"
…10
]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30002500/459-woodview-road-unit-8-burlington"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RL5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1265
+"OriginalEntryTimestamp": "2026-07-07T22:29:18.76Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1192886"
+"ListOfficeNationalAssociationId": "1306309"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002500')"
+"ID": "1602719"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1601406"
+post_author: 1
+"ListingKey": "30001096"
+"ListingId": "W13533838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T23:15:02Z"
+"RFModificationTimestamp": "2026-07-07T23:16:45Z"
+"ListPrice": 2399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Shoreacres)"
+"PostalCode": "L7L1A7"
+"UnparsedAddress": "4299 LAKESHORE ROAD, Burlington (Shoreacres), Ontario L7L1A7"
+"Coordinates": array:2 [
0 => -79.7528977
1 => 43.3550081
]
+"Latitude": 43.3550081
+"Longitude": -79.7528977
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exceptional two-storey residence on prestigious Lakeshore Road with Lake Access, where timeless elegance meets modern luxury. This stunning family home offers 4 bedrooms, 2 full bathrooms, 1powder rooms, and a thoughtfully designed open-concept layout that is flooded with natural light throughout. Step inside to discover a custom-designed gourmet kitchen featuring built-in appliances, premium finishes, a beautiful peninsula ideal for entertaining, and stunning designer light fixtures. A striking double-sided fireplace serves as the focal point of the main floor, creating warmth and ambiance while seamlessly connecting the kitchen and living areas. The spacious principal rooms offer the perfect blend of comfort and sophistication for everyday living and entertaining. The upper level welcomes you with an impressive designer light fixtures, a convenient linen closet, and four generously sized bedrooms. The luxurious primary suite is a private retreat, complete with a beautifully appointed ensuite bathroom and an expansive dressing room, thoughtfully converted from a separate bedroom to create the ultimate walk-in wardrobe experience. Three additional bedrooms and a second full bathroom complete the upper level. The fully renovated basement offers exceptional versatility with a spacious open-concept kitchen/living, a bedroom, a full bath and a den that easily serves as a home office or exercise room, a cold room, a large storage room, and a dedicated laundry room with ample storage space. Step outside to your beautifully landscaped backyard oasis, perfect for entertaining, family gatherings, or simply relaxing in complete privacy. Located in one of Burlington's most desirable neighborhoods, just moments from the waterfront, parks, top-rated schools, shopping, dining, and all amenities, this remarkable move-in-ready home offers the perfect combination of luxury, functionality, and location. A rare opportunity to own a truly exceptional property. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T22:08:22.185813+00:00"
+"Directions": "Cross Streets: Lakeshore/Walkers Line. ** Directions: Walkers Line to Lakeshore Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062694"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "95 x 105.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T23:06:38Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T23:06:38Z"
+"Stories": "2.0"
+"StreetName": "Lakeshore"
+"StreetNumber": "4299"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "9647.95"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=70371"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Shoreacres"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30001096/4299-lakeshore-road-burlington-shoreacres-shoreacres"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1.2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 95.0
+"OriginalEntryTimestamp": "2026-07-07T19:08:25.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1337690"
+"ListOfficeNationalAssociationId": "1300540"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001096')"
+"ID": "1601406"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+post_id: "1600817"
+post_author: 1
+"ListingKey": "30000149"
+"ListingId": "40844013"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:45:55Z"
+"RFModificationTimestamp": "2026-07-07T18:58:18Z"
+"ListPrice": 1298000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2197.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7L5G9"
+"UnparsedAddress": "4162 SUTHERLAND Crescent, Burlington, Ontario L7L5G9"
+"Coordinates": array:2 [
0 => -79.7707771
1 => 43.3613864
]
+"Latitude": 43.3613864
+"Longitude": -79.7707771
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully renovated raised bungalow in Burlington's highly desirable Longmoor neighbourhood. 3+1 bedrooms, 2 full bathrooms and a rare double-car garage, this home has been extensively updated and is truly move-in ready. From the stunning new kitchen to the major mechanical and cosmetic upgrades throughout, every detail has been thoughtfully completed so you can simply unpack and enjoy. The bright, functional layout offers generous living space on both levels, including a finished lower level with a spacious family room and 4th bedroom—perfect for guests, teens or a home office. Step outside to an incredible private backyard surrounded by mature trees, where an expansive deck creates the perfect outdoor entertaining space. Whether you're hosting family and friends or enjoying a quiet morning coffee, the setting feels like your own private Muskoka retreat. Located in one of Burlington's most sought-after family neighbourhoods, this home is within walking distance of highly rated Nelson High School, Pauline Johnson Public School and several more top schools. Parks, playgrounds, sports fields and scenic walking trails are all nearby, while shopping, restaurants, Appleby GO Station and the QEW are just minutes away. Homes offering this level of renovation, exceptional outdoor living and an unbeatable location are a rare find. Simply move in and enjoy everything this outstanding home has to offer. (id:62650)"
+"Appliances": array:2 [
0 => "Central Vacuum"
1 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T18:58:10.150353+00:00"
+"Directions": "BELVENIA"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T17:29:54Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:29:54Z"
+"Stories": "1.0"
+"StreetName": "SUTHERLAND"
+"StreetNumber": "4162"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "321 - Longmoor"
+"TaxAnnualAmount": "5072"
+"VirtualTourURLUnbranded": "https://tours.therealtorstoolbox.com/4162-sutherland-crescent-burlington/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30000149/4162-sutherland-crescent-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3.2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1421
+"BelowGradeFinishedArea": 776
+"OriginalEntryTimestamp": "2026-07-07T17:29:54.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000149')"
+"ID": "1600817"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25365
+post_id: "1599887"
+post_author: 1
+"ListingKey": "30000120"
+"ListingId": "W13533296"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T18:00:05Z"
+"RFModificationTimestamp": "2026-07-07T18:13:15Z"
+"ListPrice": 1298000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Shoreacres)"
+"PostalCode": "L7L5G9"
+"UnparsedAddress": "4162 SUTHERLAND CRESCENT, Burlington (Shoreacres), Ontario L7L5G9"
+"Coordinates": array:2 [
0 => -79.770153
1 => 43.361424
]
+"Latitude": 43.361424
+"Longitude": -79.770153
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully renovated raised bungalow in Burlington's highly desirable Longmoor neighbourhood. 3+1 bedrooms, 2 full bathrooms and a rare double-car garage, this home has been extensively updated and is truly move-in ready. From the stunning new kitchen to the major mechanical and cosmetic upgrades throughout, every detail has been thoughtfully completed so you can simply unpack and enjoy. The bright, functional layout offers generous living space on both levels, including a finished lower level with a spacious family room and 4th bedroom-perfect for guests, teens or a home office. Step outside to an incredible private backyard surrounded by mature trees, where an expansive deck creates the perfect outdoor entertaining space. Whether you're hosting family and friends or enjoying a quiet morning coffee, the setting feels like your own private Muskoka retreat. Located in one of Burlington's most sought-after family neighbourhoods, this home is within walking distance of highly rated Nelson High School, Pauline Johnson Public School and several more top schools. Parks, playgrounds, sports fields and scenic walking trails are all nearby, while shopping, restaurants, Appleby GO Station and the QEW are just minutes away. Homes offering this level of renovation, exceptional outdoor living and an unbeatable location are a rare find. Simply move in and enjoy everything this outstanding home has to offer. (id:62650)"
+"Appliances": array:10 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
8 => "Oven - Built-In"
9 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T18:13:06.005445+00:00"
+"Directions": "BELVENIA"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1899457"
+"ListOfficeKey": "292096"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "59.8 x 102.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T17:25:11Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:54:55Z"
+"Stories": "1.0"
+"StreetName": "Sutherland"
+"StreetNumber": "4162"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5072"
+"VirtualTourURLUnbranded": "https://tours.therealtorstoolbox.com/4162-sutherland-crescent-burlington/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2025
+"CityRegion": "Shoreacres"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/30000120/4162-sutherland-crescent-burlington-shoreacres-shoreacres"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1997977"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1834162"
+"CoListOfficeKey": "289818"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "293196"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R3.2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 59.9
+"OriginalEntryTimestamp": "2026-07-07T17:25:10.81Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1216506"
+"ListOfficeNationalAssociationId": "1408169"
+"CoListAgentNationalAssociationId": "1280693"
+"CoListAgentNationalAssociationId2": "1196633"
+"CoListOfficeNationalAssociationId": "1381541"
+"CoListOfficeNationalAssociationId2": "1423680"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000120')"
+"ID": "1599887"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1599854"
+post_author: 1
+"ListingKey": "29999456"
+"ListingId": "40845190"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T22:50:01Z"
+"RFModificationTimestamp": "2026-07-07T22:50:41Z"
+"ListPrice": 2399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3536.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7L1A7"
+"UnparsedAddress": "4299 LAKESHORE Road, Burlington, Ontario L7L1A7"
+"Coordinates": array:2 [
0 => -79.7528533
1 => 43.3548368
]
+"Latitude": 43.3548368
+"Longitude": -79.7528533
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional two-storey residence on prestigious Lakeshore Road with Water Access, where timeless elegance meets modern luxury. This stunning family home offers 4 bedrooms, 3 full bathrooms, 1 powder room, and a thoughtfully designed open-concept layout that is flooded with natural light throughout. Step inside to discover a custom-designed gourmet kitchen featuring built-in appliances, premium finishes, a beautiful peninsula ideal for entertaining and stunning designer light fixtures. A striking double-sided fireplace serves as the focal point of the main floor, creating warmth and ambiance while seamlessly connecting the kitchen and living areas. The spacious principal rooms offer the perfect blend of comfort and sophistication for everyday living & entertaining. The upper level welcomes you with impressive designer light fixtures, a linen closet, and four generously sized bedrooms. The luxurious primary suite is a private retreat, complete with a beautifully appointed ensuite bathroom and an expansive dressing room, thoughtfully converted from a separate bedroom to create the ultimate walk-in wardrobe experience. Three additional bedrooms and a second full bathroom complete the upper level. The fully renovated basement with separate entrance offers exceptional versatility with a spacious open-concept kitchen/living area, bedroom, full bath and a den (can easily serve as a home office or additional bedroom), a cold room, a large storage room, and a dedicated laundry room with ample storage space. Step outside to your beautifully landscaped backyard oasis, perfect for entertaining, family gatherings, or enjoy complete privacy. Located in one of Burlington's most desirable neighborhoods, just moments from the waterfront, parks, top-rated schools, shopping, dining, and all amenities, this remarkable move-in-ready home offers the perfect combination of luxury, functionality, and location. A rare opportunity to own a truly exceptional property. (id:62650)"
+"Appliances": array:1 [
0 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:53:48.834528+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967279"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T22:48:29Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T22:48:29Z"
+"Stories": "2.0"
+"StreetName": "LAKESHORE"
+"StreetNumber": "4299"
+"StreetSuffix": "Road"
+"SubdivisionName": "331 - Shoreacres"
+"TaxAnnualAmount": "9647.95"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=70371"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29999456/4299-lakeshore-road-burlington"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1.2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 95.0
+"AboveGradeFinishedArea": 2668
+"BelowGradeFinishedArea": 868
+"OriginalEntryTimestamp": "2026-07-07T16:18:16.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1255110"
+"ListOfficeNationalAssociationId": "1325050"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999456')"
+"ID": "1599854"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1595647"
+post_author: 1
+"ListingKey": "29993324"
+"ListingId": "40845529"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:45:47Z"
+"RFModificationTimestamp": "2026-07-07T17:57:35Z"
+"ListPrice": 1799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1867.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7N1V8"
+"UnparsedAddress": "195 WILTON Street, Burlington, Ontario L7N1V8"
+"Coordinates": array:2 [
0 => -79.7686191
1 => 43.3404196
]
+"Latitude": 43.3404196
+"Longitude": -79.7686191
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 195 Wilton Street, set on an exceptional 70’ x 163’ lot in the heart of Burlington’s highly coveted Roseland community. This well maintained side split offers approximately 2,000 square feet of functional living space with three bedrooms and three bathrooms, blending comfort, privacy, and lifestyle. The main level features a bright, open layout with an updated kitchen complete with granite countertops, stainless steel appliances, and walkout access to the rear deck, ideal for entertaining and everyday living. A separate family room with custom built ins and a gas fireplace provides a warm secondary living space with views of the backyard. The upper level includes three generously sized bedrooms, highlighted by a spacious primary suite with a private three piece ensuite, along with an additional updated main bath. Step outside to a true backyard retreat. The deep, private yard is professionally landscaped and features an inground saltwater pool, artificial turf putting green, and ample space for outdoor dining, lounging, and summer entertaining. Ideally located just steps from the lake, the Roseland Tennis Club, and close to top rated schools including Tuck and Nelson. Minutes to downtown Burlington, amenities, and major highways. A rare opportunity to secure a premium lot and lifestyle driven home in one of Burlington’s most prestigious neighbourhoods. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T16:49:04.497638+00:00"
+"Directions": "Lakeshore Rd / Wilton"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235873"
+"ListOfficeKey": "299790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T17:35:16Z"
+"PhotosCount": 29
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:35:16Z"
+"Stories": "2.0"
+"StreetName": "WILTON"
+"StreetNumber": "195"
+"StreetSuffix": "Street"
+"SubdivisionName": "330 - Roseland"
+"TaxAnnualAmount": "7967"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29993324/195-wilton-street-burlington"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2236169"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299790"
+"GeocodeManualYN": true
+"ZoningDescription": "R2.1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1867
+"OriginalEntryTimestamp": "2026-07-06T15:59:23.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1473810"
+"ListOfficeNationalAssociationId": "1476846"
+"CoListAgentNationalAssociationId": "1474092"
+"CoListOfficeNationalAssociationId": "1476846"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993324')"
+"ID": "1595647"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1595648"
+post_author: 1
+"ListingKey": "29993326"
+"ListingId": "40845454"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T16:05:18Z"
+"RFModificationTimestamp": "2026-07-06T16:48:45Z"
+"ListPrice": 945000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1990.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7N1N1"
+"UnparsedAddress": "3333 NEW Street Unit# 19, Burlington, Ontario L7N1N1"
+"Coordinates": array:2 [
0 => -79.7755881
1 => 43.3490195
]
+"Latitude": 43.3490195
+"Longitude": -79.7755881
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled within the highly sought-after Roseland Green community, this fabulous 3-bedroom, 2.5-bathroom executive townhome offers a perfect blend of comfort and gracious living. The coveted Tiffany model features a double driveway and double-car garage with convenient interior access. Meticulously maintained and freshly painted throughout in May 2026, this immaculate residence offers approximately 1,990 square feet of above grade living space. The gracious Living Room showcases refined coved mouldings and opens to a private patio overlooking tranquil surroundings. The bright eat-in Kitchen is enhanced by a pantry and charming bay window with picturesque views of the mature treed landscape. A standout feature of the home is the sun-filled secondlevel Family Room, highlighted by a soaring vaulted ceiling, cozy gas fireplace, wet bar, and elegant California shutters— creating the perfect retreat for relaxation or entertaining guests. The spacious Primary Suite offers a walk-in closet and a luxurious five-piece ensuite bath, providing a private sanctuary at the end of the day. The lower level includes rough-in plumbing and an expansive unspoiled basement, presenting outstanding potential for future customization. Residents enjoy a beautifully managed, lushly landscaped enclave complete with underground irrigation throughout the common areas. Recent condominium corporation improvements include new windows (2020), new roof, exposed aggregate walkway, and front porch (2025). Ideally located just moments from Lake Ontario, scenic waterfront trails, shopping, schools, parks, transit, and an array of amenities, this distinguished residence presents a rare opportunity to enjoy luxury living in one of Burlington's most desirable communities. A wonderful opportunity in an unparalleled location! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Dryer"
3 => "Window Coverings"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFee": "644.62"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T16:48:40.651049+00:00"
+"Directions": "North off New Street opposite Pine Cove Road"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Hot water radiator heat"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523761"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T15:59:24Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T15:59:24Z"
+"Stories": "2.0"
+"StreetName": "NEW"
+"StreetNumber": "3333"
+"StreetSuffix": "Street"
+"SubdivisionName": "320 - Dynes"
+"TaxAnnualAmount": "5736"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/193333-New-St"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29993326/3333-new-street-unit-19-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1523762"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55163"
+"GeocodeManualYN": true
+"ZoningDescription": "RM 3-30"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1990
+"OriginalEntryTimestamp": "2026-07-06T15:59:24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1063598"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1063595"
+"CoListOfficeNationalAssociationId": "1003655"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993326')"
+"ID": "1595648"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1593004"
+post_author: 1
+"ListingKey": "29989435"
+"ListingId": "W13522652"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:45:47Z"
+"RFModificationTimestamp": "2026-07-07T17:57:17Z"
+"ListPrice": 1349999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Roseland)"
+"PostalCode": "L7N1N1"
+"UnparsedAddress": "1 - 3333 NEW STREET, Burlington (Roseland), Ontario L7N1N1"
+"Coordinates": array:2 [
0 => -79.775115
1 => 43.348656
]
+"Latitude": 43.348656
+"Longitude": -79.775115
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 1 - 3333 New Street, nestled in the highly sought-after community of Roseland Green. Beautifully renovated from top to bottom, this exceptional residence blends timeless elegance with luxurious modern finishes in one of Burlington's most desirable neighbourhoods. Step inside to soaring vaulted ceilings that create a grand first impression in the foyer and formal living and dining rooms. A stylish tile inlay at the entrance adds both beauty and practicality, while a stunning custom staircase with white oak treads and black wrought iron spindles creates a striking focal point. New engineered hardwood flooring flows throughout, and the thoughtfully designed layout offers exceptional functionality for everyday living and entertaining. At the heart of the home is a stunning custom kitchen featuring extensive millwork, quartz countertops and stainless steel appliances. The same craftsmanship continues into the main-floor laundry room with custom cabinetry, quartz countertops, and a brand-new washer and dryer. The luxurious primary suite is a private retreat featuring a custom quartz-topped built in dresser, automatic electric blinds, and a spa-inspired ensuite with heated floors, custom vanity, quartz countertops, premium finishes, and a beautiful skylight that fills the space with natural light. Recent upgrades include a new electrical panel, upgraded wiring, designer light fixtures, luxury plumbing fixtures, windows (2020), and a new roof and aggregate walkways (2025), providing lasting value and peace of mind. Located minutes from downtown Burlington, the waterfront, shopping, restaurants, Joseph Brant Hospital, and major highways, this home offers exceptional convenience within the peaceful setting of Roseland Green, surrounded by mature trees and lush landscaping. A rare opportunity to own a truly turnkey luxury home in one of Burlington's most coveted communities that backs on to the walking path. Simply move in and enjoy. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "690.23"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T16:36:28.719289+00:00"
+"Directions": "Cross Streets: Woodview Road and New St. ** Directions: First Unit at the West corner of New Street and Woodview. Can park in the Double Driveway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2209488"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T15:36:45Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:07:59Z"
+"Stories": "2.0"
+"StreetName": "New"
+"StreetNumber": "3333"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5360.69"
+"View": "City view"
+"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": "Toronto"
+"CityRegion": "Roseland"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989435/1-3333-new-street-burlington-roseland-roseland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
2 => "Fireplace(s)"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "RM3-30"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-04T15:36:44.93Z"
+"ListAgentNationalAssociationId": "1455956"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989435')"
+"ID": "1593004"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1591205"
+post_author: 1
+"ListingKey": "29987145"
+"ListingId": "40845122"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:35:12Z"
+"RFModificationTimestamp": "2026-07-03T23:19:32Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 855.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7R1J6"
+"UnparsedAddress": "2422 NEW Street Unit# 9, Burlington, Ontario L7R1J6"
+"Coordinates": array:2 [
0 => -79.7855759
1 => 43.3366353
]
+"Latitude": 43.3366353
+"Longitude": -79.7855759
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2422 New St Unit 9, this 2 bedroom unit with lots of windows and natural light, located in a highly desirable central Burlington location, close to shops, dining, downtown, hospital, highways, rec/community centre, library, parks, trails, and other amenities. This 855 sq ft unit has a spacious living and dining room, the kitchen has updated cabinets with lots of cupboard and countertop space. The unit has an updated 4 piece bathroom and 2 good sized bedrooms. The windows were updated in 2018 and the unit has been freshly painted. The unit has a northern exposure and a view overlooking the courtyard and trees. The building itself is the furthest away from New St and backs onto the bike-walking trail which brings you downtown. The building is very quiet and well maintained. The building amenities also include a storage locker, visitor parking, and laundry. The unit comes with 1 parking space. The monthly maintenance fee includes property tax, heat, water, parking, locker, building insurance, and exterior maintenance. This is a CO-OP unit; The unit must be owner occupied and cannot be rented out. It is a beautiful unit, you will not be dissapointed. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Window Coverings"
]
+"AssociationFee": "600"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-07-03T23:19:30.031914+00:00"
+"Directions": "From Guelph Line, West on New Street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524969"
+"ListOfficeKey": "55053"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-03T20:29:08Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:29:08Z"
+"Stories": "1.0"
+"StreetName": "NEW"
+"StreetNumber": "2422"
+"StreetSuffix": "Street"
+"SubdivisionName": "312 - Central"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987145/2422-new-street-unit-9-burlington"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"GeocodeManualYN": true
+"ZoningDescription": "RH1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 855
+"OriginalEntryTimestamp": "2026-07-03T20:29:08.48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063196"
+"ListOfficeNationalAssociationId": "1003511"
+"Media": array:25 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987145')"
+"ID": "1591205"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 158
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]