array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1320&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1320&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1320&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=1320&$filter=(StandardStatus eq 'Active') and City eq 'Hamilton'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2862
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2855
+post_id: "546102"
+post_author: 1
+"ListingKey": "X12654986"
+"ListingId": "X12654986"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-01T20:01:25Z"
+"RFModificationTimestamp": "2026-02-05T20:59:59Z"
+"ListPrice": 1259900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H 6X3"
+"UnparsedAddress": "550 Beach Boulevard, Hamilton, ON L8H 6X3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2776026
+"Longitude": -79.7827257
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beachside Living at its Best! Custom Built in 2011 & Beautifully Maintained! Bright & Airy 2 Storey Home Nestled in the Sought After Hamilton Beach Community. Soaring 10 Foot Ceilings, Open Concept Kitchen with Spacious Great Room & Dining Area - Perfect for Family Gatherings. Main Floor Den & 2 Piece Powder Room. Maple Hardwood Floors Flow Throughout Main & Second Floor. Double Door Primary Bedroom with 5 Piece Ensuite with Whirlpool Tub, Separate Shower, Granite Counter & Double Vanity. Convenient Bedroom Level Laundry. Stunning Upper Level Family Room with Vaulted Ceiling & Rough in for Wet Bar, Open to Private Balcony with Seasonal Views of Lake Ontario. 3 Car Length Garage with 2 Overhead Doors, 2 Man Doors & Inside Entry to Both the Foyer & Kitchen. Central Air 2017. Gas Furnace 2015. Owned Tankless Hot Water Heater Installed 2020. Central Vacuum. 200 AMP Breakers. Gas BBQ Hook Up. Walk, Ride & Skate the Waterfront Trail Just Steps from Your Front Door. Minutes to Parks, Lake Ontario & Easy Access to QEW/Redhill! Room Sizes Approximate & Irregular. Exterior: Board & Batten, Brick, Stucco (Plaster)"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"CityRegion": "Hamilton Beach"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "3.0"
+"CreationDate": "2026-02-05T18:27:20.513660+00:00"
+"CrossStreet": "Beach Blvd/Arden Ave"
+"DirectionFaces": "West"
+"Directions": "EXIT QEW AT EITHER EASTPORT DRIVE OR WOODWARD AVENUE, FOLLOW TO BEACH BLVD"
+"ExpirationDate": "2026-07-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, stove, built in microwave, washer, dryer"
+"InteriorFeatures": "Auto Garage Door Remote,Central Vacuum,Sump Pump,Water Heater Owned,Water Meter,Workbench"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-01"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "184000"
+"MajorChangeTimestamp": "2026-01-01T20:01:25Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-01-01T20:01:25Z"
+"OriginalListPrice": 1259900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3388372"
+"ParcelNumber": "175700061"
+"ParkingFeatures": "Private,Inside Entry"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-01-01T20:01:25Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beach"
+"StreetNumber": "550"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "7695.28"
+"TaxLegalDescription": "LT 1 PL 487 ; S/T INTEREST IN VM263845; CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% PLUS HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://www.myvisuallistings.com/cvt/356884"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/356884"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotShape": "Rectangular"
+"LotWidth": 40.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12654986')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "251805051104180"
+"SurveyType": "None"
+"ElectricYNA": "Yes"
+"RentalItems": "None"
+"HoldoverDays": 120
+"LaundryLevel": "Upper Level"
+"TelephoneYNA": "Available"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8H 6X3, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 7
+"PropertyFeatures": array:3 [ …3]
+"PossessionDetails": "1 - 29 Days"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Call 905-297-7777 or book through Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-01-01T20:01:25Z"
+"SystemModificationTimestamp": "2026-01-01T20:01:26.192572Z"
+"Media": array:45 [ …45]
+"ID": "546102"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "368795"
+post_author: 1
+"ListingKey": "X12268284"
+"ListingId": "X12268284"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-31T16:21:21Z"
+"RFModificationTimestamp": "2026-02-05T20:58:26Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R 1C0"
+"UnparsedAddress": "2311 Highway 56 N/a, Hamilton, ON L0R 1C0"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2560802
+"Longitude": -79.8728583
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Attention Builders, Developers, Investors & Dream-Home Seekers! An incredible opportunity awaits w/ this rare 5.54-acre parcel in the heart of Binbrook, one of Ontarios fastest-growing communities. Surrounded by new residential & multi-purpose developments, this prime piece of real estate offers endless potential. 4 bdrm, 2 bath bungalow w/ walkout basement currently on the property, opportunity to rent or live in while planning your next move. Includes massive 30' x 60' detached workshop/garage w/ 14ft ceilings & concrete floors, horse barns, ample parking & 2 driveways. With flat topography & generous frontage, the land offers a versatile canvas for future residential or multi-use development proposals. Close proximity to all amenities makes it a convenient & strategic investment. Rare & valuable opportunity to invest in a region experiencing rapid growth. Continued development & infrastructure plans underway in the surrounding area, this parcel is poised for strong appreciation."
+"ArchitecturalStyle": "Bungalow"
+"CityRegion": "Rural Glanbrook"
+"ConstructionMaterials": array:1 [ …1]
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "10.0"
+"CreationDate": "2026-01-21T22:41:53.964592+00:00"
+"CrossStreet": "Guyatt Rd"
+"DirectionFaces": "East"
+"Directions": "Guyatt Rd"
+"ExpirationDate": "2026-06-30"
+"GarageYN": true
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-07-07"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "269900"
+"MajorChangeTimestamp": "2025-12-31T16:21:21Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-07-07T18:44:06Z"
+"OriginalListPrice": 2999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2674742"
+"OtherStructures": array:3 [ …3]
+"ParcelNumber": "173840073"
+"ParkingFeatures": "Private,RV/Truck"
+"ParkingTotal": "28.0"
+"PhotosChangeTimestamp": "2025-07-07T18:44:06Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 2999000.0
+"PriceChangeTimestamp": "2025-12-31T16:21:21Z"
+"Sewer": "Septic"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Highway 56"
+"StreetNumber": "2311"
+"StreetSuffix": "N/A"
+"TaxAnnualAmount": "5967.82"
+"TaxLegalDescription": "PT LT 5, BLK 3, CON 3 BINBROOK , AS IN VM62390 ; GLANBROOK CITY OF HAMILTON"
+"TaxYear": "2025"
+"Topography": array:2 [ …2]
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"View": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"Zoning": "A1"
+"DDFYN": true
+"Water": "Well"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 649.0
+"LotShape": "Rectangular"
+"LotWidth": 270.5
+"SewerYNA": "Available"
+"WaterYNA": "Available"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268284')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "251890131074400"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"ElectricYNA": "Yes"
+"HoldoverDays": 60
+"TelephoneYNA": "Available"
+"HeatTypeMulti": array:1 [ …1]
+"ParkingSpaces": 18
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L0R 1C0, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-08-29"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "5-9.99"
+"PossessionDetails": "Flexible"
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "905-592-7777"
+"MediaChangeTimestamp": "2025-07-07T18:44:06Z"
+"SystemModificationTimestamp": "2025-12-31T16:21:21.945255Z"
+"Media": array:40 [ …40]
+"ID": "368795"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "449824"
+post_author: 1
+"ListingKey": "X12381894"
+"ListingId": "X12381894"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-31T14:39:13Z"
+"RFModificationTimestamp": "2026-02-05T05:09:59Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C 6Y6"
+"UnparsedAddress": "39 Megna Court, Hamilton, ON L9C 6Y6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.220961
+"Longitude": -79.9192484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Large 4-bedroom home on the West Hamilton Mountain with a finished basement. Located near Ancaster between Upper Paradise and Golf Links. Same owner since 1980, well maintained and move-in ready. Attached garage with inside entry, paved driveway for 4 cars, and private fenced yard. Walking distance to parks and schools, with nearby shopping at Upper Paradise, Rymal Rd, and Meadowlands. Easy access to the Linc and Hwy 403. 1632 sq. ft., built in 1980. Updates include furnace, AC, and water heater (2020), shingles (2010), and 100 AMP breaker panel."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"CityRegion": "Gurnett"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-01-21T22:47:29.933057+00:00"
+"CrossStreet": "Greencedar Drive"
+"DirectionFaces": "North"
+"Directions": "Gurnett Drive - Greencedar Drive - Megna Court"
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": "Landscaped"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Microwave, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, All ELF'S and Fans"
+"InteriorFeatures": "Auto Garage Door Remote,Central Vacuum,Water Heater,Water Heater Owned,Water Meter"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-09-04"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "184000"
+"MajorChangeTimestamp": "2025-12-31T14:39:13Z"
+"MlsStatus": "Extension"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-09-04T19:12:21Z"
+"OriginalListPrice": 899000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2906644"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "169490134"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2025-09-04T19:12:22Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SoilType": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Megna"
+"StreetNumber": "39"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "5060.33"
+"TaxLegalDescription": "PCL 56-1, SEC M285 ; LT 56, PL M285 ; S/T PTS 103 & 104, 62R5412 IN FAVOUR OF LT 55, M285 FOR THE PURPOSE OF KEEPING AND MAINTAINING THE BUILDING UPON THE ADJACENT LANDS IN GOOD CONDITION AND REPAIR AND FOR EVERY SUCH PURPOSE SHALL HAVE ACCESS TO THAT SAID PART OF THE REAL PROPERTY AT ALL TIMES BY THEIR RESPECTIVE SERVANTS, **CON'T. See Schedule C**"
+"TaxYear": "2025"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "2.0%**"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://youtu.be/Yi Zdg HJnla4"
+"VirtualTourURLUnbranded2": "https://youtu.be/Yi Zdg HJnla4"
+"Zoning": "D/S-564"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotShape": "Rectangular"
+"LotWidth": 30.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12381894')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "251808106302236"
+"SurveyType": "None"
+"ElectricYNA": "Yes"
+"RentalItems": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Available"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L9C 6Y6, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 7
+"ParcelOfTiedLand": "No"
+"PropertyFeatures": array:6 [ …6]
+"LotIrregularities": "100.21 x 30.06 x 100.21 x 30.06 ft"
+"PossessionDetails": "1-29"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:1 [ …1]
+"ShowingAppointments": "905-592-7777/Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2025-09-04T19:12:22Z"
+"ExtensionEntryTimestamp": "2025-12-31T14:39:13Z"
+"SystemModificationTimestamp": "2025-12-31T14:39:19.988825Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:43 [ …43]
+"ID": "449824"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "534914"
+post_author: 1
+"ListingKey": "X12638076"
+"ListingId": "X12638076"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-29T21:48:40Z"
+"RFModificationTimestamp": "2026-02-12T15:02:16Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 2300.0
+"City": "Hamilton"
+"PostalCode": "L8N 1C1"
+"UnparsedAddress": "309 King Street E, Hamilton, ON L8N 1C1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2538682
+"Longitude": -79.8599933
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX PREMIER INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Two adjacent freestanding buildings at 309 & 311 King St E are for sale separately or as one. Notably, the City Council has given the green light to the LRT, with this property strategically situated along its route. There is potential for up to 6 floors of development, complemented by ample parking space at the rear. The zoning allows for a diverse array of uses, presenting a promising opportunity for developers and investors alike. The listing price reflects the price per building not both. Both buildings are optional to buy separately or together. Don't miss out on this incredible opportunity! This property is offered "As Is, Where Is"."
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CityRegion": "Beasley"
+"Cooling": "Partial"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-12T14:33:49.224053+00:00"
+"CrossStreet": "King St East / Wellington St S"
+"Directions": "King St East/Wellington St S"
+"ExpirationDate": "2026-05-31"
+"Inclusions": "As Is Where IS."
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-17"
+"MainOfficeKey": "043900"
+"MajorChangeTimestamp": "2025-12-17T14:07:19Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-12-17T14:07:19Z"
+"OriginalListPrice": 375000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3364954"
+"PhotosChangeTimestamp": "2025-12-17T14:07:20Z"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": "Sanitary"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "King"
+"StreetNumber": "309"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3250.0"
+"TaxLegalDescription": "PT LT 15 PL 38 AS IN VM65590, S/T & T/W INTEREST IN VM65590; CITY OF HAMILTON"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"Utilities": "Available"
+"Zoning": "D2"
+"Rail": "No"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "Annual"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 102.42
+"LotWidth": 34.16
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12638076')"
+"GarageType": "Outside/Surface"
+"RetailArea": 50.0
+"RollNumber": "251802018103790"
+"PropertyUse": "Multi-Use"
+"ElevatorType": "None"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8N 1C1, CA"
+"ContractStatus": "Available"
+"FreestandingYN": true
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "%"
+"PossessionDetails": "Flex"
+"OfficeApartmentArea": 50.0
+"MediaChangeTimestamp": "2025-12-29T21:48:40Z"
+"OfficeApartmentAreaUnit": "%"
+"SystemModificationTimestamp": "2025-12-29T21:48:40.062618Z"
+"Media": array:1 [ …1]
+"ID": "534914"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "554574"
+post_author: 1
+"ListingKey": "X12646812"
+"ListingId": "X12646812"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-22T20:01:51Z"
+"RFModificationTimestamp": "2026-02-27T03:09:01Z"
+"ListPrice": 739990.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C 4C3"
+"UnparsedAddress": "103 Briarwood Crescent, Hamilton, ON L9C 4C3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2355355
+"Longitude": -79.894888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "YOUR HOME SOLD GUARANTEED REALTY IMPERIUM"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this fantastic detached home located in a sought-after neighborhood on the West Mountain! This property features three plus one bedrooms, offering ample space for families and/or presenting an excellent opportunity for generating passive income. Previously used as a student rental with a projected rental income of $5,000 per month, this property represents a strong investment for your portfolio. You can choose to leave the property as is or take advantage of the significant potential to renovate it into a legal duplex or add additional bedrooms to the basement. Also perfect for first time home buyers, live in one unit and rent out the other to build wealth and increase affordability! Situated in a prime location, you'll find it near Buchanan Park, which offers lush green spaces ideal for outdoor activities. It's just a short distance from Mohawk College and various shopping amenities, making it particularly attractive for student rentals. Additionally, easy access to public transport ensures convenient commutes for all tenants. Don't miss this opportunity to invest in a property that combines excellent rental potential with a desirable location. Schedule a viewing today!"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [ …2]
+"CityRegion": "Buchanan"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-02-27T00:19:54.181501+00:00"
+"CrossStreet": "GARTH TO BENDAMERE AVE"
+"DirectionFaces": "East"
+"Directions": "GARTH TO BENDAMERE AVE"
+"ExpirationDate": "2026-05-31"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Carpet Free,Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Central Lakes Association of REALTORS"
+"ListingContractDate": "2025-12-22"
+"MainOfficeKey": "341800"
+"MajorChangeTimestamp": "2025-12-22T19:51:07Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-12-22T19:51:07Z"
+"OriginalListPrice": 739990.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3376618"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2025-12-22T19:51:07Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Briarwood"
+"StreetNumber": "103"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5238.0"
+"TaxLegalDescription": "LT 100, PL 1191 ; HAMILTON"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 110.29
+"LotWidth": 50.1
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12646812')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L9C 4C3, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 5
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-12-22T19:51:07Z"
+"SystemModificationTimestamp": "2025-12-22T20:01:57.491112Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:12 [ …12]
+"ID": "554574"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "539452"
+post_author: 1
+"ListingKey": "X12478891"
+"ListingId": "X12478891"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-22T19:35:48Z"
+"RFModificationTimestamp": "2026-03-15T04:27:04Z"
+"ListPrice": 2500.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 2328.0
+"City": "Hamilton"
+"PostalCode": "L8M 1K1"
+"UnparsedAddress": "663 Main Street E, Hamilton, ON L8M 1K1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2488
+"Longitude": -79.8435499
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This prime 2,300+ sq ft commercial retail space is located in the heart of Downtown Hamilton, offering exceptional visibility on a high-traffic street with strong daily footfall and drive by exposure. Positioned in a rapidly growing urban corridor surrounded by ongoing redevelopment, this property presents an outstanding opportunity for a business seeking a high-profile location with built-in credibility. Previously occupied by a successful business that was located here for over 30 years, the space carries a legacy of stability and community presence, making it ideal for retailers, showrooms, service-based operators, boutique brands, or professional users looking to establish themselves in a vibrant commercial setting. The property includes two dedicated parking spots, a rare advantage in the downtown core, and sits among a mix of established neighbourhood amenities, new developments, and an expanding residential base that continues to fuel demand for local services. With its historic past and modern growth potential, this location offers the perfect balance between character, convenience, and high exposure for a long-term business footprint in one of Hamilton's most active commercial areas."
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "St. Clair"
+"Cooling": "Yes"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-03-09T03:06:53.018889+00:00"
+"CrossStreet": "Main St E & Fairleigh"
+"Directions": "Main St E"
+"ExpirationDate": "2026-05-31"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-23"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2025-12-22T19:35:48Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-23T18:12:02Z"
+"OriginalListPrice": 2600.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3172532"
+"PhotosChangeTimestamp": "2025-10-23T18:12:02Z"
+"PreviousListPrice": 2600.0
+"PriceChangeTimestamp": "2025-12-22T19:35:48Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Main"
+"StreetNumber": "663"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8100.0"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "Half Month Rent"
+"TransactionType": "For Lease"
+"Utilities": "Available"
+"Zoning": "C2"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "Annual"
+"HeatType": "Electric Forced Air"
+"LotDepth": 80.0
+"LotWidth": 30.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12478891')"
+"GarageType": "None"
+"RetailArea": 2328.0
+"PropertyUse": "Retail"
+"RentalItems": "Hot water heater Tank"
+"HoldoverDays": 180
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "Month"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8M 1K1, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"RetailAreaCode": "Sq Ft"
+"MediaChangeTimestamp": "2025-10-23T18:12:02Z"
+"MaximumRentalMonthsTerm": 48
+"MinimumRentalTermMonths": 12
+"SystemModificationTimestamp": "2025-12-22T19:35:48.798862Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
+"ID": "539452"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "520166"
+post_author: 1
+"ListingKey": "X12496752"
+"ListingId": "X12496752"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T14:46:16Z"
+"RFModificationTimestamp": "2026-02-07T16:09:46Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E 0K3"
+"UnparsedAddress": "125 Shoreview Place 638, Hamilton, ON L8E 0K3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2390543
+"Longitude": -79.7197856
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CHASE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover modern lakeside living in this stunning 1-bedroom, 1-bathroom condo featuring expansive floor-to-ceiling windows and an oversized balcony perfect for relaxing or entertaining. The bright, open-concept layout is completely carpet-free with a sleek modern design throughout and includes in-suite laundry for added convenience. Enjoy premium building amenities including a party room, rooftop patio with stunning lakeside views, and a fully equipped exercise room. This unit comes with owned parking and a locker, plus plenty of visitor parking. Efficient geothermal heating and central air for year-round comfort. Don't miss this incredible opportunity to own a contemporary condo in a desirable lakeside location!"
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "467.35"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"CityRegion": "Lakeshore"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-02-07T13:39:25.467883+00:00"
+"CrossStreet": "Millen Rd to Shoreview Pl"
+"Directions": "Millen Rd to Shoreview Pl, Left on Shoreview, Last Entrance on Right"
+"Disclosures": array:1 [ …1]
+"ExpirationDate": "2026-05-29"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Range Hood/Microwave, Dishwasher, Washer, Dryer. Option to purchase furnished."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-31"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "248800"
+"MajorChangeTimestamp": "2025-10-31T17:47:53Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-31T17:47:53Z"
+"OriginalListPrice": 399999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3192512"
+"ParcelNumber": "185891333"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-31T19:06:23Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Shoreview"
+"StreetNumber": "125"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3051.6"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"UnitNumber": "638"
+"WaterBodyName": "Lake Ontario"
+"WaterfrontFeatures": "Beach Front"
+"WaterfrontYN": true
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12496752')"
+"Shoreline": array:1 [ …1]
+"WaterView": array:1 [ …1]
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Ground Source"
+"RollNumber": "251800304020219"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"BalconyType": "Open"
+"DockingType": array:1 [ …1]
+"RentalItems": "None"
+"HoldoverDays": 60
+"LegalStories": "6"
+"ParkingSpot1": "Underground Space #301"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"WaterBodyType": "Lake"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8E 0K3, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 589
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 4
+"AccessToProperty": array:1 [ …1]
+"AlternativePower": array:1 [ …1]
+"EnsuiteLaundryYN": true
+"SquareFootSource": "LBO Provided"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lockbox located at 101 Shoreview Pl - in Lobby"
+"WaterfrontAccessory": array:1 [ …1]
+"LegalApartmentNumber": "638"
+"MediaChangeTimestamp": "2025-10-31T19:06:23Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2025-12-17T14:46:16.611179Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:46 [ …46]
+"ID": "520166"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "532882"
+post_author: 1
+"ListingKey": "X12633560"
+"ListingId": "X12633560"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T15:15:34Z"
+"RFModificationTimestamp": "2026-02-28T01:18:16Z"
+"ListPrice": 1950.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 3100.0
+"City": "Hamilton"
+"PostalCode": "L8L 2V5"
+"UnparsedAddress": "18 Barton Street E, Hamilton, ON L8L 2V5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2637456
+"Longitude": -79.8651045
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE STATE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 18 Barton Street East - a beautifull main-floor commercial space at the high-traffic corner of James St. N. and Barton St. E. This turnkey unit is ideal for a salon, wellness clinic, RMT, chiropractor, nail bar, or other personal care business. Featuring approx. 800 sq.ft. of stunning interior space, in-suite laundry, and basement storage. The building blends historic charm with modern amenities. Located just steps from some of the city's trendiest shops and restaurants, this space offers maximum visibility in a vibrant, high-foot-traffic area."
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CityRegion": "Beasley"
+"CommunityFeatures": "Public Transit"
+"Cooling": "No"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-27T02:30:27.309554+00:00"
+"CrossStreet": "James St N. & Barton St. E."
+"Directions": "James St. N. East on Barton"
+"ExpirationDate": "2026-06-15"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-15"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "288000"
+"MajorChangeTimestamp": "2025-12-15T15:15:34Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-12-15T15:15:34Z"
+"OriginalListPrice": 1950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3350456"
+"ParcelNumber": "171610050"
+"PhotosChangeTimestamp": "2025-12-15T15:15:34Z"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": "Sanitary+Storm"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Barton"
+"StreetNumber": "18"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7743.59"
+"TaxLegalDescription": "PT LT 11-12 PL 181 AS IN HL23644, T/W INTEREST IN VM264501; CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "1/2 Month's Rent + HST"
+"TransactionType": "For Lease"
+"Utilities": "Yes"
+"Zoning": "H"
+"Rail": "No"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Lot"
+"TaxType": "Annual"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 90.0
+"LotShape": "Rectangular"
+"LotWidth": 18.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12633560')"
+"GarageType": "None"
+"RetailArea": 980.0
+"RollNumber": "251802015655430"
+"PropertyUse": "Multi-Use"
+"ElevatorType": "None"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "Net Lease"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8L 2V5, CA"
+"ContractStatus": "Available"
+"FreestandingYN": true
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"PossessionDetails": "Flexible"
+"MediaChangeTimestamp": "2025-12-15T15:15:34Z"
+"MaximumRentalMonthsTerm": 60
+"MinimumRentalTermMonths": 36
+"SystemModificationTimestamp": "2025-12-15T15:15:35.033136Z"
+"Media": array:27 [ …27]
+"ID": "532882"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "528308"
+post_author: 1
+"ListingKey": "X12614468"
+"ListingId": "X12614468"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T01:01:48Z"
+"RFModificationTimestamp": "2026-02-11T04:20:49Z"
+"ListPrice": 799999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L 4X8"
+"UnparsedAddress": "575 Mary Street, Hamilton, ON L8L 4X8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2722078
+"Longitude": -79.856884
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 575 Mary Street, a stunningly unique property steps from the water's edge in the north end of Hamilton, where a tight-knit family transformed a house into a home during the quiet of Covid lockdowns. Step inside this fully renovated gem, seamlessly blending modern comforts with warm, inviting spaces, all crafted by a talented Hamilton native and international artist. The artistic flair captivates, merging the natural light of the outdoors with glass, cement, and crisp whites throughout. At the heart of the home is a stunning kitchen featuring floor-to-ceiling cabinetry, a four-seater waterfall quartz island, and very likely the most interesting matching Italian porcelain flooring and backsplash combo you have ever seen. The front porch, drenched in light from two skylights, is perfect for sipping morning coffee while enjoying the sunrise. On the opposite side of the house, cozy evenings come alive by the newly installed wood-burning fireplace, which warms the all-season backyard patio designed for both entertaining and relaxing after a long day. This home also features an innovative and massive office space seamlessly integrated into the main bedroom, ideal for remote work or midnight inspiration. With HUE smart lights throughout, you can easily set the perfect mood for any occasion. In the last four years, recent upgrades include Neal installed roof coverings, a high-efficiency furnace, all new flooring, windows, all siding, main floor powder room, brand-new kitchen and laundry appliances. This means you can move in and enjoy modern living! With three spacious bedrooms plus an office, this home provides ample space for families, guests, or your creative pursuits. Plus, convenience is key with two included parking spaces and an upgraded fast-charging EV connection port already installed. Come fall in love with this art piece of a home. A space ready for some new dreamers and creative spirits!"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"CityRegion": "North End"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-07T17:44:49.493563+00:00"
+"CrossStreet": "Mary St. and Brock St."
+"DirectionFaces": "West"
+"Directions": "Burlington St. E. to Mary St."
+"Exclusions": "None."
+"ExpirationDate": "2026-06-05"
+"ExteriorFeatures": "Porch Enclosed,Porch"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Fridge, stove, dishwasher, washer, and dryer."
+"InteriorFeatures": "Water Heater,Other"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-09"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "248500"
+"MajorChangeTimestamp": "2025-12-10T01:01:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-12-10T01:01:48Z"
+"OriginalListPrice": 799999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3348180"
+"ParcelNumber": "171550215"
+"ParkingFeatures": "Front Yard Parking,Private Double"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-12-10T01:01:48Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Mary"
+"StreetNumber": "575"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3390.0"
+"TaxLegalDescription": "PT LT 44 OR 81 NATHANIEL HUGHSON SURVEY (UNREGISTERED) W/S MARY ST BTN BURLINGTON ST & BROCK ST AS IN CD481453; CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://iframe.videodelivery.net/e60499a5b6ac0e7fdab37cf01d2c3d51"
+"VirtualTourURLBranded2": "https://my.matterport.com/show/?m=ms84GXX4mg Z"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ms84GXX4mg Z"
+"VirtualTourURLUnbranded2": "https://iframe.videodelivery.net/6f86174062b86615fe67c0fe20d7a24e"
+"Zoning": "D"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 120.0
+"LotShape": "Rectangular"
+"LotWidth": 20.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12614468')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "251802016605960"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"Winterized": "Fully"
+"ElectricYNA": "Yes"
+"RentalItems": "Water heater."
+"HoldoverDays": 120
+"LaundryLevel": "Main Level"
+"TelephoneYNA": "Available"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8L 4X8, CA"
+"ApproximateAge": "100+"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-01-09"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"MortgageComment": "Seller to discharge mortgage."
+"RoomsAboveGrade": 8
+"ParcelOfTiedLand": "No"
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay/LBO. Please remove shoes, leave card, turn off lights, lock all doors."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2025-12-10T01:01:48Z"
+"SystemModificationTimestamp": "2025-12-10T01:01:48.667708Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "528308"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "527062"
+post_author: 1
+"ListingKey": "X12609296"
+"ListingId": "X12609296"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T21:23:02Z"
+"RFModificationTimestamp": "2026-02-27T04:54:53Z"
+"ListPrice": 23.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1555.0
+"City": "Hamilton"
+"PostalCode": "L8R 2L4"
+"UnparsedAddress": "297 James Street N, Hamilton, ON L8R 2L4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3382023
+"Longitude": -79.8903385
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "COLLIERS"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Your business belongs on James Street North - Hamilton's thriving arts and culture corridor. This 1,555 sq. ft. retail space offers prime frontaage, strong foot traffic, and proximity to the newly renovated TD Coliseum, just a short walk from the GO Station via the upcoming pedestrian pathway. Surrounded by independent restaurants, boutiques, and creative businesses, it's an ideal home for a boutique retailer, cafe or service-based concept ready to tap into the neighbourhood's energy. Make your mark where Hamilton comes to life."
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CityRegion": "Central"
+"Cooling": "Yes"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-27T04:07:05.260115+00:00"
+"CrossStreet": "James St N & Colbourne"
+"Directions": "James St N & Colbourne"
+"ExpirationDate": "2026-06-08"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-08"
+"MainOfficeKey": "336800"
+"MajorChangeTimestamp": "2025-12-08T15:06:50Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-12-08T15:06:50Z"
+"OriginalListPrice": 23.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3329670"
+"ParcelNumber": "171600191"
+"PhotosChangeTimestamp": "2025-12-08T15:06:50Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "James"
+"StreetNumber": "297"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10.03"
+"TaxLegalDescription": "PT LT 2 BLK 1 PL 127 AS IN VM78045 CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "3.5% 1st Year, 2% Thereafter"
+"TransactionType": "For Lease"
+"Utilities": "Available"
+"Zoning": "H"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 120.0
+"LotWidth": 26.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12609296')"
+"GarageType": "None"
+"RetailArea": 1555.0
+"RollNumber": "251802012656600"
+"PropertyUse": "Retail"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "Sq Ft Net"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8R 2L4, CA"
+"ContractStatus": "Available"
+"FreestandingYN": true
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"PossessionDetails": "Immediate"
+"MediaChangeTimestamp": "2025-12-08T15:06:50Z"
+"MaximumRentalMonthsTerm": 120
+"MinimumRentalTermMonths": 60
+"SystemModificationTimestamp": "2025-12-08T21:23:02.334431Z"
+"Media": array:7 [ …7]
+"ID": "527062"
}
]
+success: true
+page_size: 10
+page_count: 138
+count: 1373
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
"RF Cache Key: ae508295a9c25fed8e185a2d375cfa92c1e6f2c71dc7e158fb19eeb30a10544c" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3076
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4271
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12654986"
+"ListingId": "X12654986"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-01T20:01:25Z"
+"RFModificationTimestamp": "2026-02-05T20:59:59Z"
+"ListPrice": 1259900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H 6X3"
+"UnparsedAddress": "550 Beach Boulevard, Hamilton, ON L8H 6X3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2776026
+"Longitude": -79.7827257
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beachside Living at its Best! Custom Built in 2011 & Beautifully Maintained! Bright & Airy 2 Storey Home Nestled in the Sought After Hamilton Beach Community. Soaring 10 Foot Ceilings, Open Concept Kitchen with Spacious Great Room & Dining Area - Perfect for Family Gatherings. Main Floor Den & 2 Piece Powder Room. Maple Hardwood Floors Flow Throughout Main & Second Floor. Double Door Primary Bedroom with 5 Piece Ensuite with Whirlpool Tub, Separate Shower, Granite Counter & Double Vanity. Convenient Bedroom Level Laundry. Stunning Upper Level Family Room with Vaulted Ceiling & Rough in for Wet Bar, Open to Private Balcony with Seasonal Views of Lake Ontario. 3 Car Length Garage with 2 Overhead Doors, 2 Man Doors & Inside Entry to Both the Foyer & Kitchen. Central Air 2017. Gas Furnace 2015. Owned Tankless Hot Water Heater Installed 2020. Central Vacuum. 200 AMP Breakers. Gas BBQ Hook Up. Walk, Ride & Skate the Waterfront Trail Just Steps from Your Front Door. Minutes to Parks, Lake Ontario & Easy Access to QEW/Redhill! Room Sizes Approximate & Irregular. Exterior: Board & Batten, Brick, Stucco (Plaster)"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CityRegion": "Hamilton Beach"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "3.0"
+"CreationDate": "2026-02-05T18:27:20.513660+00:00"
+"CrossStreet": "Beach Blvd/Arden Ave"
+"DirectionFaces": "West"
+"Directions": "EXIT QEW AT EITHER EASTPORT DRIVE OR WOODWARD AVENUE, FOLLOW TO BEACH BLVD"
+"ExpirationDate": "2026-07-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, stove, built in microwave, washer, dryer"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-01"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "184000"
+"MajorChangeTimestamp": "2026-01-01T20:01:25Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-01-01T20:01:25Z"
+"OriginalListPrice": 1259900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3388372"
+"ParcelNumber": "175700061"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-01-01T20:01:25Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beach"
+"StreetNumber": "550"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "7695.28"
+"TaxLegalDescription": "LT 1 PL 487 ; S/T INTEREST IN VM263845; CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% PLUS HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://www.myvisuallistings.com/cvt/356884"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/356884"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotShape": "Rectangular"
+"LotWidth": 40.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12654986')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "251805051104180"
+"SurveyType": "None"
+"ElectricYNA": "Yes"
+"RentalItems": "None"
+"HoldoverDays": 120
+"LaundryLevel": "Upper Level"
+"TelephoneYNA": "Available"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8H 6X3, CA"
+"ApproximateAge": "6-15"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 7
+"PropertyFeatures": array:3 [ …3]
+"PossessionDetails": "1 - 29 Days"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Call 905-297-7777 or book through Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2026-01-01T20:01:25Z"
+"SystemModificationTimestamp": "2026-01-01T20:01:26.192572Z"
+"Media": array:45 [ …45]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4272
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12268284"
+"ListingId": "X12268284"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-31T16:21:21Z"
+"RFModificationTimestamp": "2026-02-05T20:58:26Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R 1C0"
+"UnparsedAddress": "2311 Highway 56 N/a, Hamilton, ON L0R 1C0"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2560802
+"Longitude": -79.8728583
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Attention Builders, Developers, Investors & Dream-Home Seekers! An incredible opportunity awaits w/ this rare 5.54-acre parcel in the heart of Binbrook, one of Ontarios fastest-growing communities. Surrounded by new residential & multi-purpose developments, this prime piece of real estate offers endless potential. 4 bdrm, 2 bath bungalow w/ walkout basement currently on the property, opportunity to rent or live in while planning your next move. Includes massive 30' x 60' detached workshop/garage w/ 14ft ceilings & concrete floors, horse barns, ample parking & 2 driveways. With flat topography & generous frontage, the land offers a versatile canvas for future residential or multi-use development proposals. Close proximity to all amenities makes it a convenient & strategic investment. Rare & valuable opportunity to invest in a region experiencing rapid growth. Continued development & infrastructure plans underway in the surrounding area, this parcel is poised for strong appreciation."
+"ArchitecturalStyle": array:1 [ …1]
+"CityRegion": "Rural Glanbrook"
+"ConstructionMaterials": array:1 [ …1]
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "10.0"
+"CreationDate": "2026-01-21T22:41:53.964592+00:00"
+"CrossStreet": "Guyatt Rd"
+"DirectionFaces": "East"
+"Directions": "Guyatt Rd"
+"ExpirationDate": "2026-06-30"
+"GarageYN": true
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-07-07"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "269900"
+"MajorChangeTimestamp": "2025-12-31T16:21:21Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-07-07T18:44:06Z"
+"OriginalListPrice": 2999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2674742"
+"OtherStructures": array:3 [ …3]
+"ParcelNumber": "173840073"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "28.0"
+"PhotosChangeTimestamp": "2025-07-07T18:44:06Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 2999000.0
+"PriceChangeTimestamp": "2025-12-31T16:21:21Z"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Highway 56"
+"StreetNumber": "2311"
+"StreetSuffix": "N/A"
+"TaxAnnualAmount": "5967.82"
+"TaxLegalDescription": "PT LT 5, BLK 3, CON 3 BINBROOK , AS IN VM62390 ; GLANBROOK CITY OF HAMILTON"
+"TaxYear": "2025"
+"Topography": array:2 [ …2]
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"View": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"Zoning": "A1"
+"DDFYN": true
+"Water": "Well"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 649.0
+"LotShape": "Rectangular"
+"LotWidth": 270.5
+"SewerYNA": "Available"
+"WaterYNA": "Available"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268284')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "251890131074400"
+"SurveyType": "None"
+"Waterfront": array:1 [ …1]
+"ElectricYNA": "Yes"
+"HoldoverDays": 60
+"TelephoneYNA": "Available"
+"HeatTypeMulti": array:1 [ …1]
+"ParkingSpaces": 18
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L0R 1C0, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-08-29"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "5-9.99"
+"PossessionDetails": "Flexible"
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "905-592-7777"
+"MediaChangeTimestamp": "2025-07-07T18:44:06Z"
+"SystemModificationTimestamp": "2025-12-31T16:21:21.945255Z"
+"Media": array:40 [ …40]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4275
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12381894"
+"ListingId": "X12381894"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-31T14:39:13Z"
+"RFModificationTimestamp": "2026-02-05T05:09:59Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C 6Y6"
+"UnparsedAddress": "39 Megna Court, Hamilton, ON L9C 6Y6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.220961
+"Longitude": -79.9192484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Large 4-bedroom home on the West Hamilton Mountain with a finished basement. Located near Ancaster between Upper Paradise and Golf Links. Same owner since 1980, well maintained and move-in ready. Attached garage with inside entry, paved driveway for 4 cars, and private fenced yard. Walking distance to parks and schools, with nearby shopping at Upper Paradise, Rymal Rd, and Meadowlands. Easy access to the Linc and Hwy 403. 1632 sq. ft., built in 1980. Updates include furnace, AC, and water heater (2020), shingles (2010), and 100 AMP breaker panel."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CityRegion": "Gurnett"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-01-21T22:47:29.933057+00:00"
+"CrossStreet": "Greencedar Drive"
+"DirectionFaces": "North"
+"Directions": "Gurnett Drive - Greencedar Drive - Megna Court"
+"ExpirationDate": "2026-06-30"
+"ExteriorFeatures": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Microwave, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, All ELF'S and Fans"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-09-04"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "184000"
+"MajorChangeTimestamp": "2025-12-31T14:39:13Z"
+"MlsStatus": "Extension"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-09-04T19:12:21Z"
+"OriginalListPrice": 899000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2906644"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "169490134"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2025-09-04T19:12:22Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SoilType": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Megna"
+"StreetNumber": "39"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "5060.33"
+"TaxLegalDescription": "PCL 56-1, SEC M285 ; LT 56, PL M285 ; S/T PTS 103 & 104, 62R5412 IN FAVOUR OF LT 55, M285 FOR THE PURPOSE OF KEEPING AND MAINTAINING THE BUILDING UPON THE ADJACENT LANDS IN GOOD CONDITION AND REPAIR AND FOR EVERY SUCH PURPOSE SHALL HAVE ACCESS TO THAT SAID PART OF THE REAL PROPERTY AT ALL TIMES BY THEIR RESPECTIVE SERVANTS, **CON'T. See Schedule C**"
+"TaxYear": "2025"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "2.0%**"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://youtu.be/Yi Zdg HJnla4"
+"VirtualTourURLUnbranded2": "https://youtu.be/Yi Zdg HJnla4"
+"Zoning": "D/S-564"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotShape": "Rectangular"
+"LotWidth": 30.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12381894')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "251808106302236"
+"SurveyType": "None"
+"ElectricYNA": "Yes"
+"RentalItems": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Available"
+"WaterMeterYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L9C 6Y6, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 7
+"ParcelOfTiedLand": "No"
+"PropertyFeatures": array:6 [ …6]
+"LotIrregularities": "100.21 x 30.06 x 100.21 x 30.06 ft"
+"PossessionDetails": "1-29"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 5
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"LeaseToOwnEquipment": array:1 [ …1]
+"ShowingAppointments": "905-592-7777/Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2025-09-04T19:12:22Z"
+"ExtensionEntryTimestamp": "2025-12-31T14:39:13Z"
+"SystemModificationTimestamp": "2025-12-31T14:39:19.988825Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:43 [ …43]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4274
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12638076"
+"ListingId": "X12638076"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-29T21:48:40Z"
+"RFModificationTimestamp": "2026-02-12T15:02:16Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 2300.0
+"City": "Hamilton"
+"PostalCode": "L8N 1C1"
+"UnparsedAddress": "309 King Street E, Hamilton, ON L8N 1C1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2538682
+"Longitude": -79.8599933
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX PREMIER INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Two adjacent freestanding buildings at 309 & 311 King St E are for sale separately or as one. Notably, the City Council has given the green light to the LRT, with this property strategically situated along its route. There is potential for up to 6 floors of development, complemented by ample parking space at the rear. The zoning allows for a diverse array of uses, presenting a promising opportunity for developers and investors alike. The listing price reflects the price per building not both. Both buildings are optional to buy separately or together. Don't miss out on this incredible opportunity! This property is offered "As Is, Where Is"."
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CityRegion": "Beasley"
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-12T14:33:49.224053+00:00"
+"CrossStreet": "King St East / Wellington St S"
+"Directions": "King St East/Wellington St S"
+"ExpirationDate": "2026-05-31"
+"Inclusions": "As Is Where IS."
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-17"
+"MainOfficeKey": "043900"
+"MajorChangeTimestamp": "2025-12-17T14:07:19Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-12-17T14:07:19Z"
+"OriginalListPrice": 375000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3364954"
+"PhotosChangeTimestamp": "2025-12-17T14:07:20Z"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "King"
+"StreetNumber": "309"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3250.0"
+"TaxLegalDescription": "PT LT 15 PL 38 AS IN VM65590, S/T & T/W INTEREST IN VM65590; CITY OF HAMILTON"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"Utilities": array:1 [ …1]
+"Zoning": "D2"
+"Rail": "No"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "Annual"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 102.42
+"LotWidth": 34.16
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12638076')"
+"GarageType": "Outside/Surface"
+"RetailArea": 50.0
+"RollNumber": "251802018103790"
+"PropertyUse": "Multi-Use"
+"ElevatorType": "None"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8N 1C1, CA"
+"ContractStatus": "Available"
+"FreestandingYN": true
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "%"
+"PossessionDetails": "Flex"
+"OfficeApartmentArea": 50.0
+"MediaChangeTimestamp": "2025-12-29T21:48:40Z"
+"OfficeApartmentAreaUnit": "%"
+"SystemModificationTimestamp": "2025-12-29T21:48:40.062618Z"
+"Media": array:1 [ …1]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4273
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12646812"
+"ListingId": "X12646812"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-22T20:01:51Z"
+"RFModificationTimestamp": "2026-02-27T03:09:01Z"
+"ListPrice": 739990.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9C 4C3"
+"UnparsedAddress": "103 Briarwood Crescent, Hamilton, ON L9C 4C3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2355355
+"Longitude": -79.894888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "YOUR HOME SOLD GUARANTEED REALTY IMPERIUM"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this fantastic detached home located in a sought-after neighborhood on the West Mountain! This property features three plus one bedrooms, offering ample space for families and/or presenting an excellent opportunity for generating passive income. Previously used as a student rental with a projected rental income of $5,000 per month, this property represents a strong investment for your portfolio. You can choose to leave the property as is or take advantage of the significant potential to renovate it into a legal duplex or add additional bedrooms to the basement. Also perfect for first time home buyers, live in one unit and rent out the other to build wealth and increase affordability! Situated in a prime location, you'll find it near Buchanan Park, which offers lush green spaces ideal for outdoor activities. It's just a short distance from Mohawk College and various shopping amenities, making it particularly attractive for student rentals. Additionally, easy access to public transport ensures convenient commutes for all tenants. Don't miss this opportunity to invest in a property that combines excellent rental potential with a desirable location. Schedule a viewing today!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CityRegion": "Buchanan"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-02-27T00:19:54.181501+00:00"
+"CrossStreet": "GARTH TO BENDAMERE AVE"
+"DirectionFaces": "East"
+"Directions": "GARTH TO BENDAMERE AVE"
+"ExpirationDate": "2026-05-31"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Central Lakes Association of REALTORS"
+"ListingContractDate": "2025-12-22"
+"MainOfficeKey": "341800"
+"MajorChangeTimestamp": "2025-12-22T19:51:07Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-12-22T19:51:07Z"
+"OriginalListPrice": 739990.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3376618"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2025-12-22T19:51:07Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Briarwood"
+"StreetNumber": "103"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5238.0"
+"TaxLegalDescription": "LT 100, PL 1191 ; HAMILTON"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 110.29
+"LotWidth": 50.1
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12646812')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"HoldoverDays": 30
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L9C 4C3, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 5
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-12-22T19:51:07Z"
+"SystemModificationTimestamp": "2025-12-22T20:01:57.491112Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:12 [ …12]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4270
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12478891"
+"ListingId": "X12478891"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-22T19:35:48Z"
+"RFModificationTimestamp": "2026-03-15T04:27:04Z"
+"ListPrice": 2500.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 2328.0
+"City": "Hamilton"
+"PostalCode": "L8M 1K1"
+"UnparsedAddress": "663 Main Street E, Hamilton, ON L8M 1K1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2488
+"Longitude": -79.8435499
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This prime 2,300+ sq ft commercial retail space is located in the heart of Downtown Hamilton, offering exceptional visibility on a high-traffic street with strong daily footfall and drive by exposure. Positioned in a rapidly growing urban corridor surrounded by ongoing redevelopment, this property presents an outstanding opportunity for a business seeking a high-profile location with built-in credibility. Previously occupied by a successful business that was located here for over 30 years, the space carries a legacy of stability and community presence, making it ideal for retailers, showrooms, service-based operators, boutique brands, or professional users looking to establish themselves in a vibrant commercial setting. The property includes two dedicated parking spots, a rare advantage in the downtown core, and sits among a mix of established neighbourhood amenities, new developments, and an expanding residential base that continues to fuel demand for local services. With its historic past and modern growth potential, this location offers the perfect balance between character, convenience, and high exposure for a long-term business footprint in one of Hamilton's most active commercial areas."
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "St. Clair"
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-03-09T03:06:53.018889+00:00"
+"CrossStreet": "Main St E & Fairleigh"
+"Directions": "Main St E"
+"ExpirationDate": "2026-05-31"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-23"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2025-12-22T19:35:48Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-23T18:12:02Z"
+"OriginalListPrice": 2600.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3172532"
+"PhotosChangeTimestamp": "2025-10-23T18:12:02Z"
+"PreviousListPrice": 2600.0
+"PriceChangeTimestamp": "2025-12-22T19:35:48Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Main"
+"StreetNumber": "663"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8100.0"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "Half Month Rent"
+"TransactionType": "For Lease"
+"Utilities": array:1 [ …1]
+"Zoning": "C2"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "Annual"
+"HeatType": "Electric Forced Air"
+"LotDepth": 80.0
+"LotWidth": 30.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12478891')"
+"GarageType": "None"
+"RetailArea": 2328.0
+"PropertyUse": "Retail"
+"RentalItems": "Hot water heater Tank"
+"HoldoverDays": 180
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "Month"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8M 1K1, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"RetailAreaCode": "Sq Ft"
+"MediaChangeTimestamp": "2025-10-23T18:12:02Z"
+"MaximumRentalMonthsTerm": 48
+"MinimumRentalTermMonths": 12
+"SystemModificationTimestamp": "2025-12-22T19:35:48.798862Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4269
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12496752"
+"ListingId": "X12496752"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T14:46:16Z"
+"RFModificationTimestamp": "2026-02-07T16:09:46Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E 0K3"
+"UnparsedAddress": "125 Shoreview Place 638, Hamilton, ON L8E 0K3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2390543
+"Longitude": -79.7197856
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CHASE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover modern lakeside living in this stunning 1-bedroom, 1-bathroom condo featuring expansive floor-to-ceiling windows and an oversized balcony perfect for relaxing or entertaining. The bright, open-concept layout is completely carpet-free with a sleek modern design throughout and includes in-suite laundry for added convenience. Enjoy premium building amenities including a party room, rooftop patio with stunning lakeside views, and a fully equipped exercise room. This unit comes with owned parking and a locker, plus plenty of visitor parking. Efficient geothermal heating and central air for year-round comfort. Don't miss this incredible opportunity to own a contemporary condo in a desirable lakeside location!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:5 [ …5]
+"AssociationFee": "467.35"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"CityRegion": "Lakeshore"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-02-07T13:39:25.467883+00:00"
+"CrossStreet": "Millen Rd to Shoreview Pl"
+"Directions": "Millen Rd to Shoreview Pl, Left on Shoreview, Last Entrance on Right"
+"Disclosures": array:1 [ …1]
+"ExpirationDate": "2026-05-29"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Range Hood/Microwave, Dishwasher, Washer, Dryer. Option to purchase furnished."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-31"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "248800"
+"MajorChangeTimestamp": "2025-10-31T17:47:53Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-31T17:47:53Z"
+"OriginalListPrice": 399999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3192512"
+"ParcelNumber": "185891333"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-31T19:06:23Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Shoreview"
+"StreetNumber": "125"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3051.6"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"UnitNumber": "638"
+"WaterBodyName": "Lake Ontario"
+"WaterfrontFeatures": array:1 [ …1]
+"WaterfrontYN": true
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12496752')"
+"Shoreline": array:1 [ …1]
+"WaterView": array:1 [ …1]
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Ground Source"
+"RollNumber": "251800304020219"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"BalconyType": "Open"
+"DockingType": array:1 [ …1]
+"RentalItems": "None"
+"HoldoverDays": 60
+"LegalStories": "6"
+"ParkingSpot1": "Underground Space #301"
+"ParkingType1": "Owned"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"WaterBodyType": "Lake"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8E 0K3, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 589
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 4
+"AccessToProperty": array:1 [ …1]
+"AlternativePower": array:1 [ …1]
+"EnsuiteLaundryYN": true
+"SquareFootSource": "LBO Provided"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lockbox located at 101 Shoreview Pl - in Lobby"
+"WaterfrontAccessory": array:1 [ …1]
+"LegalApartmentNumber": "638"
+"MediaChangeTimestamp": "2025-10-31T19:06:23Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2025-12-17T14:46:16.611179Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:46 [ …46]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4268
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12633560"
+"ListingId": "X12633560"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T15:15:34Z"
+"RFModificationTimestamp": "2026-02-28T01:18:16Z"
+"ListPrice": 1950.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 3100.0
+"City": "Hamilton"
+"PostalCode": "L8L 2V5"
+"UnparsedAddress": "18 Barton Street E, Hamilton, ON L8L 2V5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2637456
+"Longitude": -79.8651045
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE STATE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 18 Barton Street East - a beautifull main-floor commercial space at the high-traffic corner of James St. N. and Barton St. E. This turnkey unit is ideal for a salon, wellness clinic, RMT, chiropractor, nail bar, or other personal care business. Featuring approx. 800 sq.ft. of stunning interior space, in-suite laundry, and basement storage. The building blends historic charm with modern amenities. Located just steps from some of the city's trendiest shops and restaurants, this space offers maximum visibility in a vibrant, high-foot-traffic area."
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CityRegion": "Beasley"
+"CommunityFeatures": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-27T02:30:27.309554+00:00"
+"CrossStreet": "James St N. & Barton St. E."
+"Directions": "James St. N. East on Barton"
+"ExpirationDate": "2026-06-15"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-15"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "288000"
+"MajorChangeTimestamp": "2025-12-15T15:15:34Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-12-15T15:15:34Z"
+"OriginalListPrice": 1950.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3350456"
+"ParcelNumber": "171610050"
+"PhotosChangeTimestamp": "2025-12-15T15:15:34Z"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Barton"
+"StreetNumber": "18"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7743.59"
+"TaxLegalDescription": "PT LT 11-12 PL 181 AS IN HL23644, T/W INTEREST IN VM264501; CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "1/2 Month's Rent + HST"
+"TransactionType": "For Lease"
+"Utilities": array:1 [ …1]
+"Zoning": "H"
+"Rail": "No"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Lot"
+"TaxType": "Annual"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 90.0
+"LotShape": "Rectangular"
+"LotWidth": 18.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12633560')"
+"GarageType": "None"
+"RetailArea": 980.0
+"RollNumber": "251802015655430"
+"PropertyUse": "Multi-Use"
+"ElevatorType": "None"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "Net Lease"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8L 2V5, CA"
+"ContractStatus": "Available"
+"FreestandingYN": true
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"PossessionDetails": "Flexible"
+"MediaChangeTimestamp": "2025-12-15T15:15:34Z"
+"MaximumRentalMonthsTerm": 60
+"MinimumRentalTermMonths": 36
+"SystemModificationTimestamp": "2025-12-15T15:15:35.033136Z"
+"Media": array:27 [ …27]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4267
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12614468"
+"ListingId": "X12614468"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T01:01:48Z"
+"RFModificationTimestamp": "2026-02-11T04:20:49Z"
+"ListPrice": 799999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L 4X8"
+"UnparsedAddress": "575 Mary Street, Hamilton, ON L8L 4X8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.2722078
+"Longitude": -79.856884
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 575 Mary Street, a stunningly unique property steps from the water's edge in the north end of Hamilton, where a tight-knit family transformed a house into a home during the quiet of Covid lockdowns. Step inside this fully renovated gem, seamlessly blending modern comforts with warm, inviting spaces, all crafted by a talented Hamilton native and international artist. The artistic flair captivates, merging the natural light of the outdoors with glass, cement, and crisp whites throughout. At the heart of the home is a stunning kitchen featuring floor-to-ceiling cabinetry, a four-seater waterfall quartz island, and very likely the most interesting matching Italian porcelain flooring and backsplash combo you have ever seen. The front porch, drenched in light from two skylights, is perfect for sipping morning coffee while enjoying the sunrise. On the opposite side of the house, cozy evenings come alive by the newly installed wood-burning fireplace, which warms the all-season backyard patio designed for both entertaining and relaxing after a long day. This home also features an innovative and massive office space seamlessly integrated into the main bedroom, ideal for remote work or midnight inspiration. With HUE smart lights throughout, you can easily set the perfect mood for any occasion. In the last four years, recent upgrades include Neal installed roof coverings, a high-efficiency furnace, all new flooring, windows, all siding, main floor powder room, brand-new kitchen and laundry appliances. This means you can move in and enjoy modern living! With three spacious bedrooms plus an office, this home provides ample space for families, guests, or your creative pursuits. Plus, convenience is key with two included parking spaces and an upgraded fast-charging EV connection port already installed. Come fall in love with this art piece of a home. A space ready for some new dreamers and creative spirits!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CityRegion": "North End"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-07T17:44:49.493563+00:00"
+"CrossStreet": "Mary St. and Brock St."
+"DirectionFaces": "West"
+"Directions": "Burlington St. E. to Mary St."
+"Exclusions": "None."
+"ExpirationDate": "2026-06-05"
+"ExteriorFeatures": array:2 [ …2]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Fridge, stove, dishwasher, washer, and dryer."
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-09"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "248500"
+"MajorChangeTimestamp": "2025-12-10T01:01:48Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-12-10T01:01:48Z"
+"OriginalListPrice": 799999.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3348180"
+"ParcelNumber": "171550215"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-12-10T01:01:48Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Mary"
+"StreetNumber": "575"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3390.0"
+"TaxLegalDescription": "PT LT 44 OR 81 NATHANIEL HUGHSON SURVEY (UNREGISTERED) W/S MARY ST BTN BURLINGTON ST & BROCK ST AS IN CD481453; CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://iframe.videodelivery.net/e60499a5b6ac0e7fdab37cf01d2c3d51"
+"VirtualTourURLBranded2": "https://my.matterport.com/show/?m=ms84GXX4mg Z"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ms84GXX4mg Z"
+"VirtualTourURLUnbranded2": "https://iframe.videodelivery.net/6f86174062b86615fe67c0fe20d7a24e"
+"Zoning": "D"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 120.0
+"LotShape": "Rectangular"
+"LotWidth": 20.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12614468')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "251802016605960"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"Winterized": "Fully"
+"ElectricYNA": "Yes"
+"RentalItems": "Water heater."
+"HoldoverDays": 120
+"LaundryLevel": "Main Level"
+"TelephoneYNA": "Available"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8L 4X8, CA"
+"ApproximateAge": "100+"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-01-09"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"MortgageComment": "Seller to discharge mortgage."
+"RoomsAboveGrade": 8
+"ParcelOfTiedLand": "No"
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay/LBO. Please remove shoes, leave card, turn off lights, lock all doors."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2025-12-10T01:01:48Z"
+"SystemModificationTimestamp": "2025-12-10T01:01:48.667708Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4266
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12609296"
+"ListingId": "X12609296"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T21:23:02Z"
+"RFModificationTimestamp": "2026-02-27T04:54:53Z"
+"ListPrice": 23.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1555.0
+"City": "Hamilton"
+"PostalCode": "L8R 2L4"
+"UnparsedAddress": "297 James Street N, Hamilton, ON L8R 2L4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3382023
+"Longitude": -79.8903385
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "COLLIERS"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Your business belongs on James Street North - Hamilton's thriving arts and culture corridor. This 1,555 sq. ft. retail space offers prime frontaage, strong foot traffic, and proximity to the newly renovated TD Coliseum, just a short walk from the GO Station via the upcoming pedestrian pathway. Surrounded by independent restaurants, boutiques, and creative businesses, it's an ideal home for a boutique retailer, cafe or service-based concept ready to tap into the neighbourhood's energy. Make your mark where Hamilton comes to life."
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CityRegion": "Central"
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2026-02-27T04:07:05.260115+00:00"
+"CrossStreet": "James St N & Colbourne"
+"Directions": "James St N & Colbourne"
+"ExpirationDate": "2026-06-08"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-12-08"
+"MainOfficeKey": "336800"
+"MajorChangeTimestamp": "2025-12-08T15:06:50Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-12-08T15:06:50Z"
+"OriginalListPrice": 23.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3329670"
+"ParcelNumber": "171600191"
+"PhotosChangeTimestamp": "2025-12-08T15:06:50Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "James"
+"StreetNumber": "297"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "10.03"
+"TaxLegalDescription": "PT LT 2 BLK 1 PL 127 AS IN VM78045 CITY OF HAMILTON"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "3.5% 1st Year, 2% Thereafter"
+"TransactionType": "For Lease"
+"Utilities": array:1 [ …1]
+"Zoning": "H"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 120.0
+"LotWidth": 26.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12609296')"
+"GarageType": "None"
+"RetailArea": 1555.0
+"RollNumber": "251802012656600"
+"PropertyUse": "Retail"
+"HoldoverDays": 90
+"HeatTypeMulti": array:1 [ …1]
+"ListPriceUnit": "Sq Ft Net"
+"provider_name": "TRREB"
+"short_address": "Hamilton, ON L8R 2L4, CA"
+"ContractStatus": "Available"
+"FreestandingYN": true
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"PossessionDetails": "Immediate"
+"MediaChangeTimestamp": "2025-12-08T15:06:50Z"
+"MaximumRentalMonthsTerm": 120
+"MinimumRentalTermMonths": 60
+"SystemModificationTimestamp": "2025-12-08T21:23:02.334431Z"
+"Media": array:7 [ …7]
}
]
+success: true
+page_size: 10
+page_count: 138
+count: 1373
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4237
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4073
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13051336"
+"ListingId": "X13051336"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-03T00:14:07Z"
+"RFModificationTimestamp": "2026-05-03T00:18:00Z"
+"ListPrice": 347000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2C 2P3"
+"UnparsedAddress": "565 Greenfield Avenue 310, Kitchener, ON N2C 2P3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.425649
+"Longitude": -80.445869
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Right At Home Realty, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this beautifully updated third-floor condo, offering stylish, move-in-ready living in an exceptionally convenient location. This inviting 2-bedroom unit is thoughtfully designed and ready for you to enjoy. Bright and airy, the 650 sq ft layout features a spacious living area and a charming peek-a-boo kitchen that creates an open, connected feel-perfect for both everyday living and entertaining. Step out onto your private third-floor balcony, complete with sleek glass railings and a convenient storage closet-an ideal space to relax and unwind. The unit includes a dedicated parking space, and condo fees are an affordable $307 per month. Enjoy unbeatable convenience with public transit right outside your door and a short walk to Fairview Park Mall, offering a wide range of shopping, dining, and access to Grand River Transit and LRT services. Backing onto Greenfield Park and just minutes from Highway 401, this location makes commuting and daily errands effortless. With modern updates, low fees, and exceptional accessibility, this charming condo is a fantastic opportunity. Book your private showing today."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "307.0"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "Right At Home Realty, Brokerage"
+"CoListOfficePhone": "905-637-1700"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T12:38:08.323436+00:00"
+"CrossStreet": "Woodhaven"
+"Directions": "Greenfield Ave and Kingsway Dr"
+"ExpirationDate": "2026-07-24"
+"Inclusions": "Fridge, Stove, Washer, Dryer, Microwave"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Oakville, Milton & District Real Estate Board"
+"ListingContractDate": "2026-04-24"
+"MainOfficeKey": "540200"
+"MajorChangeTimestamp": "2026-04-28T14:28:18Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-28T12:32:03Z"
+"OriginalListPrice": 339900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3833786"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-28T12:32:04Z"
+"PreviousListPrice": 339900.0
+"PriceChangeTimestamp": "2026-04-28T14:28:18Z"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "GREENFIELD"
+"StreetNumber": "565"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "1845.05"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2"
+"TransactionType": "For Sale"
+"UnitNumber": "310"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13051336')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"SurveyType": "None"
+"BalconyType": "Enclosed"
+"RentalItems": "Hot Water Tank"
+"HoldoverDays": 30
+"LegalStories": "3"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
…22
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4074 …129}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4075 …129}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4096 …132}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4097 …142}
]
+success: true
+page_size: 5
+page_count: 8452
+count: 42257
+after_key: ""
}
]
]
