array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29894531 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1526801"
+post_author: 1
+"ListingKey": "29894531"
+"ListingId": "40839266"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T20:40:16Z"
+"RFModificationTimestamp": "2026-06-14T20:42:25Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1058.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P3X4"
+"UnparsedAddress": "2367 MIDDLESMOOR Crescent, Burlington, Ontario L7P3X4"
+"Coordinates": array:2 [
0 => -79.8395529
1 => 43.3679475
]
+"Latitude": 43.3679475
+"Longitude": -79.8395529
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2367 Middlesmoor crescent, a beautifully renovated semi-detached property in the Brant Hills neighbourhood. The main level is open and spacious with a modern fireplace and kitchen island; perfect spot for entertaining your guests. Brand new kitchen cabinets with new S/S appliances, stone countertop and backsplash. New interior doors, smooth ceilings in main living area and basement, new potlights, new bathroom vanity, new porcelain tiles around the tub, new vinyl flooring throughout and new 200 amp electrical panel was installed 2023. The finished basement is a stand out feature with a good sized rec room, kitchen, two bedrooms with deep windows and a full 4 pc bathroom. 3/4 SONOpan soundproofing installed in the basement ceiling. The property is ideal for those Buyers looking to accommodate adult children or in-laws. Fully fenced yard, parking for three cars on the driveway. Close to schools, parks and the 407. It is move-in ready - just unpack and enjoy! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:32:23.403611+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl 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": "2163178"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"PhotosChangeTimestamp": "2026-06-12T14:20:18Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T20:30:59Z"
+"Stories": "1.0"
+"StreetName": "MIDDLESMOOR"
+"StreetNumber": "2367"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "341 - Brant Hills"
+"TaxAnnualAmount": "4138.97"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1659432800"
"RoomType" => "Laundry room"
"ListingId" => "40839266"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.45Z"
]
1 => array:11 [
"RoomKey" => "1659432801"
"RoomType" => "Bedroom"
"ListingId" => "40839266"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.45Z"
]
2 => array:11 [
"RoomKey" => "1659432802"
"RoomType" => "Bedroom"
"ListingId" => "40839266"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.45Z"
]
3 => array:11 [
"RoomKey" => "1659432803"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839266"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
4 => array:11 [
"RoomKey" => "1659432804"
"RoomType" => "Kitchen"
"ListingId" => "40839266"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
5 => array:11 [
"RoomKey" => "1659432805"
"RoomType" => "Recreation room"
"ListingId" => "40839266"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 26'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
6 => array:11 [
"RoomKey" => "1659432806"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839266"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
7 => array:11 [
"RoomKey" => "1659432807"
"RoomType" => "Bedroom"
"ListingId" => "40839266"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
8 => array:11 [
"RoomKey" => "1659432808"
"RoomType" => "Bedroom"
"ListingId" => "40839266"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
9 => array:11 [
"RoomKey" => "1659432809"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839266"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
10 => array:11 [
"RoomKey" => "1659432810"
"RoomType" => "Living room"
"ListingId" => "40839266"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 27'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
11 => array:11 [
"RoomKey" => "1659432811"
"RoomType" => "Kitchen"
"ListingId" => "40839266"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894531"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-14T20:30:59.46Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894531/2367-middlesmoor-crescent-burlington"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "LN3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1058
+"OriginalEntryTimestamp": "2026-06-12T14:20:17.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1414146"
+"ListOfficeNationalAssociationId": "1434122"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894531_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/28d9444a0a197e8506372769458c7da5.webp"
"MediaSize" => 136879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-28d9444a0a197e8506372769458c7da5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick-front exterior featuring a dark asphalt shingle roof"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29894531_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/a8c9e81068cb14049ba48e8be5f5595a.webp"
"MediaSize" => 151387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-a8c9e81068cb14049ba48e8be5f5595a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence with a dark shingle roof, featuring a front deck with wood railing, a paved driveway, and a manicured lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29894531_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/fa59e01737f623ae299a6babe6dc96f3.webp"
"MediaSize" => 63747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-fa59e01737f623ae299a6babe6dc96f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white cabinetry, stainless steel appliances, a center island with countertop seating, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29894531_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/6ff402a048c6b0c563d51734cd7e90b7.webp"
"MediaSize" => 61155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-6ff402a048c6b0c563d51734cd7e90b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring a modern kitchen with a large island, stainless steel appliances, white cabinetry, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29894531_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/33b81aa70907b9be23464149f81efa25.webp"
"MediaSize" => 70863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-33b81aa70907b9be23464149f81efa25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry with matte black hardware, stainless steel appliances, a white countertop, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29894531_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/b145edaba476a9bd57c50072e58728fb.webp"
"MediaSize" => 64370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-b145edaba476a9bd57c50072e58728fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, light countertops, stainless steel appliances, wood-finish flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29894531_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/b67f9a7fbf853afdae935c0981656f05.webp"
"MediaSize" => 92941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-b67f9a7fbf853afdae935c0981656f05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Accent wall featuring vertical slat paneling and a built-in linear fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29894531_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/2e6063cc76145ba2693df81e6500729e.webp"
"MediaSize" => 76174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-2e6063cc76145ba2693df81e6500729e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring recessed lighting, light-tone wood-finish flooring, and light gray wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29894531_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/fa9016bfb94234fa796b2d2f167cc3dd.webp"
"MediaSize" => 86556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-fa9016bfb94234fa796b2d2f167cc3dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a modern linear fireplace with a vertical slat wall surround, recessed ceiling lighting, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29894531_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/e326a807b9aa208a0125c8718c32c4cf.webp"
"MediaSize" => 84791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-e326a807b9aa208a0125c8718c32c4cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a floor-to-ceiling accent wall with vertical paneling and an integrated electric fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29894531_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/31ff98a3636706fab9f6c7fd55941898.webp"
"MediaSize" => 78890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-31ff98a3636706fab9f6c7fd55941898.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and a large window with ample natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29894531_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/3cc8481f77cbae05c9959a479691d999.webp"
"MediaSize" => 54608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-3cc8481f77cbae05c9959a479691d999.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed lighting illuminating light gray walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29894531_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/4432e5a6e5c52b0f825a55de91907065.webp"
"MediaSize" => 57147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-4432e5a6e5c52b0f825a55de91907065.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, light gray walls, a flush-mount ceiling light, and a window with a roller shade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29894531_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/a7809669166c4fdf975e125a8f8d108d.webp"
"MediaSize" => 40690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-a7809669166c4fdf975e125a8f8d108d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, light grey painted walls, white trim, and a window with a white frame"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29894531_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/cbe46a2c41bab5fa7c3ddab63e2423f6.webp"
"MediaSize" => 48600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-cbe46a2c41bab5fa7c3ddab63e2423f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light gray walls with white trim and wood-finish flooring define this bright room featuring a single window with white blinds and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29894531_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/3e169f9dfd37987d5bdcc49db8c9b528.webp"
"MediaSize" => 79283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-3e169f9dfd37987d5bdcc49db8c9b528.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring grey painted walls, wood-finish flooring, and a single window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29894531_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/37d10474f845d030db84a7f7c69b679e.webp"
"MediaSize" => 52812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-37d10474f845d030db84a7f7c69b679e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern bathroom featuring a white vanity with integrated sink, chrome faucet, and round wall mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29894531_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/d42af1fe8f9989c153e4d9c20ca27965.webp"
"MediaSize" => 48017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-d42af1fe8f9989c153e4d9c20ca27965.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a paneled front door with frosted glass insert, an adjacent sidelight, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29894531_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/5da940109af700bf76df9ea0320c7998.webp"
"MediaSize" => 53996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-5da940109af700bf76df9ea0320c7998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase featuring wood-finish treads, white risers, and black metal balusters with a coordinating handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29894531_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/0ef609c05ff652daff0fa4bb0a099218.webp"
"MediaSize" => 44974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-0ef609c05ff652daff0fa4bb0a099218.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior room featuring light-toned wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29894531_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/79636ae3f5b7c23d9f63d99e92e3a89d.webp"
"MediaSize" => 53986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-79636ae3f5b7c23d9f63d99e92e3a89d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious dining area featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29894531_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/0102eca4c403895a7c29688c805f0a06.webp"
"MediaSize" => 45244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-0102eca4c403895a7c29688c805f0a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior featuring wood-finish flooring, recessed lighting, crown molding, and light gray wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29894531_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/71ee2ae409ca9dd1aa5ebd067e5b53ea.webp"
"MediaSize" => 54889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-71ee2ae409ca9dd1aa5ebd067e5b53ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living and dining area featuring recessed lighting, crown molding, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29894531_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/3833d0483c8378f438b6e8885eb65760.webp"
"MediaSize" => 60426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-3833d0483c8378f438b6e8885eb65760.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring gray flat-panel cabinetry, light-toned countertops, a stainless steel undermount sink with a gooseneck faucet, and white patterned backsplash tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29894531_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/78a70149027add8cb12702455e184e1c.webp"
"MediaSize" => 60408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-78a70149027add8cb12702455e184e1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring gray flat-panel cabinetry, a stainless steel range hood, and a white tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29894531_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/87cd3f3ee16ccd87df8c170c42cff51e.webp"
"MediaSize" => 45783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-87cd3f3ee16ccd87df8c170c42cff51e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished room featuring wood-finish flooring, recessed lighting, white baseboards, a white window frame, and a window with a roller shade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29894531_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/f433fc8cb282e606b50a9d6750396fe5.webp"
"MediaSize" => 54838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-f433fc8cb282e606b50a9d6750396fe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room with recessed lighting and a window featuring a roller shade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29894531_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/78999cd75e78c6cca914e9fe5c011702.webp"
"MediaSize" => 45156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-78999cd75e78c6cca914e9fe5c011702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, recessed lighting, and a white-framed window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29894531_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/82b6e7e8e9ddd79ab0b4eb2fc3475a28.webp"
"MediaSize" => 52053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-82b6e7e8e9ddd79ab0b4eb2fc3475a28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light gray walls, a window with white trim, recessed ceiling lighting, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29894531_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/f50714a6990456a6f3f0a072af687eb7.webp"
"MediaSize" => 41835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-f50714a6990456a6f3f0a072af687eb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with silver hardware, an integrated countertop sink, and a large wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29894531_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/d5b3a6d3ea1d97bb1d59c0ae3acc2cc9.webp"
"MediaSize" => 72842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-d5b3a6d3ea1d97bb1d59c0ae3acc2cc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with an integrated sink, chrome faucet, and mirrored cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29894531_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/d537d05a7079d3687622d07538f7d359.webp"
"MediaSize" => 152303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-d537d05a7079d3687622d07538f7d359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29894531_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/04543e140a2609709eab8bbb1c16f22f.webp"
"MediaSize" => 180617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-04543e140a2609709eab8bbb1c16f22f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29894531_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894531/3dfb4e01ba9e12eff34cb920e10a1974.webp"
"MediaSize" => 176289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894531/thumbnail-3dfb4e01ba9e12eff34cb920e10a1974.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-filled room featuring wood-finish flooring, light gray walls, a white sliding glass patio door, and a wooden deck beyond"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839266"
"ResourceRecordKey" => "29894531"
"ModificationTimestamp" => "2026-06-12T14:20:17.78Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894531')"
+"ID": "1526801"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 294000" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24712
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2163178" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24706
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29894531'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25105
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29894531'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25123
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25121
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31448539"
+"ListingKey": "29894531"
+"ListingId": "40839266"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T20:01:00Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31448539')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29894531' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8395529 43.3679475)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170
+post_id: "1537553"
+post_author: 1
+"ListingKey": "29913681"
+"ListingId": "40840554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T01:00:08Z"
+"RFModificationTimestamp": "2026-06-17T01:31:14Z"
+"ListPrice": 1499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1745.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7M1L2"
+"UnparsedAddress": "3135 PALMER Drive, Burlington, Ontario L7M1L2"
+"Coordinates": array:2 [
0 => -79.8167466
1 => 43.3655102
]
+"Latitude": 43.3655102
+"Longitude": -79.8167466
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning, specious and renovated home! Fully renovated thru out. Basement is separate unit with tenant occupancy. Large backyard and large windows for natural light. Stainless steel appliances. Great Palmer location. Tenant to stay in the basement after closing. Must See! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T01:31:11.386823+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094324"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T00:52:01Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T00:52:01Z"
+"Stories": "2.0"
+"StreetName": "PALMER"
+"StreetNumber": "3135"
+"StreetSuffix": "Drive"
+"SubdivisionName": "353 - Palmer"
+"TaxAnnualAmount": "5025"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1660873706"
"RoomType" => "Recreation room"
"ListingId" => "40840554"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.77Z"
]
1 => array:11 [
"RoomKey" => "1660873707"
"RoomType" => "Bedroom"
"ListingId" => "40840554"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.78Z"
]
2 => array:11 [
"RoomKey" => "1660873708"
"RoomType" => "Bedroom"
"ListingId" => "40840554"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.79Z"
]
3 => array:11 [
"RoomKey" => "1660873709"
"RoomType" => "Bedroom"
"ListingId" => "40840554"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.79Z"
]
4 => array:11 [
"RoomKey" => "1660873710"
"RoomType" => "Family room"
"ListingId" => "40840554"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.79Z"
]
5 => array:11 [
"RoomKey" => "1660873711"
"RoomType" => "Kitchen"
"ListingId" => "40840554"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.81Z"
]
6 => array:11 [
"RoomKey" => "1660873712"
"RoomType" => "Living room"
"ListingId" => "40840554"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.82Z"
]
7 => array:11 [
"RoomKey" => "1660873713"
"RoomType" => "Dining room"
"ListingId" => "40840554"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.82Z"
]
8 => array:11 [
"RoomKey" => "1660873714"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840554"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.82Z"
]
9 => array:11 [
"RoomKey" => "1660873715"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840554"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29913681"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T00:50:54.82Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29913681/3135-palmer-drive-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3.2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1745
+"OriginalEntryTimestamp": "2026-06-17T00:50:54.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1377101"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29913681_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/bf6cb56290c485413eb7495e35ac07b8.webp"
"MediaSize" => 135972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-bf6cb56290c485413eb7495e35ac07b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front exterior featuring a stucco finish, stone veneer siding, white trim windows, and a paved driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.8Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29913681_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/b5cae7653731c3bf6491dc12fda94b78.webp"
"MediaSize" => 110987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-b5cae7653731c3bf6491dc12fda94b78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior featuring a light stucco finish, stone veneer accents, multiple large windows, an attached garage, and a paver walkway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:52:01.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29913681_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/8019281134ab23c27a7ac7555739ae1e.webp"
"MediaSize" => 119805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-8019281134ab23c27a7ac7555739ae1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with decorative oval glass insert, sidelight with leaded glass, and an accent wall with stacked stone tile"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:52:01.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29913681_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/c1b16380daceba5b4973c2cd8f93cf31.webp"
"MediaSize" => 128425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-c1b16380daceba5b4973c2cd8f93cf31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry with a white door featuring an oval decorative glass insert and a sidelight with stained glass"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.81Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29913681_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/2867b43a079bbb0f14569fb2cd46a090.webp"
"MediaSize" => 90156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-2867b43a079bbb0f14569fb2cd46a090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring dark wood-finish flooring, recessed lighting, and a large window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:52:01.34Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29913681_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/8f17de7a8594e33f59e9b2d41059d0c3.webp"
"MediaSize" => 93733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-8f17de7a8594e33f59e9b2d41059d0c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and a kitchen island with a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.81Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29913681_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/d1a06162b632b1137195d580d4961596.webp"
"MediaSize" => 95778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-d1a06162b632b1137195d580d4961596.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring rich wood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:52:01.25Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29913681_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/586a1f1d786e08baba1b446f9db7bab3.webp"
"MediaSize" => 82446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-586a1f1d786e08baba1b446f9db7bab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring dark wood-finish flooring, recessed lighting, and a wide window with blinds and dark drapery panels"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.8Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29913681_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/fdf2205ddd419ecd4f3e68e11d38e912.webp"
"MediaSize" => 91127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-fdf2205ddd419ecd4f3e68e11d38e912.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept living area with dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.8Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29913681_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/21364db6caf9e931d6fb2474d2febedc.webp"
"MediaSize" => 84957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-21364db6caf9e931d6fb2474d2febedc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring dark wood-finish flooring, white cabinetry, and a large island with a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.8Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29913681_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/7210e46bbf1e5075f0e7cf2cd5a1cb3b.webp"
"MediaSize" => 95275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-7210e46bbf1e5075f0e7cf2cd5a1cb3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a stainless steel gas range, coordinating range hood, and crisp white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.8Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29913681_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/a2e68a3283af0ef7b4c176fc30c29ead.webp"
"MediaSize" => 74100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-a2e68a3283af0ef7b4c176fc30c29ead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a large center island with a light-toned countertop, sleek white cabinetry, stainless steel appliances, and a textured tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.8Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29913681_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/5c8c83a8dbc717f882b05c66c6a70508.webp"
"MediaSize" => 72181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-5c8c83a8dbc717f882b05c66c6a70508.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, dark wood-finish flooring, stainless steel appliances, a stacked tile backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.81Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29913681_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/101b80e342c4736d235fac85b157c502.webp"
"MediaSize" => 90170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-101b80e342c4736d235fac85b157c502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with dark wood-finish flooring, a large window, light-toned walls, and ceiling-mounted lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.81Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29913681_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/73d556d8d15a9b6ec41f9673b3bea478.webp"
"MediaSize" => 81034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-73d556d8d15a9b6ec41f9673b3bea478.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring dark wood-finish flooring, light neutral-toned walls, and a white textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:52:01.26Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29913681_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/97c17308358118b11d5d1ddbb5387f82.webp"
"MediaSize" => 87951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-97c17308358118b11d5d1ddbb5387f82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, neutral wall tones, and a window with white drapery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:51:59.81Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29913681_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29913681/313936cbe1c4e48582a02fdb544aaa7c.webp"
"MediaSize" => 86615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29913681/thumbnail-313936cbe1c4e48582a02fdb544aaa7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring dark wood-finish flooring, light neutral-toned walls, a single window with white trim, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840554"
"ResourceRecordKey" => "29913681"
"ModificationTimestamp" => "2026-06-17T00:52:01.33Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29913681_4890_18"
…11
]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913681')"
+"ID": "1537553"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25172
+post_id: "1536950"
+post_author: 1
+"ListingKey": "29912240"
+"ListingId": "40840417"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:40:12Z"
+"RFModificationTimestamp": "2026-06-16T23:05:17Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1980.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P2H8"
+"UnparsedAddress": "2277 MOUNTAIN GROVE Avenue Unit# 39, Burlington, Ontario L7P2H8"
+"Coordinates": array:2 [
0 => -79.8264056
1 => 43.3668555
]
+"Latitude": 43.3668555
+"Longitude": -79.8264056
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2277 Mountain Grove Ave, a spacious condo townhouse nestled in a well-established, family-friendly community in Burlington! This versatile home offers 3+1 bedrooms, 2 bathrooms, and a layout that works beautifully for families, first-time buyers, or multi-generational living. The bright, open-concept main floor features updated flooring flowing seamlessly from the living room through to the dining area, all bathed in natural light from large windows overlooking the mature, tree-lined surroundings. The functional kitchen offers ample oak cabinetry, a mosaic tile backsplash, and stainless steel appliances. Upstairs you'll find three well-proportioned bedrooms, including a serene primary with a ceiling fan, plus an updated 4-piece bath. The finished lower level adds incredible flexibility featuring a 4th bedroom and walk out exit to the backyard. Enjoy the ease of condo living with water, visitor parking, snow removal, landscaping, and access to a shared inground pool all included. Ideally located close to schools, shopping, transit, and quick access to the 403/QEW/407. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"AssociationFee": "435.64"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"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-06-16T23:05:13.673114+00:00"
+"Directions": "Guelph Line and Mountain Grove Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Automatic Garage Door Opener"
1 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:31:51Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:31:51Z"
+"Stories": "2.0"
+"StreetName": "MOUNTAIN GROVE"
+"StreetNumber": "2277"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "341 - Brant Hills"
+"TaxAnnualAmount": "3011.93"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912240/2277-mountain-grove-avenue-unit-39-burlington"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RM2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1320
+"BelowGradeFinishedArea": 660
+"OriginalEntryTimestamp": "2026-06-16T20:31:51.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912240')"
+"ID": "1536950"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: "1535671"
+post_author: 1
+"ListingKey": "29911625"
+"ListingId": "40839607"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:40:09Z"
+"RFModificationTimestamp": "2026-06-16T19:44:31Z"
+"ListPrice": 979000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2102.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7M3L4"
+"UnparsedAddress": "2461 HEADON FOREST Drive, Burlington, Ontario L7M3L4"
+"Coordinates": array:2 [
0 => -79.8302771
1 => 43.3838104
]
+"Latitude": 43.3838104
+"Longitude": -79.8302771
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in one of Burlington's most sought-after family neighbourhoods, this spacious and beautifully maintained home offers the perfect blend of comfort, functionality, and versatility. Featuring 3+2 bedrooms and 3.5 bathrooms, there's plenty of room for growing families, multi-generational living, or those seeking additional space for guests or a home office. The thoughtfully designed main floor boasts generous principal rooms ideal for both everyday living and entertaining, while the bright kitchen overlooks the backyard and seamlessly connects to the home's inviting living spaces. Upstairs, you'll find three well-appointed bedrooms, including a spacious primary retreat complete with ensuite bath. The finished lower level expands the living space with two additional bedrooms, a full bathroom, a kitchenette, and a recreation area, offering endless possibilities for extended family, teenagers, or work-from-home flexibility. Step outside to enjoy the private backyard, perfect for summer barbecues, relaxing evenings, and family gatherings. Located in the highly desirable Headon Forest community, you'll appreciate the proximity to excellent schools, parks, shopping, transit, and major commuter routes, making everyday life both convenient and enjoyable. Headon Forest is known for its family-friendly atmosphere, mature streetscapes, and easy access to Burlington amenities and highways. This is an exceptional opportunity to own a spacious family home in one of Burlington's most established and desirable neighbourhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Freezer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T19:39:48.896204+00:00"
+"Directions": "Dundas, S on Northampton, W on Headon Forest"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1888576"
+"ListOfficeKey": "54929"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:10:49Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:32:04Z"
+"Stories": "2.0"
+"StreetName": "HEADON FOREST"
+"StreetNumber": "2461"
+"StreetSuffix": "Drive"
+"SubdivisionName": "350 - Headon Forest"
+"TaxAnnualAmount": "4792.12"
+"VirtualTourURLUnbranded": "https://youriguide.com/2461_headon_forest_dr_burlington_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911625/2461-headon-forest-drive-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "LN3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1441
+"BelowGradeFinishedArea": 661
+"OriginalEntryTimestamp": "2026-06-16T19:10:49.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1210308"
+"ListOfficeNationalAssociationId": "1003534"
+"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('29911625')"
+"ID": "1535671"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25173
+post_id: "1535952"
+post_author: 1
+"ListingKey": "29911053"
+"ListingId": "40840143"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:20:04Z"
+"RFModificationTimestamp": "2026-06-16T18:57:10Z"
+"ListPrice": 2047000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4073.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P3J6"
+"UnparsedAddress": "1320 MONMOUTH Drive, Burlington, Ontario L7P3J6"
+"Coordinates": array:2 [
0 => -79.8496912
1 => 43.3554988
]
+"Latitude": 43.3554988
+"Longitude": -79.8496912
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience luxury living in this stunning fully renovated 5 bedroom home with Walk Out basement, located in the prestigious Tyandaga Community. This exceptional home boasts almost 4100 sq.ft. of elegant living space with outstanding finishes and attention to detail. Nestled in a very convenient community near to Escarpment, Golf Clubs and natural trails, this home offers privacy and tranquility. The open concept design creates an inviting and spacious atmosphere, highlighted by rich hardwood floors throughout two levels and breathtaking oak stairs. The gourmet kitchen is a chef's dream, boasting with the heated flooring, featuring stylish quartz countertops, custom cabinetry with the premium newer stainless steel appliances. Enjoy the sunrise in the cozy breakfast area with incredible panoramic view - with the shimmering expanse of Lake Ontario visible on the horizon! Pot lights, smooth ceilings and crown moldings add an extra touch of sophistication to this already stunning home. The spacious master bedroom suite offers ensuite bath with quartz countertop, heated flooring and custom built walk-in closet, providing the ultimate in comfort and convenience. The professionally finished Walk-Out basement features a lot of storage space, cozy family room with wood burning fireplace is perfect for entertaining and walking to private, beautifully landscaped backyard with Inground pool. Entertainment room with ample space for family and guests to gather. Stylish chandeliers, crown moldings and freshly painted in designer colors add an extra touch of luxury and glamour. Enjoy your own private backyard oasis, with Inground pool, tied deck, gas BBQ set up, perfect for outdoor living and entertaining. The double driveway and two-car garage with separate entrance provide plenty of parking and storage space. Located near QEW, 407, GO train, and Top rated schools, this home is a must-see! Don't miss out on this 10+ loaded home, ready for you to move in and enjoy! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T18:57:06.758633+00:00"
+"Directions": "QEW/Brant North/Upper Middle"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:1 [
0 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1500532"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T18:11:14Z"
+"PhotosCount": 43
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:11:13Z"
+"Stories": "2.0"
+"StreetName": "MONMOUTH"
+"StreetNumber": "1320"
+"StreetSuffix": "Drive"
+"SubdivisionName": "340 - Tyandaga"
+"TaxAnnualAmount": "9677.61"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911053/1320-monmouth-drive-burlington"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2-Residential"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 2923
+"BelowGradeFinishedArea": 1150
+"OriginalEntryTimestamp": "2026-06-16T18:11:13.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1135714"
+"ListOfficeNationalAssociationId": "1394395"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911053')"
+"ID": "1535952"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25171
+post_id: "1532425"
+post_author: 1
+"ListingKey": "29905860"
+"ListingId": "W13446866"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:15:03Z"
+"RFModificationTimestamp": "2026-06-15T23:17:05Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Brant Hills)"
+"PostalCode": "L7P3W2"
+"UnparsedAddress": "2258 MANCHESTER DRIVE, Burlington (Brant Hills), Ontario L7P3W2"
+"Coordinates": array:2 [
0 => -79.8416756
1 => 43.36829
]
+"Latitude": 43.36829
+"Longitude": -79.8416756
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Over 200K in renovations! Featuring a separate entrance to an in-law suite. This beautiful semi-detached 3+1 bedroom 3 bathroom home is newly renovated from top to bottom and is designed to meet all your family's needs! The main floor features a large living room, dining room, full kitchen with brand new appliances and quartz countertops, a two piece bathroom, electric fireplace and a walkout to your spacious deck and backyard! The upper level features 3 large bedrooms bedroom with a 4 piece bathroom and the convenience of laundry! The basement holds a full 1 bedroom in-law suite, a 4 piece bathroom, electric fireplace and a second set of laundry. All new pot lights and vinyl floors throughout the entire home! The electrical panel was also upgraded to a 200amp service! The exterior of the home features a widened driveway space for plenty of parking, a front and back deck, lots of parking space and a very spacious backyard for you to enjoy with the family and guests! This home truly has it all! Close to parks, schools grocery stores and more! (id:62650)"
+"Appliances": array:6 [
0 => "Dishwasher"
1 => "Dryer"
2 => "Microwave"
3 => "Two stoves"
4 => "Two Washers"
5 => "Two Refrigerators"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T23:16:44.470902+00:00"
+"Directions": "Cross Streets: Middlesmoor Crescent. ** Directions: Middlesmoor Cres to Manchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135135"
+"ListOfficeKey": "289645"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "30 x 115 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T23:06:42Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T23:06:42Z"
+"Stories": "2.0"
+"StreetName": "Manchester"
+"StreetNumber": "2258"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3866.94"
+"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": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Brant Hills"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905860/2258-manchester-drive-burlington-brant-hills-brant-hills"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-06-15T19:17:43.56Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1387508"
+"ListOfficeNationalAssociationId": "1379865"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905860')"
+"ID": "1532425"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1531804"
+post_author: 1
+"ListingKey": "29903186"
+"ListingId": "40839736"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T16:00:26Z"
+"RFModificationTimestamp": "2026-06-15T20:34:35Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3023.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P3C3"
+"UnparsedAddress": "2390 SINCLAIR Circle, Burlington, Ontario L7P3C3"
+"Coordinates": array:2 [
0 => -79.8349082
1 => 43.3648635
]
+"Latitude": 43.3648635
+"Longitude": -79.8349082
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully Renovated Family Home in Desirable Brant Hill Welcome to this beautifully renovated backsplit, nestled on one of the largest lots in sought-after Sinclair Circle. Updated in 2022, this move-in-ready home offers 4 bedrooms, 3 bathrooms, a custom kitchen with quartz countertops and backsplash, and a bright walk-out lower level leading to a professionally landscaped backyard. Designed for comfortable family living, the home features spacious living areas, a versatile 1,000 sq. ft. standing crawl space for storage or recreation, and an attached double garage with insulation, drywall, epoxy flooring, and new doors. A wide driveway provides parking for up to 4 additional vehicles. Located in a quiet, family-friendly neighborhood close to schools, parks, shopping, and everyday amenities, this exceptional property combines modern upgrades, functional living space, and outstanding outdoor enjoyment. A rare opportunity not to be missed. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:34:24.025619+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987134"
+"ListOfficeKey": "55098"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:55:12Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:55:12Z"
+"Stories": "1.0"
+"StreetName": "SINCLAIR"
+"StreetNumber": "2390"
+"StreetSuffix": "Circle"
+"SubdivisionName": "341 - Brant Hills"
+"TaxAnnualAmount": "5975"
+"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/29903186/2390-sinclair-circle-burlington"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3.2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 2023
+"BelowGradeFinishedArea": 1000
+"OriginalEntryTimestamp": "2026-06-15T14:32:02.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1271443"
+"ListOfficeNationalAssociationId": "1003698"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903186')"
+"ID": "1531804"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1530759"
+post_author: 1
+"ListingKey": "29905025"
+"ListingId": "40839938"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:10:12Z"
+"RFModificationTimestamp": "2026-06-15T23:11:01Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1310.0
+"BuildingAreaTotal": 0
+"City": "Burlington"
+"PostalCode": "L7P3W2"
+"UnparsedAddress": "2258 MANCHESTER Drive, Burlington, Ontario L7P3W2"
+"Coordinates": array:2 [
0 => -79.8411812
1 => 43.3683793
]
+"Latitude": 43.3683793
+"Longitude": -79.8411812
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Over 200K in renovations! Featuring a separate entrance to an in-law suite. This beautiful semi-detached 3+1 bedroom 3 bathroom home is newly renovated from top to bottom and is designed to meet all your family's needs! The main floor features a large living room, dining room, full kitchen with brand new appliances and quartz countertops, a two piece bathroom, electric fireplace and a walkout to your spacious deck and backyard! The upper level features 3 large bedrooms bedroom with a 4 piece bathroom and the convenience of laundry! The basement holds a full 1 bedroom in-law suite, a 4 piece bathroom, electric fireplace and a second set of laundry. All new pot lights and vinyl floors throughout the entire home! The electrical panel was also upgraded to a 200amp service! The exterior of the home features a widened driveway space for plenty of parking, a front and back deck, lots of parking space and a very spacious backyard for you to enjoy with the family and guests! This home truly has it all! Close to parks, schools grocery stores and more! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:35:34.629649+00:00"
+"Directions": "Middlesmoor Crescent to Manchester Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136587"
+"ListOfficeKey": "289618"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"PhotosChangeTimestamp": "2026-06-15T23:02:52Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T23:02:52Z"
+"Stories": "2.0"
+"StreetName": "MANCHESTER"
+"StreetNumber": "2258"
+"StreetSuffix": "Drive"
+"SubdivisionName": "341 - Brant Hills"
+"TaxAnnualAmount": "3866.94"
+"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/29905025/2258-manchester-drive-burlington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1310
+"OriginalEntryTimestamp": "2026-06-15T17:51:36.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1388739"
+"ListOfficeNationalAssociationId": "1379562"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905025')"
+"ID": "1530759"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1527332"
+post_author: 1
+"ListingKey": "29899594"
+"ListingId": "W13440764"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T17:50:01Z"
+"RFModificationTimestamp": "2026-06-13T17:54:38Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Headon)"
+"PostalCode": "L7M3B1"
+"UnparsedAddress": "3200 GREENBOUGH CRESCENT, Burlington (Headon), Ontario L7M3B1"
+"Coordinates": array:2 [
0 => -79.819128
1 => 43.367698
]
+"Latitude": 43.367698
+"Longitude": -79.819128
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "his is the kind of home buyers keep hoping to find. Spacious, beautifully maintained, move-in ready, and offering incredible value in today's market.From the inviting front porch, perfect for an evening coffee, to the warm and stylish interior, this home has the space, comfort, and charm that make everyday living feel easy. Gorgeous hardwood-like flooring flows throughout much of the home, creating a seamless and welcoming feel.The spacious family room is a true highlight, featuring a WETT-certified wood-burning fireplace that sets the stage for cozy nights in. The formal living room, complete with a cathedral ceiling, offers an elegant yet comfortable place to relax, visit, or unwind.The bright eat-in kitchen includes all appliances and features a lovely bay window that fills the space with natural light. A separate dining room is ideal for hosting family and friends, with patio doors leading to a private, fully fenced backyard. The large multi-level deck offers plenty of room for outdoor dining, entertaining, and relaxing. With no neighbours directly behind, the yard feels open and private, with room for a future pool, play area, pets, gardens, or simply space to enjoy.The generously sized main floor laundry room adds everyday convenience, extra storage, and inside entry to the garage.Upstairs, you will find three spacious bedrooms, all with hardwood-like flooring, including a primary bedroom with a walk-in closet and ensuite privileges. The lower level is ready for your personal vision, offering a large open area for future finishing, along with a separate storage cupboard, workshop space, and furnace room.Ideally located close to public transit, shopping, schools, restaurants, parks, playgrounds, and walking and biking paths, this home offers the space, location, and value, If you are looking for room to grow, a family-friendly setting, and one of the best opportunities in the market right now, this home deserves your (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:41:11.266052+00:00"
+"Directions": "Cross Streets: Upland Drive. ** Directions: Uppermiddle to Upland to Greenbough."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1947876"
+"ListOfficeKey": "276328"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Irregular lot size"
2 => "Backs on greenbelt"
3 => "Level"
]
+"LotSizeDimensions": "26.5 x 137.1 FT ; 112.71ft x 26.51ft x 137.04ft x 58.40ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T02:13:24Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T17:43:34Z"
+"Stories": "2.0"
+"StreetName": "Greenbough"
+"StreetNumber": "3200"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4654"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"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": "Toronto"
+"CityRegion": "Headon"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29899594/3200-greenbough-crescent-burlington-headon-headon"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RM1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.6
+"OriginalEntryTimestamp": "2026-06-13T02:13:24.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1242530"
+"ListOfficeNationalAssociationId": "1273100"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899594')"
+"ID": "1527332"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25195
+post_id: "1526839"
+post_author: 1
+"ListingKey": "29897544"
+"ListingId": "W13438774"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:15:18Z"
+"RFModificationTimestamp": "2026-06-15T15:19:48Z"
+"ListPrice": 1249000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Burlington (Brant Hills)"
+"PostalCode": "L7P4C3"
+"UnparsedAddress": "2341 DUNCASTER DRIVE, Burlington (Brant Hills), Ontario L7P4C3"
+"Coordinates": array:2 [
0 => -79.844684
1 => 43.365114
]
+"Latitude": 43.365114
+"Longitude": -79.844684
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in Burlington's sought-after Brant Hills community, this beautifully maintained3+1 bedroom, 3.5 bathroom two-storey home offers the perfect blend of comfort, space, and location. Situated on a premium 50' x 120' lot directly across from a school and park on a quiet family-friendly street, this property is ideal for growing families. The spectacular private backyard oasis features lush gardens, mature trees, a stone patio, and an inground pool, creating an ideal setting for entertaining and enjoying summer days with family and friends. Inside, the bright and inviting living room showcases a large bay window overlooking the beautifully landscaped front yard and flows seamlessly into the dining room. The updated kitchen offers a centre island, abundant storage, and convenient access to the backyard, while the cozy family room with a gas fireplace and brick surround provides the perfect place to unwind. Hardwood flooring extends throughout the main and upper levels, complemented by beautifully renovated bathrooms. Upstairs, you'll find three spacious bedrooms and two full bathrooms, including a private primary ensuite. The finished lower level adds valuable living space with a fourth bedroom, a large full bathroom, and a recreation room. Enjoy the convenience of being within walking distance of schools, parks, and trails, with easy access to Highway 407, the QEW, Brant Hills Park, the Niagara Escarpment, and nearby conservation areas. This is a great opportunity to own a move-in-ready family home. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:14:58.140504+00:00"
+"Directions": "Cross Streets: Mellissa/Duncaster. ** Directions: Upper Middle/Duncaster Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964173"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Level"
2 => "Carpet Free"
3 => "Gazebo"
]
+"LotSizeDimensions": "50 x 120 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-15T15:11:37Z"
+"PhotosCount": 36
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:11:37Z"
+"Stories": "2.0"
+"StreetName": "Duncaster"
+"StreetNumber": "2341"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6254"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/2341_duncaster_dr_burlington_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Brant Hills"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29897544/2341-duncaster-drive-burlington-brant-hills-brant-hills"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R3.2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-12T19:46:04.94Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1252999"
+"ListOfficeNationalAssociationId": "1331925"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897544')"
+"ID": "1526839"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 126
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]