array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29251089/Property?$select=ALL&$top=20&$filter=ListingKey eq 29251089&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29251089/Property?$select=ALL&$top=20&$filter=ListingKey eq 29251089&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "535552"
+post_author: 1
+"ListingKey": "29251089"
+"ListingId": "40798532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:45:51Z"
+"RFModificationTimestamp": "2026-01-15T00:04:47Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2841.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "100 WATERSHORE Drive Unit# 19, Stoney Creek, Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.675003
1 => 43.229989
]
+"Latitude": 43.229989
+"Longitude": -79.675003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity— an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island— ideal for both casual meals and upscale entertaining. As a purchaser, you’ll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home’s living and dining areas, centered around a 46” gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer— a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:04:22.760439+00:00"
+"Directions": "Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025165"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:38:15Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:38:15Z"
+"Stories": "1.0"
+"StreetName": "WATERSHORE"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"View": "Lake view"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1560357716"
"RoomType" => "Laundry room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
1 => array:11 [
"RoomKey" => "1560357717"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
2 => array:11 [
"RoomKey" => "1560357718"
"RoomType" => "5pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
3 => array:11 [
"RoomKey" => "1560357719"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
4 => array:11 [
"RoomKey" => "1560357720"
"RoomType" => "Den"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
5 => array:11 [
"RoomKey" => "1560357721"
"RoomType" => "Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
6 => array:11 [
"RoomKey" => "1560357722"
"RoomType" => "Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
7 => array:11 [
"RoomKey" => "1560357723"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
8 => array:11 [
"RoomKey" => "1560357724"
"RoomType" => "Dining room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
9 => array:11 [
"RoomKey" => "1560357725"
"RoomType" => "Kitchen"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
10 => array:11 [
"RoomKey" => "1560357726"
"RoomType" => "Living room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "20'8'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29251089/100-watershore-drive-unit-19-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1986960"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55053"
+"GeocodeManualYN": true
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2841
+"OriginalEntryTimestamp": "2026-01-14T19:38:15.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404573772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/2bd6871eee548767ce3cb5fafb7b366f.webp"
"MediaSize" => 83613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-2bd6871eee548767ce3cb5fafb7b366f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404573776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/e8a7696e337da1eb4ce40ebd7f99c45a.webp"
"MediaSize" => 167406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-e8a7696e337da1eb4ce40ebd7f99c45a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404573778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/9cbbdf0d3af16e1f85ea6fd9a72e0cff.webp"
"MediaSize" => 172811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-9cbbdf0d3af16e1f85ea6fd9a72e0cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404573781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/07251fc8783b3ef0197b92e10af6edbf.webp"
"MediaSize" => 128225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-07251fc8783b3ef0197b92e10af6edbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404573788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/5469ca2078454c5e5f424f36d3958c25.webp"
"MediaSize" => 137645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-5469ca2078454c5e5f424f36d3958c25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404573792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/b84932083c291312022e39320429c199.webp"
"MediaSize" => 79951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-b84932083c291312022e39320429c199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404573796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/14409ce29620198cf31d87bc62d6e496.webp"
"MediaSize" => 85549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-14409ce29620198cf31d87bc62d6e496.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404573801"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/85759c11eb4cdfbfa123570316b24e30.webp"
"MediaSize" => 98054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-85759c11eb4cdfbfa123570316b24e30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404573805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/21d59776cdab194d5f1c5af373f0aace.webp"
"MediaSize" => 74902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-21d59776cdab194d5f1c5af373f0aace.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404573810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/09aa05aff7cc975c8262cc4b7342b399.webp"
"MediaSize" => 161765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-09aa05aff7cc975c8262cc4b7342b399.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404573814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/073a8f63ad996b203834a6ee9073ebfa.webp"
"MediaSize" => 49718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-073a8f63ad996b203834a6ee9073ebfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404573819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/7d2c7f43641578cf40a04d6748223aae.webp"
"MediaSize" => 56281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-7d2c7f43641578cf40a04d6748223aae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Deanna Bodden"
"MemberFirstName" => "Deanna"
"MemberLastName" => "Bodden"
"MemberMlsId" => "HBBODDEDE"
"OriginatingSystemName" => 26
"MemberKey" => "2025165"
"ModificationTimestamp" => "2025-10-28T23:23:51Z"
"MemberStatus" => "Active"
"OfficeKey" => "288925"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Ancaster"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-648-4451"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-01-20T15:23:00Z"
"MemberNationalAssociationId" => "1304829"
"OfficeNationalAssociationId" => "1372539"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-648-4451"
"OfficeMlsId" => "HBRLPSTATEA2"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288925"
"ModificationTimestamp" => "2025-12-30T03:00:56Z"
"OfficeAddress1" => "1122 Wilson Street W Suite 200"
"OfficeCity" => "Ancaster"
"OfficePostalCode" => "L9G3K"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2020-11-03T19:13:00Z"
"OfficeNationalAssociationId" => "1372539"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1063185"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251089')"
+"ID": "535552"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288925&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-648-4451"
+"OfficeMlsId": "HBRLPSTATEA2"
+"ModificationTimestamp": "2025-12-30T03:00:56Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288925"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1122 Wilson Street W Suite 200"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Ancaster"
+"OfficePostalCode": "L9G3K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1372539"
+"OriginalEntryTimestamp": "2020-11-03T19:13:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439678"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "288925"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-12-29T19:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1063185"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('288925')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2025165/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2025165&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2025165/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2025165&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25280
+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 29251089" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24920
+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 29251089/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251089&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251089/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29251089&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24902
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.675003 43.229989)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.675003 43.229989)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.675003 43.229989)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29251089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.675003 43.229989)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24816
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24857
+post_id: "535505"
+post_author: 1
+"ListingKey": "29252813"
+"ListingId": "X12697634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T00:20:31Z"
+"RFModificationTimestamp": "2026-01-15T00:42:05Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0G1"
+"UnparsedAddress": "20 - 45 SEABREEZE CRESCENT, Hamilton (Stoney Creek), Ontario L8E0G1"
+"Coordinates": array:2 [
0 => -79.66767
1 => 43.225385
]
+"Latitude": 43.225385
+"Longitude": -79.66767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 3 Bedrooms, 3 washrooms home steps to the lake, very convenient family neighbourhood, close to shopping, schools, parks and highways, spacious bedrooms with lake view flawless laid our main floor with a fireplace and breakfast and dining areas, open to above foyer, spacious partly finished basement. Great scenery of Lake Ontario you will love going for a walk. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "200"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Partially finished"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:41:56.201348+00:00"
+"Directions": "Mcneilly/North Service"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972788"
+"ListOfficeKey": "300374"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "23.1 x 83.1 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T00:13:51Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T00:13:51Z"
+"Stories": "2.0"
+"StreetName": "Seabreeze"
+"StreetNumber": "45"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4800"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1560467490"
"RoomType" => "Great room"
"ListingId" => "X12697634"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29252813"
"RoomLength" => 6.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
1 => array:11 [
"RoomKey" => "1560467491"
"RoomType" => "Kitchen"
"ListingId" => "X12697634"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29252813"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
2 => array:11 [
"RoomKey" => "1560467492"
"RoomType" => "Foyer"
"ListingId" => "X12697634"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29252813"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
3 => array:11 [
"RoomKey" => "1560467493"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12697634"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29252813"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
4 => array:11 [
"RoomKey" => "1560467494"
"RoomType" => "Bedroom 2"
"ListingId" => "X12697634"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29252813"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
5 => array:11 [
"RoomKey" => "1560467495"
"RoomType" => "Bedroom 3"
"ListingId" => "X12697634"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29252813"
"RoomLength" => 4.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
6 => array:11 [
"RoomKey" => "1560467496"
"RoomType" => "Laundry room"
"ListingId" => "X12697634"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252813"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
7 => array:11 [
"RoomKey" => "1560467497"
"RoomType" => "Utility room"
"ListingId" => "X12697634"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252813"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252813/20-45-seabreeze-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 23.1
+"OriginalEntryTimestamp": "2026-01-15T00:13:51.05Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404962780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/3ed74f6bc421e114d3b623ac732a489b.webp"
"MediaSize" => 383809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-3ed74f6bc421e114d3b623ac732a489b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404962793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/74b4d1243cf9bd4ec638801e97c4670b.webp"
"MediaSize" => 231555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-74b4d1243cf9bd4ec638801e97c4670b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404962804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/3060391c1a6913f347a1e349f2b900db.webp"
"MediaSize" => 130102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-3060391c1a6913f347a1e349f2b900db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404962816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/4feb0efcf5f8f8cb96709903dfe8c030.webp"
"MediaSize" => 251815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-4feb0efcf5f8f8cb96709903dfe8c030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404962828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/8a4f67f44c9eed2538b0b0bfda3498f2.webp"
"MediaSize" => 248190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-8a4f67f44c9eed2538b0b0bfda3498f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404962854"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/638b285cec74c68b6e4f6df57eaff4e7.webp"
"MediaSize" => 233179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-638b285cec74c68b6e4f6df57eaff4e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404962868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/dc9db09cd9b580ff5363c0c1748558f7.webp"
"MediaSize" => 240982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-dc9db09cd9b580ff5363c0c1748558f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404962882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/1269421b18640bff06843e1648603cd7.webp"
"MediaSize" => 237064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-1269421b18640bff06843e1648603cd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404962897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/fdf3bc6e909123fab99b553660e225a2.webp"
"MediaSize" => 388975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-fdf3bc6e909123fab99b553660e225a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404962912"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/364a055d8e3ea2ed4e34856899fddd6c.webp"
"MediaSize" => 301566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-364a055d8e3ea2ed4e34856899fddd6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404962923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/bf4645dc589ac38eed852ca093004ecc.webp"
"MediaSize" => 263424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-bf4645dc589ac38eed852ca093004ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404962941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/ac99c714108b773690eefa66fb083df9.webp"
"MediaSize" => 358318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-ac99c714108b773690eefa66fb083df9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "SAM GHOBRIAL"
"MemberFirstName" => "SAM"
"MemberLastName" => "GHOBRIAL"
"MemberMlsId" => "9558507"
"OriginatingSystemName" => 26
"MemberKey" => "1972788"
"ModificationTimestamp" => "2025-12-15T06:02:37Z"
"MemberStatus" => "Active"
"OfficeKey" => "300374"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "416-918-0048"
"MemberSocialMedia" => array:1 [ …1]
"MemberTollFreePhone" => "416-918-0048"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2014-04-09T00:28:00Z"
"MemberNationalAssociationId" => "1259832"
"OfficeNationalAssociationId" => "1487162"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "iCloud Realty Ltd."
"OfficePhone" => "905-507-4776"
"OfficeMlsId" => "20015510"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "300374"
"ModificationTimestamp" => "2025-11-14T00:54:17Z"
"OfficeAddress1" => "30 Eglinton Ave West Unit C12"
"OfficeCity" => "Mississauga"
"OfficePostalCode" => "L5R3E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-507-4779"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2025-08-18T19:14:00Z"
"OfficeNationalAssociationId" => "1487162"
"OfficeBrokerNationalAssociationId" => "1125533"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252813')"
+"ID": "535505"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24751
+post_id: "534950"
+post_author: 1
+"ListingKey": "29251667"
+"ListingId": "X12696554"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:56:05Z"
+"RFModificationTimestamp": "2026-01-14T23:21:02Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "19 - 100 WATERSHORE DRIVE, Hamilton (Stoney Creek), Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.678046
1 => 43.231402
]
+"Latitude": 43.231402
+"Longitude": -79.678046
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity- an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island- ideal for both casual meals and upscale entertaining. As a purchaser, you'll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home's living and dining areas, centered around a 46" gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer- a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T23:20:40.192642+00:00"
+"Directions": "Cross Streets: Watershore & Aquamarine. ** Directions: Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234697"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "In suite Laundry"
2 => "Sump Pump"
]
+"LotSizeDimensions": "."
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T20:47:44Z"
+"PhotosCount": 12
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:47:44Z"
+"Stories": "1.0"
+"StreetName": "Watershore"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"View": "Lake view,View of water,Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1560390237"
"RoomType" => "Living room"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 6.1
"ListingKey" => "29251667"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.83Z"
]
1 => array:11 [
"RoomKey" => "1560390238"
"RoomType" => "Kitchen"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 4.27
"ListingKey" => "29251667"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.83Z"
]
2 => array:11 [
"RoomKey" => "1560390239"
"RoomType" => "Dining room"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.79
"ListingKey" => "29251667"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.84Z"
]
3 => array:11 [
"RoomKey" => "1560390240"
"RoomType" => "Den"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29251667"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.84Z"
]
4 => array:11 [
"RoomKey" => "1560390241"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.49
"ListingKey" => "29251667"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.85Z"
]
5 => array:11 [
"RoomKey" => "1560390242"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29251667"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.85Z"
]
6 => array:11 [
"RoomKey" => "1560390243"
"RoomType" => "Bedroom 3"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29251667"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.86Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251667/19-100-watershore-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2999
+"LivingAreaMinimum": 2750
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-01-14T20:47:44.78Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404691322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/647ead6954a5f0111ca2417157bbd68f.webp"
"MediaSize" => 86387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-647ead6954a5f0111ca2417157bbd68f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404691336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/5ae9382d75761bee2fe8fecd8c66b64e.webp"
"MediaSize" => 169374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-5ae9382d75761bee2fe8fecd8c66b64e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404691379"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/a1852f8ef52cabdd7a5a6d558dc2ab17.webp"
"MediaSize" => 174724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-a1852f8ef52cabdd7a5a6d558dc2ab17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404691409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/a80b2ec3da82ee7c84cc8ed6d4848959.webp"
"MediaSize" => 129692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-a80b2ec3da82ee7c84cc8ed6d4848959.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404691445"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/27008c2bc58079a3c9519161a148b4b0.webp"
"MediaSize" => 139024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-27008c2bc58079a3c9519161a148b4b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404691486"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/82d7fc712ad8bfde984108b3b1028eed.webp"
"MediaSize" => 82992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-82d7fc712ad8bfde984108b3b1028eed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404691489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/9f8c4ca667afdf9c40aff4dabeb31d14.webp"
"MediaSize" => 89698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-9f8c4ca667afdf9c40aff4dabeb31d14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404691501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/68184a55220eaece59d5e48f99f9c7f7.webp"
"MediaSize" => 102031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-68184a55220eaece59d5e48f99f9c7f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404691525"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/26aae1ec2f98dcaf8f376c1fe8593265.webp"
"MediaSize" => 76506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-26aae1ec2f98dcaf8f376c1fe8593265.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404691575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/4313ffa024bb12af3759b6427ac754d6.webp"
"MediaSize" => 163372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-4313ffa024bb12af3759b6427ac754d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404691599"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/15154dd2eac6571e66c5628d8961318a.webp"
"MediaSize" => 54407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-15154dd2eac6571e66c5628d8961318a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404691639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/8c7a8bac277feeb5d4025bde4e71071b.webp"
"MediaSize" => 58911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-8c7a8bac277feeb5d4025bde4e71071b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
]
+"Member": array:1 [
0 => array:4 [
"MemberMlsId" => "2234697"
"OriginatingSystemName" => 26
"MemberKey" => "2234697"
"ModificationTimestamp" => "2024-12-14T15:51:44Z"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "ROYAL LEPAGE STATE REALTY"
"OfficePhone" => "905-648-4451"
"OfficeMlsId" => "288001"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288936"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "1122 WILSON ST WEST #200"
"OfficeCity" => "ANCASTER"
"OfficePostalCode" => "L9G3K9"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-648-7393"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2020-11-05T23:29:00Z"
"OfficeNationalAssociationId" => "1374261"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1312646"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251667')"
+"ID": "534950"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24858
+post_id: "533893"
+post_author: 1
+"ListingKey": "29249920"
+"ListingId": "X12694942"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:05:38Z"
+"RFModificationTimestamp": "2026-01-14T19:42:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "306 - 600 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This sophisticated 1-bedroom residence is situated on the third floor of a nearly new boutique condominium. A rare opportunity, it includes an owned parking space and a secure storage locker for exceptional convenience. Inside, you'll find soaring ceilings, abundant natural light, upgraded designer lighting, and a thoughtfully crafted open-concept layout tailored for contemporary living. The inviting entryway offers a full-sized closet for coats and additional storage. The bright, well-appointed kitchen features ample counter space, stainless steel appliances, and a generous peninsula ideal for meal preparation or casual dining. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:42:23.816818+00:00"
+"Directions": "FRUITLAND RD & NORTH SERVICE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127500"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:56:17Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:56:17Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1560286548"
"RoomType" => "Kitchen"
"ListingId" => "X12694942"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "29249920"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:56:17.1Z"
]
1 => array:11 [
"RoomKey" => "1560286549"
"RoomType" => "Living room"
"ListingId" => "X12694942"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29249920"
"RoomLength" => 5.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:56:17.1Z"
]
2 => array:11 [
"RoomKey" => "1560286550"
"RoomType" => "Bedroom"
"ListingId" => "X12694942"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29249920"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:56:17.1Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249920/306-600-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Ltd"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T16:56:17.07Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:21 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404327877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/2983606153a2e792dd175d52b348540e.webp"
"MediaSize" => 54602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-2983606153a2e792dd175d52b348540e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404327931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/d96605c14562d2d711643051fb3feb1a.webp"
"MediaSize" => 246633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-d96605c14562d2d711643051fb3feb1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404328057"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/3f1aa75a285522632c7c4800e48e9026.webp"
"MediaSize" => 108042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-3f1aa75a285522632c7c4800e48e9026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404328067"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/4f5348dc9164eefa46bdaac22ac0d16a.webp"
"MediaSize" => 58395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-4f5348dc9164eefa46bdaac22ac0d16a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404328076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/04f4a04d8f04c138645d46fbaa82701e.webp"
"MediaSize" => 35283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-04f4a04d8f04c138645d46fbaa82701e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404328116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/c52f6153e78c57acb483c6d883dfede0.webp"
"MediaSize" => 35961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-c52f6153e78c57acb483c6d883dfede0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404328160"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/2d47164d5d4dc95b6ea2e2c45999e8fa.webp"
"MediaSize" => 40265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-2d47164d5d4dc95b6ea2e2c45999e8fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404328187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/9f18957a66914bc8cb124f1bf3a1f0c5.webp"
"MediaSize" => 39778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-9f18957a66914bc8cb124f1bf3a1f0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404328226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/35b4daa0c29c284a2520af277381d0a6.webp"
"MediaSize" => 97338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-35b4daa0c29c284a2520af277381d0a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404328316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/5b88b45a90b983ffe8e0668f8f0c7078.webp"
"MediaSize" => 222471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-5b88b45a90b983ffe8e0668f8f0c7078.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404328336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/c0a402fcfdb630820b34e30ff4d8c254.webp"
"MediaSize" => 87975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-c0a402fcfdb630820b34e30ff4d8c254.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404328400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/3fa7e8b99d1a6edf78d1087095572f3c.webp"
"MediaSize" => 82892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-3fa7e8b99d1a6edf78d1087095572f3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404328435"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/bf11ee8d4352b360a1e0b368dfad6b7e.webp"
"MediaSize" => 108847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-bf11ee8d4352b360a1e0b368dfad6b7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404328482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/8d755c2e586e9589efe73c7f7824c933.webp"
"MediaSize" => 52644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-8d755c2e586e9589efe73c7f7824c933.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
"ResourceRecordKey" => "29249920"
"ModificationTimestamp" => "2026-01-14T16:56:17.07Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404328512"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249920/eb6981af0fe7b09b3078d721726a1810.webp"
"MediaSize" => 46937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249920/thumbnail-eb6981af0fe7b09b3078d721726a1810.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694942"
…2
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249920')"
+"ID": "533893"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+post_id: "533995"
+post_author: 1
+"ListingKey": "29250319"
+"ListingId": "40798505"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:55:10Z"
+"RFModificationTimestamp": "2026-01-14T18:50:38Z"
+"ListPrice": 599995.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1355.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5H6"
+"UnparsedAddress": "288 GLOVER Road Unit# 21, Stoney Creek, Ontario L8E5H6"
+"Coordinates": array:2 [
0 => -79.6800639
1 => 43.2161908
]
+"Latitude": 43.2161908
+"Longitude": -79.6800639
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning Branthaven-Built 3-Storey Townhome in Sought-After Winona/Fruitland Neighbourhood. 10 mins to the New Go Train Station Opening at the end of October! Welcome to this beautifully upgraded townhome located in one of Hamilton’s fastest-growing communities. Ideally situated just minutes from the QEW and Red Hill Valley Parkway, you'll enjoy easy access to everything you need—including trendy new restaurants, shopping, Costco, and more. This home features a bright and airy open-concept layout, complete with wide plank vinyl flooring and stylish upgraded lighting throughout. The gourmet kitchen boasts sleek white cabinetry, stainless steel appliances, granite countertops, and a modern tile backsplash. The main floor also includes a spacious family room with a charming shiplap feature wall, separate dining area, and access to a private balcony—perfect for entertaining or relaxing. The powder room has been tastefully updated with new tile flooring and contemporary fixtures. Upstairs, you’ll find two generously sized bedrooms, a convenient laundry closet, and a spacious 4-piece bathroom with a relaxing soaker tub. The primary bedroom features a walk-in closet and its own private balcony. Lovingly maintained, this exceptional home is built by award-winning Branthaven and offers quality craftsmanship, thoughtful upgrades, and a truly move-in-ready experience. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "183.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T18:50:12.547536+00:00"
+"Directions": "South of QEW on Fruitland Rd. 4km/turn east on Barton St. 4km/turn left - Glover Rd."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T17:51:30Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T17:51:30Z"
+"Stories": "3.0"
+"StreetName": "GLOVER"
+"StreetNumber": "288"
+"StreetSuffix": "Road"
+"SubdivisionName": "518 - Fruitland"
+"TaxAnnualAmount": "4150.79"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29250319/288-glover-road-unit-21-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-59b, RM3-59c, RM3-59a"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1355
+"OriginalEntryTimestamp": "2026-01-14T17:49:31.48Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250319')"
+"ID": "533995"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "533463"
+post_author: 1
+"ListingKey": "29249089"
+"ListingId": "40798135"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T14:55:25Z"
+"RFModificationTimestamp": "2026-01-14T17:25:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 653.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 419, Hamilton, Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697041
1 => 43.234195
]
+"Latitude": 43.234195
+"Longitude": -79.697041
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience the epitome of modern coastal living in the newly completed and vibrant CoMo Condos. This beautifully designed 1-bedroom, 1-washroom unit has stunning waterfront views that create a calming ambiance throughout. The spacious layout features a sleek kitchen with a breakfast bar, an enclosed balcony ideal for relaxation, and a generously sized washroom. For added convenience, the unit includes one parking space and one locker. CoMo Condos also has an exceptional amenities such as a pet spa, an off-leash pet area, a media and gaming room, a party room, automated package pick-up, and a rooftop patio perfect for entertaining or unwinding. Ideally located with easy access to highways, schools, shopping, and dining, this home is perfect for those seeking style, comfort, and convenience. Don’t miss your chance to enjoy breathtaking waterfront living every day. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T17:24:56.938712+00:00"
+"Directions": "Lakeview and Fruitland"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-14T14:49:02Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T14:49:02Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29249089/600-north-service-road-unit-419-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RM3-64, C5"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 653
+"OriginalEntryTimestamp": "2026-01-14T14:49:02.17Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:40 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249089')"
+"ID": "533463"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24861
+post_id: "532460"
+post_author: 1
+"ListingKey": "29247190"
+"ListingId": "40798194"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:25:19Z"
+"RFModificationTimestamp": "2026-01-13T23:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 806.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 309, Stoney Creek, Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697019
1 => 43.234159
]
+"Latitude": 43.234159
+"Longitude": -79.697019
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:03:24.375923+00:00"
+"Directions": "Fruitland Rd and North Service Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524358"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-13T21:21:08Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:21:08Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4135"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247190/600-north-service-road-unit-309-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2495
+"ZoningDescription": "C5, RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 806
+"OriginalEntryTimestamp": "2026-01-13T21:18:57.99Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247190')"
+"ID": "532460"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "531722"
+post_author: 1
+"ListingKey": "29247455"
+"ListingId": "X12693050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T22:20:50Z"
+"RFModificationTimestamp": "2026-01-13T22:32:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "309 - 600 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:31:50.312880+00:00"
+"Directions": "Cross Streets: Fruitland Road. ** Directions: Fruitland Rd and North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163724"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T22:11:25Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T22:11:25Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247455/309-600-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2495
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-13T22:11:25.42Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247455')"
+"ID": "531722"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24793
+post_id: "526532"
+post_author: 1
+"ListingKey": "29238762"
+"ListingId": "X12685118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T22:51:00Z"
+"RFModificationTimestamp": "2026-01-12T00:49:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "132 - 590 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697415
1 => 43.234285
]
+"Latitude": 43.234285
+"Longitude": -79.697415
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Move into this freshly painted, upgraded townhome offering a bright and functional layout with spacious rooms. Located near the QEW, 5 minutes from Mohawk College (Stoney Creek Campus) and 20 minutes to McMaster University. New smoke alarms installed. Tenant responsible for utilities. Landlord covers furnace and A/C rental (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T00:49:09.569190+00:00"
+"Directions": "N Service Rd / Fruitland"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2012594"
+"ListOfficeKey": "293891"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T22:40:56Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T22:40:56Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238762/132-590-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2350
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-11T22:40:56.15Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:18 [ …18]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238762')"
+"ID": "526532"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24809
+post_id: "523151"
+post_author: 1
+"ListingKey": "29235240"
+"ListingId": "X12681882"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T14:41:05Z"
+"RFModificationTimestamp": "2026-01-13T14:46:51Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5C2"
+"UnparsedAddress": "39 SUNROW GATE, Hamilton (Lakeshore), Ontario L8E5C2"
+"Coordinates": array:2 [
0 => -79.6835545
1 => 43.2333366
]
+"Latitude": 43.2333366
+"Longitude": -79.6835545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Executive detached home offering over 3,600 sq. ft. of refined above grade living space, ideally positioned just steps from the shores of Lake Ontario. From the moment you arrive, this home impresses with it's grand foyer featuring elegant tiled flooring, double front-entry closets and a main floor office framed by custom glass doors and panoramic windows. The main level is thoughtfully designed for both upscale entertaining and everyday living, anchored by a dramatic living room with soaring cathedral ceilings, gas fireplace and hardwood flooring throughout. An oversized formal dining area seamlessly flows through to the custom kitchen showcasing sleek lacquer cabinetry, an abundance of pot lighting, quartz countertops, tiled flooring, built-in wall oven, gas range and a commercial style refrigerator and freezer. Luxury continues throughout with built-in surround sound on every level, including the garage. The main floor is completed by a spacious walk-in pantry, stylish two-piece powder room and a main floor laundry room. An open riser staircase leads to the second level, where a sun filled family room overlooks the main living space and opens to a balcony that enhances the home's open and airy architectural design. The primary retreat offers space not only for rest but relaxation with room for a private sitting area, a spa-inspired five-piece ensuite, custom walk-in closet and full surround sound system. Three additional generously sized bedrooms include one with a private four piece ensuite, while the remaining two are serviced by a beautifully finished shared 4 piece bath. The backyard is a great size to be able to enjoy the outdoor space but small enough where is won't consume lots of upkeep. Ideally located with quick access to the QEW, parks, schools, waterfront trails and the Fifty Point Yacht Club. This distinguished residence delivers an exceptional blend of luxury, lifestyle and convenience in one of Stoney Creek's most sought after neighbourhoods. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-01-09T21:11:52.765066+00:00"
+"Directions": "Cross Streets: North Service Rd. ** Directions: North Service Rd to Jones Rd to Sunrow Gate."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032323"
+"ListOfficeKey": "283968"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "47.5 x 90.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:26:32Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T14:26:49Z"
+"Stories": "2.0"
+"StreetName": "Sunrow"
+"StreetNumber": "39"
+"StreetSuffix": "Gate"
+"TaxAnnualAmount": "12859"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/VHlSvyl5qR4"
+"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": "Niagara"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29235240/39-sunrow-gate-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "R2-62"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 47.6
+"OriginalEntryTimestamp": "2026-01-09T20:26:32.22Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235240')"
+"ID": "523151"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 63
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]