array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29972213 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1580610"
+post_author: 1
+"ListingKey": "29972213"
+"ListingId": "40844134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T19:30:08Z"
+"RFModificationTimestamp": "2026-06-30T23:08:38Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1160.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C1W5"
+"UnparsedAddress": "409 MOHAWK Road W, Hamilton, Ontario L9C1W5"
+"Coordinates": array:2 [
0 => -79.899471
1 => 43.2305525
]
+"Latitude": 43.2305525
+"Longitude": -79.899471
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained raised bungalow offering 3+2 bedrooms and 2 full bathrooms, perfect for growing families or multi-generational living. The bright main level features a spacious living room, formal dining room, and a generous eat-in kitchen with plenty of space for family gatherings. The fully finished basement includes two additional bedrooms, a large recreation room with a cozy fireplace, wet bar, and a separate walk-up entrance, offering excellent in-law suite potential. Situated on a beautifully landscaped, fully fenced lot, the backyard is clean, private, and thoughtfully designed for outdoor enjoyment. The oversized driveway accommodates up to 6 vehicles, while the attached garage features a 240V hydro plug and convenient drive-through access to the backyard. A fantastic home offering space, versatility, and exceptional value! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T23:08:31.338383+00:00"
+"Directions": "Mohawk West before Garth"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948261"
+"ListOfficeKey": "287174"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T19:20:20Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T19:20:20Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "MOHAWK"
+"StreetNumber": "409"
+"StreetSuffix": "Road"
+"SubdivisionName": "152 - Buchanan"
+"TaxAnnualAmount": "5170.02"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1672103011"
"RoomType" => "Laundry room"
"ListingId" => "40844134"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
1 => array:11 [
"RoomKey" => "1672103012"
"RoomType" => "Recreation room"
"ListingId" => "40844134"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "18'1'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
2 => array:11 [
"RoomKey" => "1672103013"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844134"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
3 => array:11 [
"RoomKey" => "1672103014"
"RoomType" => "Bedroom"
"ListingId" => "40844134"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
4 => array:11 [
"RoomKey" => "1672103015"
"RoomType" => "Bedroom"
"ListingId" => "40844134"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
5 => array:11 [
"RoomKey" => "1672103016"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
6 => array:11 [
"RoomKey" => "1672103017"
"RoomType" => "Bedroom"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
7 => array:11 [
"RoomKey" => "1672103018"
"RoomType" => "Bedroom"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
8 => array:11 [
"RoomKey" => "1672103019"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
9 => array:11 [
"RoomKey" => "1672103020"
"RoomType" => "Living room"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 22'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
10 => array:11 [
"RoomKey" => "1672103021"
"RoomType" => "Dining room"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
11 => array:11 [
"RoomKey" => "1672103022"
"RoomType" => "Kitchen"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.19Z"
]
12 => array:11 [
"RoomKey" => "1672103023"
"RoomType" => "Foyer"
"ListingId" => "40844134"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972213"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:20:20.2Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29972213/409-mohawk-road-w-hamilton"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523817"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55168"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1160
+"OriginalEntryTimestamp": "2026-06-30T19:20:20.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1242828"
+"ListOfficeNationalAssociationId": "1373445"
+"CoListAgentNationalAssociationId": "1063492"
+"CoListOfficeNationalAssociationId": "1116022"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29972213_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/243dec213e051d18f2ab9cf04705361e.webp"
"MediaSize" => 135087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-243dec213e051d18f2ab9cf04705361e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29972213_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/9bfecbe0eaa60b99dc8857d7c2af61dc.webp"
"MediaSize" => 138012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-9bfecbe0eaa60b99dc8857d7c2af61dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29972213_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/dd248dd4089699e1d0b6c03fe8f0e7dc.webp"
"MediaSize" => 164820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-dd248dd4089699e1d0b6c03fe8f0e7dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29972213_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/0efd5a04e128d6f82cd74fdcfa0f1d86.webp"
"MediaSize" => 82723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-0efd5a04e128d6f82cd74fdcfa0f1d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29972213_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/776c96779a13e4519c470649be7879ca.webp"
"MediaSize" => 76346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-776c96779a13e4519c470649be7879ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29972213_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/8a746c44d0f92ec4f06a4acbc1ed4fbb.webp"
"MediaSize" => 87542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-8a746c44d0f92ec4f06a4acbc1ed4fbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29972213_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/f7b7b9ef3f7e26b843e1e1c5b2be59dc.webp"
"MediaSize" => 101295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-f7b7b9ef3f7e26b843e1e1c5b2be59dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29972213_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/46878a4af148d64b53036ecfb0d1d739.webp"
"MediaSize" => 90556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-46878a4af148d64b53036ecfb0d1d739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29972213_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/aa4b78ef31001f4e9016d396b0282ddb.webp"
"MediaSize" => 107509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-aa4b78ef31001f4e9016d396b0282ddb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29972213_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/cc2c08cc892929809b4615cac1f027d1.webp"
"MediaSize" => 108386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-cc2c08cc892929809b4615cac1f027d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29972213_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/0ec24f5843da79269e8e986ba5416f0d.webp"
"MediaSize" => 99569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-0ec24f5843da79269e8e986ba5416f0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29972213_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/26b3496cd0474f08c8001e01d79d7b08.webp"
"MediaSize" => 126005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-26b3496cd0474f08c8001e01d79d7b08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29972213_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/500e5444ccda7cffde16bace67dfa946.webp"
"MediaSize" => 97289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-500e5444ccda7cffde16bace67dfa946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29972213_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/92252cdbf4ffb0a680fd987244d1915d.webp"
"MediaSize" => 109548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-92252cdbf4ffb0a680fd987244d1915d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29972213_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/bd1061c9f627ebf48e1bc1cf315a00a6.webp"
"MediaSize" => 104110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-bd1061c9f627ebf48e1bc1cf315a00a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29972213_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/467bc8f93376465eaca82809108ba3bb.webp"
"MediaSize" => 79729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-467bc8f93376465eaca82809108ba3bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29972213_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/dcd046f0ce079c57ff1c3a4ff4920169.webp"
"MediaSize" => 61554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-dcd046f0ce079c57ff1c3a4ff4920169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29972213_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/121e7d810cd76820f00014dcef4d301f.webp"
"MediaSize" => 99208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-121e7d810cd76820f00014dcef4d301f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29972213_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/609788d0b93b9503f28dc9cb5a4dc67b.webp"
"MediaSize" => 84434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-609788d0b93b9503f28dc9cb5a4dc67b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29972213_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/dd1e8e9d3683b60df5d514655eac8ac2.webp"
"MediaSize" => 61583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-dd1e8e9d3683b60df5d514655eac8ac2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29972213_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/0ae67de3ad44d8c548d36265d3167c55.webp"
"MediaSize" => 100668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-0ae67de3ad44d8c548d36265d3167c55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29972213_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/0d8d6821cb3d7807cf2c3a3e8727374c.webp"
"MediaSize" => 104986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-0d8d6821cb3d7807cf2c3a3e8727374c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29972213_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/238c3434f58e4a8b4ff69d564dffce7d.webp"
"MediaSize" => 115439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-238c3434f58e4a8b4ff69d564dffce7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29972213_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/031caa7e24941f6470eae68eb72c81c4.webp"
"MediaSize" => 100061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-031caa7e24941f6470eae68eb72c81c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29972213_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/57494dcf342231c8dbbcfb2a4f7a97da.webp"
"MediaSize" => 62396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-57494dcf342231c8dbbcfb2a4f7a97da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29972213_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/383715a50c2b048e21b38a2f502568bd.webp"
"MediaSize" => 66947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-383715a50c2b048e21b38a2f502568bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29972213_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/f04e2c082989794879945ca355d59694.webp"
"MediaSize" => 77255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-f04e2c082989794879945ca355d59694.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29972213_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/1cda98f58d05e0397a06694e2f991d6e.webp"
"MediaSize" => 64687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-1cda98f58d05e0397a06694e2f991d6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29972213_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/7865a64197caeaa929abcc46bf99b6f2.webp"
"MediaSize" => 139110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-7865a64197caeaa929abcc46bf99b6f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29972213_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/6affc36b4f05eb48ed3331e1121558e4.webp"
"MediaSize" => 170364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-6affc36b4f05eb48ed3331e1121558e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29972213_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/a077f3f4a8a66687e58e124e9aa0a32f.webp"
"MediaSize" => 173657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-a077f3f4a8a66687e58e124e9aa0a32f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29972213_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/9aa3f8f00e3d1b656415d8954abe561b.webp"
"MediaSize" => 168330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-9aa3f8f00e3d1b656415d8954abe561b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29972213_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/95ded66ad7596ba2649561dd595ba3f7.webp"
"MediaSize" => 183247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-95ded66ad7596ba2649561dd595ba3f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29972213_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/00fe9efecb652461e6647dbdf80e50d2.webp"
"MediaSize" => 167123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-00fe9efecb652461e6647dbdf80e50d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29972213_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/b8bc65cf699b50d074bd6fc57ca69acb.webp"
"MediaSize" => 150038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-b8bc65cf699b50d074bd6fc57ca69acb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29972213_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/ed7604e201fb5e84279cbde157d73ef1.webp"
"MediaSize" => 167697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-ed7604e201fb5e84279cbde157d73ef1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29972213_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/919d0c9d35df59269e158c57b92101db.webp"
"MediaSize" => 185528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-919d0c9d35df59269e158c57b92101db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29972213_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972213/19383841807337d78e91f28dc24f737d.webp"
"MediaSize" => 195950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972213/thumbnail-19383841807337d78e91f28dc24f737d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844134"
"ResourceRecordKey" => "29972213"
"ModificationTimestamp" => "2026-06-30T19:20:20.15Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29972213')"
+"ID": "1580610"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 287174" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+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 1948261" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24861
+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 '29972213'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+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 '29972213'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29972213' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.899471 43.2305525)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25349
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1584069"
+post_author: 1
+"ListingKey": "29978259"
+"ListingId": "40844110"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:40:12Z"
+"RFModificationTimestamp": "2026-07-02T17:03:56Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.1
+"LivingArea": 2655.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C7S2"
+"UnparsedAddress": "734 BRIGADOON Drive, Hamilton, Ontario L9C7S2"
+"Coordinates": array:2 [
0 => -79.9018729
1 => 43.215036
]
+"Latitude": 43.215036
+"Longitude": -79.9018729
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautifully maintained three bedroom family home offers the perfect blend of comfort, style, and functionality. The inviting main floor is designed for everyday living and entertaining alike. Enjoy a bright, eat-in kitchen featuring granite countertops and stainless steel appliances, seamlessly connected to a cozy family room with a gas fireplace and elegant crown moulding. A convenient mudroom and laundry combination provides the ideal space to drop coats and backpacks and keep family life organized. Rich hardwood flooring flows throughout the home, leading upstairs to a generously sized primary retreat with a luxurious ensuite boasting a separate shower and a relaxing whirlpool tub. Two additional large bedrooms, a bright 4-piece bathroom, and a charming loft area, perfect for reading, music, or a quiet workspace, complete the upper level. The finished basement expands your living space with a large recreation room ideal for entertaining, along with a versatile bonus room that can easily serve as a home office, gym, or playroom. A 3 piece bathroom with glass shower and plenty of storage space completes this floor. Step outside to your private backyard oasis, thoughtfully designed with custom stone pathways and a stunning, custom stone fireplace. With no grass to maintain, this outdoor space is perfect for relaxing or hosting gatherings with ease. Nestled in a highly desirable neighbourhood surrounded by mature trees and directly across from scenic woodland, this home offers both tranquility and convenience. The trail across the road takes you to Gourley park with new sports court, tennis court, playground, and splash pad. Close to excellent schools and just minutes from the Lincoln Alexander Parkway and 403, this is an exceptional opportunity for families seeking both comfort and location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:03:47.451058+00:00"
+"Directions": "Stone Church Rd. W., North on Matthews, Right on Brigadoon"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525220"
+"ListOfficeKey": "54969"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Automatic Garage Door Opener"
1 => "Private Yard"
]
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:32:12Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:32:12Z"
+"Stories": "2.0"
+"StreetName": "BRIGADOON"
+"StreetNumber": "734"
+"StreetSuffix": "Drive"
+"SubdivisionName": "165 - Gourley/Kernighan"
+"TaxAnnualAmount": "6662"
+"VirtualTourURLUnbranded": "https://book.allisonmediaco.com/sites/ekpzbamq/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1673338244"
"RoomType" => "Utility room"
"ListingId" => "40844110"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "27'2'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.06Z"
]
1 => array:11 [
"RoomKey" => "1673338245"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844110"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.06Z"
]
2 => array:11 [
"RoomKey" => "1673338246"
"RoomType" => "Bedroom"
"ListingId" => "40844110"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
3 => array:11 [
"RoomKey" => "1673338247"
"RoomType" => "Recreation room"
"ListingId" => "40844110"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "26'8'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
4 => array:11 [
"RoomKey" => "1673338248"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844110"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
5 => array:11 [
"RoomKey" => "1673338249"
"RoomType" => "Loft"
"ListingId" => "40844110"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
6 => array:11 [
"RoomKey" => "1673338250"
"RoomType" => "Bedroom"
"ListingId" => "40844110"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
7 => array:11 [
"RoomKey" => "1673338251"
"RoomType" => "Bedroom"
"ListingId" => "40844110"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
8 => array:11 [
"RoomKey" => "1673338252"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844110"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
9 => array:11 [
"RoomKey" => "1673338253"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844110"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
10 => array:11 [
"RoomKey" => "1673338254"
"RoomType" => "Laundry room"
"ListingId" => "40844110"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.07Z"
]
11 => array:11 [
"RoomKey" => "1673338255"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844110"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.08Z"
]
12 => array:11 [
"RoomKey" => "1673338256"
"RoomType" => "Family room"
"ListingId" => "40844110"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.08Z"
]
13 => array:11 [
"RoomKey" => "1673338257"
"RoomType" => "Eat in kitchen"
"ListingId" => "40844110"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.08Z"
]
14 => array:11 [
"RoomKey" => "1673338258"
"RoomType" => "Office"
"ListingId" => "40844110"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.08Z"
]
15 => array:11 [
"RoomKey" => "1673338259"
"RoomType" => "Living room/Dining room"
"ListingId" => "40844110"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29978259"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T15:32:12.08Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978259/734-brigadoon-drive-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1980
+"BelowGradeFinishedArea": 675
+"OriginalEntryTimestamp": "2026-07-02T15:32:11.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063851"
+"ListOfficeNationalAssociationId": "1003577"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29978259_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/fae43d4a5ae1fcea58b345eef1805e6d.webp"
"MediaSize" => 165519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-fae43d4a5ae1fcea58b345eef1805e6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29978259_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/5ccb653dfb7ece6ee336d29b642698c0.webp"
"MediaSize" => 168085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-5ccb653dfb7ece6ee336d29b642698c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29978259_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/2ce6e5705447f1adebe8e50b2c66ce53.webp"
"MediaSize" => 164061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-2ce6e5705447f1adebe8e50b2c66ce53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29978259_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/37a34b86b765bc5c06b5fac696c30044.webp"
"MediaSize" => 80172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-37a34b86b765bc5c06b5fac696c30044.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29978259_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/58cd9476b08e079d292330c1be1b6747.webp"
"MediaSize" => 90061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-58cd9476b08e079d292330c1be1b6747.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29978259_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/1d812616105d38e4176aa3a149728326.webp"
"MediaSize" => 82355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-1d812616105d38e4176aa3a149728326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29978259_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/29f3987316584952a05fd76ef7876eb3.webp"
"MediaSize" => 77011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-29f3987316584952a05fd76ef7876eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29978259_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/f266cc9e2cbcd65a095d7e120381fae4.webp"
"MediaSize" => 80307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-f266cc9e2cbcd65a095d7e120381fae4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29978259_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/60eb3678807abd1871706d69a9b87cee.webp"
"MediaSize" => 87676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-60eb3678807abd1871706d69a9b87cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29978259_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/38cdbebaffa3c49dbe72e3dd54fd2f3a.webp"
"MediaSize" => 86955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-38cdbebaffa3c49dbe72e3dd54fd2f3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29978259_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/28db52e4082c45e8d96e0a2d95d55112.webp"
"MediaSize" => 95385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29978259/thumbnail-28db52e4082c45e8d96e0a2d95d55112.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844110"
"ResourceRecordKey" => "29978259"
"ModificationTimestamp" => "2026-07-02T15:32:11.99Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29978259_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29978259/b6ae3154c0261a0fb614f87c47b0c8ab.webp"
"MediaSize" => 94500
"MediaType" => "webp"
…8
]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978259')"
+"ID": "1584069"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "1583895"
+post_author: 1
+"ListingKey": "29978532"
+"ListingId": "X13512426"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:05:05Z"
+"RFModificationTimestamp": "2026-07-02T16:41:27Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Fessenden)"
+"PostalCode": "L9C5X5"
+"UnparsedAddress": "80 WENDOVER DRIVE, Hamilton (Fessenden), Ontario L9C5X5"
+"Coordinates": array:2 [
0 => -79.918676
1 => 43.232528
]
+"Latitude": 43.232528
+"Longitude": -79.918676
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained raised bungalow in Hamilton's highly sought-after Fessenden neighbourhood! Offering the affordability of a semi-detached home with **no condo or road fees**, this property combines thoughtful updates, generous living space, and an exceptional backyard. The bright main level features a stunning custom kitchen designed for both everyday living and entertaining, complete with a large centre island, granite countertops, solid wood cabinetry, and an impressive amount of storage. Sliding patio doors lead directly to a spacious deck and gazebo, creating the perfect setting for summer barbecues and outdoor gatherings while overlooking the incredible 120-foot deep lot. With two bedrooms on the main level and an additional bedroom plus a versatile bonus room in the bright lower level, there's plenty of space for growing families, guests, a home office, or hobby room. The finished basement offers large windows that fill the space with natural light, making it feel welcoming and functional. The home also features one full bathroom and a convenient two-piece bathroom. Major mechanical updates provide peace of mind, including an updated furnace, central air conditioning, and an on-demand hot water system. Located in the desirable Fessenden neighbourhood on Hamilton's West Mountain, you'll enjoy easy access to schools, parks, shopping, restaurants, transit, and major highway routes. This move-in-ready home offers outstanding value in one of the city's most popular family-friendly communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Water Heater - Tankless"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:41:19.421165+00:00"
+"Directions": "Cross Streets: Magnolia Dr. ** Directions: Magnolia Dr to Wendover Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2251180"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 120 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:58:07Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:58:07Z"
+"Stories": "1.0"
+"StreetName": "WENDOVER"
+"StreetNumber": "80"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3967"
+"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": 2026
+"CityRegion": "Fessenden"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29978532/80-wendover-drive-hamilton-fessenden-fessenden"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-07-02T15:58:07.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1490187"
+"ListOfficeNationalAssociationId": "1304915"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978532')"
+"ID": "1583895"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: "1582391"
+post_author: 1
+"ListingKey": "29975411"
+"ListingId": "X13509018"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T17:35:29Z"
+"RFModificationTimestamp": "2026-07-01T17:38:42Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gourley)"
+"PostalCode": "L9C7S2"
+"UnparsedAddress": "734 BRIGADOON DRIVE, Hamilton (Gourley), Ontario L9C7S2"
+"Coordinates": array:2 [
0 => -79.9019301
1 => 43.2150755
]
+"Latitude": 43.2150755
+"Longitude": -79.9019301
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "This beautifully maintained three bedroom family home offers the perfect blend of comfort, style, and functionality. The inviting main floor is designed for everyday living and entertaining alike. Enjoy a bright, eat-in kitchen featuring granite countertops and stainless steel appliances, seamlessly connected to a cozy family room with a gas fireplace and elegant crown moulding. A convenient mudroom and laundry combination provides the ideal space to drop coats and backpacks and keep family life organized. Rich hardwood flooring flows throughout the home, leading upstairs to a generously sized primary retreat with a luxurious ensuite boasting a separate shower and a relaxing whirlpool tub. Two additional large bedrooms, a bright 4-piece bathroom, and a charming loft area, perfect for reading, music, or a quiet workspace, complete the upper level. The finished basement expands your living space with a large recreation room ideal for entertaining, along with a versatile bonus room that can easily serve as a home office, gym, or playroom. A 3 piece bathroom with glass shower and plenty of storage space completes this floor. Step outside to your private backyard oasis, thoughtfully designed with custom stone pathways and a stunning, custom stone fireplace. With no grass to maintain, this outdoor space is perfect for relaxing or hosting gatherings with ease. Nestled in a highly desirable neighbourhood surrounded by mature trees and directly across from scenic woodland, this home offers both tranquility and convenience. The trail across the road takes you to Gourley park with new sports court, tennis court, playground, and splash pad. Close to excellent schools and just minutes from the Lincoln Alexander Parkway and 403, this is an exceptional opportunity for families seeking both comfort and location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Oven"
5 => "Dryer"
6 => "Cooktop"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T17:38:29.896182+00:00"
+"Directions": "Cross Streets: Stone Church and Garth. ** Directions: Stone Church, North on Matthews, East on Brigadoon."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834887"
+"ListOfficeKey": "75363"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40.1 x 117.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T16:27:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T16:59:05Z"
+"Stories": "2.0"
+"StreetName": "Brigadoon"
+"StreetNumber": "734"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6662"
+"VirtualTourURLUnbranded": "https://book.allisonmediaco.com/sites/ekpzbamq/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "Gourley"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29975411/734-brigadoon-drive-hamilton-gourley-gourley"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.1
+"OriginalEntryTimestamp": "2026-07-01T16:27:04.78Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1196851"
+"ListOfficeNationalAssociationId": "1001489"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975411')"
+"ID": "1582391"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1582581"
+post_author: 1
+"ListingKey": "29974726"
+"ListingId": "40844103"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T12:30:21Z"
+"RFModificationTimestamp": "2026-07-01T17:16:35Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 777.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C5X5"
+"UnparsedAddress": "80 WENDOVER Drive, Hamilton, Ontario L9C5X5"
+"Coordinates": array:2 [
0 => -79.9184558
1 => 43.2324059
]
+"Latitude": 43.2324059
+"Longitude": -79.9184558
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained raised bungalow in Hamilton's highly sought-after Fessenden neighbourhood! Offering the affordability of a semi-detached home with **no condo or road fees**, this property combines thoughtful updates, generous living space, and an exceptional backyard. The bright main level features a stunning custom kitchen designed for both everyday living and entertaining, complete with a large centre island, granite countertops, solid wood cabinetry, and an impressive amount of storage. Sliding patio doors lead directly to a spacious deck and gazebo, creating the perfect setting for summer barbecues and outdoor gatherings while overlooking the incredible 120-foot deep lot. With two bedrooms on the main level and an additional bedroom plus a versatile bonus room in the bright lower level, there's plenty of space for growing families, guests, a home office, or hobby room. The finished basement offers large windows that fill the space with natural light, making it feel welcoming and functional. The home also features one full bathroom and a convenient two-piece bathroom. Major mechanical updates provide peace of mind, including an updated furnace, central air conditioning, and an on-demand hot water system. Located in the desirable Fessenden neighbourhood on Hamilton's West Mountain, you'll enjoy easy access to schools, parks, shopping, restaurants, transit, and major highway routes. This move-in-ready home offers outstanding value in one of the city's most popular family-friendly communities. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T17:11:38.770862+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005282"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-01T12:21:01Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T12:21:01Z"
+"Stories": "1.0"
+"StreetName": "WENDOVER"
+"StreetNumber": "80"
+"StreetSuffix": "Drive"
+"SubdivisionName": "160 - Fessenden"
+"TaxAnnualAmount": "3967"
+"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/29974726/80-wendover-drive-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "d"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 777
+"OriginalEntryTimestamp": "2026-07-01T12:20:21.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1287615"
+"ListOfficeNationalAssociationId": "1377637"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974726')"
+"ID": "1582581"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1581341"
+post_author: 1
+"ListingKey": "29974135"
+"ListingId": "X13507718"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T03:45:15Z"
+"RFModificationTimestamp": "2026-07-01T03:49:18Z"
+"ListPrice": 379900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Rolston)"
+"PostalCode": "L9C7M7"
+"UnparsedAddress": "804 - 200 LIMERIDGE ROAD W, Hamilton (Rolston), Ontario L9C7M7"
+"Coordinates": array:2 [
0 => -79.89439
1 => 43.222817
]
+"Latitude": 43.222817
+"Longitude": -79.89439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright, ultra-stylish, and completely turnkey! Welcome home to unit #804 at 200 Limeridge Road West, perfectly situated in Hamilton's highly desirable West Mountain. This gorgeous penthouse level 1-Bedroom +Den condo is a generous size at 879 sqft, and is the definition of super cute. It has been stylishly updated with brand-new flooring throughout, and a freshly painted in a modern paint palette. From the moment you step inside, you notice the higher 9ft ceilings, and will love the fantastic and functional layout flooded with natural light thanks to an abundance of massive windows. The spacious primary bedroom features plenty of closet space, while the bright, versatile den comes complete with doors, making it the perfect home office or a fully functional second bedroom as currently used. The property offers total convenience with a separate dining area, functional kitchen, a full 4-piece bath, plenty of storage/closet space, and in-suite laundry. To complete the package, this beautiful unit also includes 1 designated parking space and a separate storage locker. Enjoy the outdoor space as well with the beautiful tree-covered property around the building. Location is fantastic, quiet mountain neighborhood close to shopping, transit, highways, trails and highly rated schools. Truly a stylish standout where all the hard work has already been done for you-just move in and enjoy! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"AssociationFee": "603.63"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T01:22:07.717806+00:00"
+"Directions": "Cross Streets: Garth and Limeridge Rd W. ** Directions: Garth to Limeridge Rd W. Go EAST on Limeridge."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1985651"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-01T03:37:55Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T03:37:55Z"
+"StreetDirSuffix": "West"
+"StreetName": "Limeridge"
+"StreetNumber": "200"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2634.96"
+"VirtualTourURLUnbranded": "https://propertyvision.ca/tour/17633?unbranded"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rolston"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29974135/804-200-limeridge-road-w-hamilton-rolston-rolston"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-01T00:55:20.78Z"
+"ListAgentNationalAssociationId": "1270240"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974135')"
+"ID": "1581341"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1581342"
+post_author: 1
+"ListingKey": "29974139"
+"ListingId": "X13507778"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:45:08Z"
+"RFModificationTimestamp": "2026-07-02T16:50:00Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Rolston)"
+"PostalCode": "L9C2V3"
+"UnparsedAddress": "111 LIMERIDGE ROAD W, Hamilton (Rolston), Ontario L9C2V3"
+"Coordinates": array:2 [
0 => -79.890539
1 => 43.220977
]
+"Latitude": 43.220977
+"Longitude": -79.890539
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Turnkey Investment & Family Home with Exceptional Income Potential! Beautifully renovated approx. 1,500 sq. ft. home featuring a legal duplex plus a legal studio basement apartment, offering outstanding flexibility for investors or multi-generational families. Fully renovated in June 2026, this move-in-ready property showcases new flooring throughout, fresh paint, and modern finishes from top to bottom. The home offers 4 spacious bedrooms above grade, central air conditioning ( June 2026), and an impressive package of new appliances, including 2 refrigerators, microwaves, and a dedicated washer and dryer for the basement unit. Designed for strong rental performance, this property provides the potential for positive cash flow with three legal living spaces. Situated on a huge lot with parking for up to 5 vehicles, it offers convenience rarely found in the area. Ideally located just minutes from Mohawk College, the vibrant Upper James Street commercial corridor, grocery stores, restaurants, shopping, public transit, schools, parks, and all major amenities. A rare opportunity to own a fully renovated, income-generating property in one of Hamilton's most desirable rental locations. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T01:22:07.589213+00:00"
+"Directions": "Cross Streets: Limeridge West And West 5th. ** Directions: Map."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152902"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 102.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T02:03:49Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:33:44Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "Limeridge"
+"StreetNumber": "111"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4112"
+"VirtualTourURLUnbranded": "https://tour.portraitsdonebetter.com/328176"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Rolston"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29974139/111-limeridge-road-w-hamilton-rolston-rolston"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-07-01T00:55:21.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1404582"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974139')"
+"ID": "1581342"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1581041"
+post_author: 1
+"ListingKey": "29973908"
+"ListingId": "40844231"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T00:40:05Z"
+"RFModificationTimestamp": "2026-07-01T00:40:28Z"
+"ListPrice": 379900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 879.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C7M7"
+"UnparsedAddress": "200 LIMERIDGE Road W Unit# 804, Hamilton, Ontario L9C7M7"
+"Coordinates": array:2 [
0 => -79.8941603
1 => 43.222123
]
+"Latitude": 43.222123
+"Longitude": -79.8941603
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, ultra-stylish, and completely turnkey! Welcome home to #804 at 200 Limeridge Road West, perfectly situated in Hamilton’s highly desirable West Mountain. This gorgeous penthouse level 1-Bedroom+Den condo is a generous size at 879 sqft, and is the definition of super cute. It has been stylishly updated with brand-new flooring throughout, and a freshly painted in a modern paint palette. From the moment you step inside, you notice the higher 9ft ceilings, and will love the fantastic and functional layout flooded with natural light thanks to an abundance of massive windows. The spacious primary bedroom features plenty of closet space, while the bright, versatile den comes complete with doors, making it the perfect home office or a fully functional second bedroom as currently used. The property offers total convenience with a separate dining area, functional kitchen, a full 4-piece bath, plenty of storage/closet space, and in-suite laundry. To complete the package, this beautiful unit also includes one designated parking space and a separate storage locker. Located in a fantastic mountain neighborhood close to shopping, transit, and highways, this is truly a stylish standout where all the hard work has already been done for you—just move in and enjoy! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "603.63"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T00:40:19.402327+00:00"
+"Directions": "Garth St to Limeridge Rd W. Head East on Limeridge Road W"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1912221"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T23:50:25Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T00:31:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "LIMERIDGE"
+"StreetNumber": "200"
+"StreetSuffix": "Road"
+"SubdivisionName": "162 - Rolston/Yeoville"
+"TaxAnnualAmount": "2634.96"
+"VirtualTourURLUnbranded": "https://propertyvision.ca/tour/17633"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29973908/200-limeridge-road-w-unit-804-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1912077"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55164"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "E/S-69a"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 879
+"OriginalEntryTimestamp": "2026-06-30T23:50:25.71Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1223084"
+"ListOfficeNationalAssociationId": "1003546"
+"CoListAgentNationalAssociationId": "1222990"
+"CoListOfficeNationalAssociationId": "1003546"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29973908')"
+"ID": "1581041"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25347
+post_id: "1580469"
+post_author: 1
+"ListingKey": "29972476"
+"ListingId": "X13506400"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T20:05:20Z"
+"RFModificationTimestamp": "2026-06-30T22:59:10Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Rolston)"
+"PostalCode": "L9C1W5"
+"UnparsedAddress": "409 MOHAWK ROAD W, Hamilton (Rolston), Ontario L9C1W5"
+"Coordinates": array:2 [
0 => -79.89949
1 => 43.230523
]
+"Latitude": 43.230523
+"Longitude": -79.89949
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained raised bungalow offering 3+2 bedrooms and 2 full bathrooms, perfect for growing families or multi-generational living. The bright main level features a spacious living room, formal dining room, and a generous eat-in kitchen with plenty of space for family gatherings. The fully finished basement includes two additional bedrooms, a large recreation room with a cozy fireplace, wet bar, and a separate walk-up entrance, offering excellent in-law suite potential. Situated on a beautifully landscaped, fully fenced lot, the backyard is clean, private, and thoughtfully designed for outdoor enjoyment. The oversized driveway accommodates up to 6 vehicles, while the attached garage features a 240V hydro plug and convenient drive-through access to the backyard. A fantastic home offering space, versatility, and exceptional value! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T22:59:06.032365+00:00"
+"Directions": "Cross Streets: Garth St. ** Directions: Mohawk West before Garth."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236294"
+"ListOfficeKey": "50984"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 129.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T19:57:08Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T19:57:08Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "Mohawk"
+"StreetNumber": "409"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5170.02"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Rolston"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29972476/409-mohawk-road-w-hamilton-rolston-rolston"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-30T19:57:08.35Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1474342"
+"ListOfficeNationalAssociationId": "1001061"
+"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('29972476')"
+"ID": "1580469"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+post_id: "1577320"
+post_author: 1
+"ListingKey": "29968610"
+"ListingId": "X13502898"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T00:20:05Z"
+"RFModificationTimestamp": "2026-06-30T00:24:06Z"
+"ListPrice": 749955.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Mohawk)"
+"PostalCode": "L9A1R8"
+"UnparsedAddress": "87 FENNELL AVENUE W, Hamilton (Mohawk), Ontario L9A1R8"
+"Coordinates": array:2 [
0 => -79.881579
1 => 43.23833
]
+"Latitude": 43.23833
+"Longitude": -79.881579
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully renovated detached home in a prime Hamilton Mountain location, just a 5-minute walk to Mohawk College and St. Joseph's Healthcare Hamilton - Charlton Campus**This turnkey property offers 4 spacious bedrooms above grade and a finished 2-bedroom basement apartment with a separate entrance, making it ideal for large families, multi-generational living, or investors seeking excellent income potential**The home has been extensively renovated and features two brand-new modern kitchens, new flooring throughout, fresh paint, stylish pot lights throughout, and quality finishes that create a bright, contemporary living space**The functional layout offers generous principal rooms, spacious bedrooms, and plenty of natural light, providing comfort and flexibility for a variety of lifestyles**Located in a highly desirable neighbourhood close to public transit, shopping, restaurants, schools, parks, and all essential amenities, this property offers exceptional convenience**With its unbeatable location near Mohawk College and the hospital campus, this home presents an outstanding opportunity for homeowners and investors alike**Move-in ready and loaded with upgrades-don't miss your chance to own this exceptional property! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Dryer"
3 => "Two stoves"
4 => "Two Refrigerators"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T00:23:56.500088+00:00"
+"Directions": "Cross Streets: Fennell Ave W/ West 4th. ** Directions: West."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1817219"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "55.9 x 90 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T22:50:40Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T00:14:56Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "Fennell"
+"StreetNumber": "87"
+"StreetSuffix": "Avenue"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/465125/branded/9605"
+"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": "Mohawk"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29968610/87-fennell-avenue-w-hamilton-mohawk-mohawk"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 55.1
+"OriginalEntryTimestamp": "2026-06-29T22:50:39.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1192906"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968610')"
+"ID": "1577320"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 209
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]