Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40600&$filter=(StandardStatus eq 'Active') and StandardStatus eq 'Active'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40600&$filter=(StandardStatus eq 'Active') and StandardStatus eq 'Active'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40600&$filter=(StandardStatus eq 'Active') and StandardStatus eq 'Active'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=40600&$filter=(StandardStatus eq 'Active') and StandardStatus eq 'Active'&$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: "683903" +post_author: 1 +"ListingKey": "N12935772" +"ListingId": "N12935772" +"PropertyType": "Residential Lease" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:51:56Z" +"RFModificationTimestamp": "2026-05-02T06:49:26Z" +"ListPrice": 1850.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Vaughan" +"PostalCode": "L4H 1S9" +"UnparsedAddress": "67 Castillian Drive Lower, Vaughan, ON L4H 1S9" +"Coordinates": array:2 [ …2] +"Latitude": 43.81897 +"Longitude": -79.610023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REMAX YOUR COMMUNITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rarely Available Spacious Totally Turnkey Furnished Separate Apartment With Private Entrance In High Demand Sonoma Heights. Amazing Value. Plenty Of Lights And Oversized Windows Allow An Abundance Of Lighting. Walkout To Private Patio And Enjoy the Tranquil Garden. Friendly Safe Community & Close To Amenities, Transit & Shops. Apartment Is Above Ground With Full Above Grade Windows. 1 Parking Space. Tenant To Assume 33% Cost Of Utilities." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Sonoma Heights" +"CoListOfficeName": "REMAX YOUR COMMUNITY REALTY" +"CoListOfficePhone": "905-832-6656" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "York" +"CreationDate": "2026-04-16T20:40:27.093023+00:00" +"CrossStreet": "Rutherford Road and Clarence Street" +"DirectionFaces": "East" +"Directions": "Rutherford Road and Clarence Street" +"ExpirationDate": "2026-06-30" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer. Home Is Super Clean And Neat" +"InteriorFeatures": "None" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "087000" +"MajorChangeTimestamp": "2026-03-30T16:31:46Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-30T16:31:46Z" +"OriginalListPrice": 1850.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738504" +"ParkingFeatures": "Available,Front Yard Parking" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-03-30T16:51:56Z" +"PoolFeatures": "None" +"RentIncludes": array:3 [ …3] +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Castillian" +"StreetNumber": "67" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "Lower" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12935772')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Vaughan, ON L4H 1S9, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-04-26" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 3 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"CoListOfficeName3": "REMAX YOUR COMMUNITY REALTY" +"PossessionDetails": "April 26, 2026" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T16:51:56Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-03-30T16:51:59.767578Z" +"Media": array:7 [ …7] +"ID": "683903" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: "683904" +post_author: 1 +"ListingKey": "X12935638" +"ListingId": "X12935638" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:51:24Z" +"RFModificationTimestamp": "2026-05-02T22:08:14Z" +"ListPrice": 1300000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Fort Erie" +"PostalCode": "L2A 3H2" +"UnparsedAddress": "411 Niagara Boulevard, Fort Erie, ON L2A 3H2" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Two properties are offered for sale together. An exciting low-density residential proposal has been submitted to the Town to redesignate and rezone the combined parcels at 411 and 415 Niagara Boulevard, opening the door to a 15-unit townhouse community and a detached house. This prime location delivers both strong investment potential and exceptional lifestyle appeal.The property at 411 Niagara Boulevard features a spacious 4-bedroom, two-storey home with a large picture window showcasing breathtaking views of the Niagara River. With excellent Airbnb potential, you can choose to move into the existing home, generate short-term rental income, redevelop the site into a modern riverside community, or hold it as a valuable long-term asset. This is a rare opportunity to secure premium waterfront-adjacent real estate." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "332 - Central" +"CoListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"CoListOfficePhone": "905-338-3737" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-02T21:12:57.745708+00:00" +"CrossStreet": "Gilmore Rd & Niagara Blvd" +"DirectionFaces": "West" +"Directions": "Central Ave- Gilmore Rd- Niagara Blvd" +"ExpirationDate": "2026-06-30" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in dishwasher, fridge, stove, washer, dryer, all elfs, all window coverings" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-30" +"LotSizeSource": "MPAC" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2026-03-30T16:09:29Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:09:29Z" +"OriginalListPrice": 1300000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3731462" +"ParcelNumber": "642280181" +"ParkingFeatures": "Private Double" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-03-30T16:09:29Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Niagara" +"StreetNumber": "411" +"StreetSuffix": "Boulevard" +"TaxAnnualAmount": "5965.0" +"TaxAssessedValue": 328000 +"TaxLegalDescription": "PT LT 33 W/S NIAGARA ST PL 525 VILLAGE OF BRIDGEBURG" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"WaterBodyName": "Niagara River" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Water" +"LotDepth": 531.75 +"LotShape": "Irregular" +"LotWidth": 80.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935638')" +"Shoreline": array:1 [ …1] +"WaterView": array:1 [ …1] +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "270301004603600" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"RentalItems": "Hot water heater" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 6 +"WaterBodyType": "River" +"provider_name": "TRREB" +"short_address": "Fort Erie, ON L2A 3H2, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"MortgageComment": "Clear" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 1 +"AccessToProperty": array:1 [ …1] +"PropertyFeatures": array:4 [ …4] +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "905-338-3737" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"WashroomsType5Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T16:09:29Z" +"SystemModificationTimestamp": "2026-03-30T16:51:32.332444Z" +"Media": array:41 [ …41] +"ID": "683904" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: "599919" +post_author: 1 +"ListingKey": "X12794370" +"ListingId": "X12794370" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:50:56Z" +"RFModificationTimestamp": "2026-05-02T06:50:44Z" +"ListPrice": 930000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kingston" +"PostalCode": "K7M 9E7" +"UnparsedAddress": "456 Weston Crescent, Kingston, ON K7M 9E7" +"Coordinates": array:2 [ …2] +"Latitude": 44.2538197 +"Longitude": -76.5466712 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD., BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 456 Weston Crescent - a beautifully maintained all-brick two-storey home offering exceptional space and versatility for families, multi-generational living, or investment potential. With seven bedrooms and numerous upgrades throughout, this home truly shows pride of ownership. The main floor features a formal living and dining room, along with a warm and inviting great room complete with a gas fireplace. The bright eat-in kitchen is designed for both everyday living and entertaining, offering a breakfast bar island with quartz countertops and ample workspace. Convenient main-floor laundry adds to the home's functionality. Upstairs, the oversized primary suite provides a private retreat with a luxurious 5-piece ensuite featuring a soaker tub. Three additional generously sized bedrooms and a full bath complete the upper level. The fully finished walkout lower level offers a separate entrance, three bedrooms, a full kitchen, and a bathroom, creating an ideal setup for extended family, older children, or rental income. Outside, enjoy a fully fenced backyard with two decks and no rear neighbours, providing a quiet and private outdoor space. Recent updates include soundproofing, triple-pane windows, roof, furnace, A/C, hot water tank, front and basement doors, lighting, and exhaust fans. Located in the sought-after Waterloo Village neighbourhood, close to Trillium Ridge Park, schools, shopping, downtown Kingston, and Hwy 401, this move-in-ready home offers incredible flexibility and value." +"ArchitecturalStyle": "2-Storey" +"Basement": array:5 [ …5] +"CityRegion": "35 - East Gardiners Rd" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Frontenac" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-16T20:43:07.125128+00:00" +"CrossStreet": "Waterloo Dr and Grandtrunk" +"DirectionFaces": "East" +"Directions": "Taylor Kidd to Waterloo to Grand trunk to Weston" +"ExpirationDate": "2026-05-31" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "DISHWASHER, DRYER, Garage Door opener, WATERTANK, RANGEHOOD, REFRIGERATOR, STOVE, WASHER" +"InteriorFeatures": "Accessory Apartment,Auto Garage Door Remote,Carpet Free,ERV/HRV,In-Law Suite,Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Kingston & Area Real Estate Association" +"ListingContractDate": "2026-02-17" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "470900" +"MajorChangeTimestamp": "2026-02-17T18:35:02Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2026-02-17T18:35:02Z" +"OriginalListPrice": 930000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3553474" +"ParcelNumber": "360850721" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-02-17T18:35:03Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Weston" +"StreetNumber": "456" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "6028.24" +"TaxLegalDescription": "LOT 127, PLAN 13M26; S/T EASMNT PT 14, 13R15580 IN FAVOUR OF THE CORPORATION OF THE CITY OF KINGSTON AS IN LT28048; KINGSTON" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 125.04 +"LotShape": "Other" +"LotWidth": 31.61 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12794370')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "101108018612700" +"SurveyType": "Unknown" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Kingston, ON K7M 9E7, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "24 Hours notice. Basement tenants" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-03-30T16:50:56Z" +"SystemModificationTimestamp": "2026-03-30T16:51:07.764526Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:47 [ …47] +"ID": "599919" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "580195" +post_author: 1 +"ListingKey": "X12717994" +"ListingId": "X12717994" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:50:50Z" +"RFModificationTimestamp": "2026-05-02T06:50:40Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lakeshore" +"PostalCode": "N8N 4X9" +"UnparsedAddress": "150 Seymour Crescent, Lakeshore, ON N8N 4X9" +"Coordinates": array:2 [ …2] +"Latitude": 42.3067707 +"Longitude": -82.8196745 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Platinum Gate Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime location, unmatched curb appeal! This remarkable full stone and brick 2-storey residence is tucked away on a quiet cul-de-sac in the prestigious Orchard Park community. Thoughtfully custom-built for family living, it offers nearly 4,000 sq. ft. above grade, with 4 bedrooms, 3.5 bathrooms, a butlers pantry, and a private backyard featuring a covered porch and a heated saltwater in-ground pool. The home showcases a spectacular floor plan with soaring 18-ft ceilings in both the foyer and living room, a main-floor den with tray ceilings, a spacious primary suite with dual walk-in closets, convenient main-floor laundry, and a spotless 2.5-car garage. The main floor also includes two dens, either of which could serve as an additional bedroom. The fully finished basement adds even more living space with 2 bedrooms and a full bathroom." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Lakeshore" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Essex" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-26T13:48:12.199843+00:00" +"CrossStreet": "Orchard Park Drive & Seymour Crescent" +"DirectionFaces": "West" +"Directions": "Orchard Park Drive & Seymour Crescent" +"ExpirationDate": "2026-05-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-21" +"MainOfficeKey": "441900" +"MajorChangeTimestamp": "2026-01-21T18:45:46Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-21T18:45:46Z" +"OriginalListPrice": 1299000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3466240" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-03-30T16:50:50Z" +"PoolFeatures": "None" +"Roof": "Other" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Seymour" +"StreetNumber": "150" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "7500.0" +"TaxLegalDescription": "LT 79 PL 12M340 MAIDSTONE" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotWidth": 57.81 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12717994')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Lakeshore, ON N8N 4X9, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 4 +"RoomsBelowGrade": 1 +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T16:50:50Z" +"SystemModificationTimestamp": "2026-03-30T16:51:00.31442Z" +"Media": array:39 [ …39] +"ID": "580195" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "687362" +post_author: 1 +"ListingKey": "X12935906" +"ListingId": "X12935906" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:49:39Z" +"RFModificationTimestamp": "2026-05-02T06:50:59Z" +"ListPrice": 549900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Trent Hills" +"PostalCode": "K0L 1Y0" +"UnparsedAddress": "8 Church Lane, Trent Hills, ON K0L 1Y0" +"Coordinates": array:2 [ …2] +"Latitude": 44.210178 +"Longitude": -77.914391 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BALL REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this solid 2+1 bedroom brick bungalow, perfectly situated in a quiet, family-friendly residential neighborhood. This well-maintained home offers a functional layout with bright living space and plenty of versatility for a variety of lifestyles. The main level features two comfortable bedrooms, a spacious living area, and a practical kitchen ready for your personal touch. The finished lower level adds a third bedroom and offers excellent in-law suite potential, making it ideal for extended family or additional living space. Outside, you'll find even more to love with both an attached garage and a detached garage/workshop - perfect for hobbyists, storage, or extra parking. Enjoy the peace and privacy of this desirable location while still being close to local amenities. A fantastic opportunity for homeowners, investors, or those looking to customize a home to their needs." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ …2] +"CityRegion": "Hastings" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Northumberland" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-16T20:43:09.087077+00:00" +"CrossStreet": "Water St" +"DirectionFaces": "East" +"Directions": "Water St to Church Lane" +"Exclusions": "Personal Possessions" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": "Canopy,Deck,Landscaped,Year Round Living" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:2 [ …2] +"GarageYN": true +"Inclusions": "Fridge, Stove, Washer, Dryer, Champion 6500 Generator, Electric Light Fixtures" +"InteriorFeatures": "Auto Garage Door Remote,Carpet Free,Generator - Partial,In-Law Capability,On Demand Water Heater,Primary Bedroom - Main Floor,Sewage Pump,Storage,Sump Pump,Water Heater Owned,Workbench" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2026-03-30" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "333400" +"MajorChangeTimestamp": "2026-03-30T16:49:39Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-30T16:49:39Z" +"OriginalListPrice": 549900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738054" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "512130146" +"ParkingFeatures": "Private" +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2026-03-30T17:03:57Z" +"PoolFeatures": "None" +"Roof": "Metal" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Church" +"StreetNumber": "8" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "3646.0" +"TaxLegalDescription": "LT 30 PL 69 PERCY; TRENT HILLS" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% plus HST" +"TransactionType": "For Sale" +"View": array:2 [ …2] +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 55.95 +"LotWidth": 155.3 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935906')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "143533203011130" +"SurveyType": "None" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"short_address": "Trent Hills, ON K0L 1Y0, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-30" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T17:03:57Z" +"SystemModificationTimestamp": "2026-03-30T17:03:57.673093Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:28 [ …28] +"ID": "687362" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853 +post_id: "560052" +post_author: 1 +"ListingKey": "X12697628" +"ListingId": "X12697628" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:49:06Z" +"RFModificationTimestamp": "2026-05-03T04:08:45Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Windsor" +"PostalCode": "N9A 5H2" +"UnparsedAddress": "377 Elm Avenue, Windsor, ON N9A 5H2" +"Coordinates": array:2 [ …2] +"Latitude": 42.3029482 +"Longitude": -83.0448808 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Platinum Gate Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this well-maintained and versatile property featuring 6 bedrooms plus loft, 3 full washrooms, and 3 kitchens, offering excellent functionality and strong rental potential. The home includes a separate entrance to the basement, ideal for multi-generational living or investment use. Currently fully furnished and configured as a student rental, this property provides a turnkey opportunity. The layout is thoughtfully designed to maximize space and comfort, with multiple kitchens to accommodate shared living arrangements. Conveniently located within close proximity to the university, public transit, and everyday amenities, making it highly desirable for tenants. Additional highlights include parking for up to four vehicles. An excellent opportunity for investors or end-users seeking a property in a high-demand rental area." +"ArchitecturalStyle": "2 1/2 Storey" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Essex" +"CoveredSpaces": "1.0" +"CreationDate": "2026-05-02T21:11:26.164061+00:00" +"CrossStreet": "University Ave And Elm Ave" +"DirectionFaces": "West" +"Directions": "University Ave And Elm Ave" +"ExpirationDate": "2026-05-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"HeatingYN": true +"Inclusions": "All Beds, Wardrobes, And Kitchen/Kitchenette Appliances Cooktop, Microwave, Washer, Dryer, Central AC, Fridge & Stove" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-14" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "31.00 x 110.00 Feet" +"MainOfficeKey": "441900" +"MajorChangeTimestamp": "2026-01-14T22:59:42Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-14T22:59:42Z" +"OriginalListPrice": 549000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3432068" +"ParcelNumber": "012020267" +"ParkingFeatures": "Private" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-03-30T16:49:06Z" +"PoolFeatures": "None" +"Roof": "Shingles" +"RoomsTotal": "11" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Elm" +"StreetNumber": "377" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2032.0" +"TaxLegalDescription": "Pt Lot 36 Plan 638 Windsor; Pt Lot 37 Plan 638 Win" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotWidth": 31.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12697628')" +"PictureYN": true +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "373904018001000" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 3 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Windsor, ON N9A 5H2, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 3 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"AccessToProperty": array:1 [ …1] +"PropertyFeatures": array:5 [ …5] +"StreetSuffixCode": "Ave" +"BoardPropertyType": "Free" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 2 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-03-30T16:49:06Z" +"MLSAreaDistrictOldZone": "X01" +"MLSAreaMunicipalityDistrict": "Windsor" +"SystemModificationTimestamp": "2026-03-30T16:49:13.320443Z" +"Media": array:2 [ …2] +"ID": "560052" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "662109" +post_author: 1 +"ListingKey": "X12935896" +"ListingId": "X12935896" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:54Z" +"RFModificationTimestamp": "2026-05-03T16:04:16Z" +"ListPrice": 2930.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lower Town - Sandy Hill" +"PostalCode": "K1N 5Z8" +"UnparsedAddress": "560 Rideau Street 704, Lower Town - Sandy Hill, ON K1N 5Z8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "DIGI BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "** UP TO 2 MONTH'S FREE RENT** Welcome to The Charlotte, a modern condo in the heart of Sandy Hill. This bright and efficiently designed 2-bedroom + den, 2-bathroom suite offers approximately 797 sq ft of functional living space with a well-appointed open-concept layout and contemporary finishes throughout.The kitchen, living, and dining area is thoughtfully designed with a large island offering seating and prep space-ideal for both everyday living and entertaining. This space is filled with natural light and provides access to multiple private balconies, creating seamless indoor-outdoor living and offering unique outdoor spaces rarely found in condo living.The versatile den is perfect for a home office or additional flex space. The primary bedroom features a private ensuite, while the second bedroom is well-sized and conveniently located near the second full bathroom. In-unit laundry adds to the everyday convenience.Residents enjoy exceptional amenities including a rooftop pool with expansive terrace and BBQ area, fully equipped fitness centre, yoga studio, party/meeting room, concierge service, guest suites, pet wash station, bike storage, and visitor parking.Located steps to the University of Ottawa, By Ward Market, Rideau Centre, transit, parks, and the Rideau Canal-ideal for professionals, investors, or downsizers seeking stylish urban living." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:6 [ …6] +"Basement": array:1 [ …1] +"BuildingName": "The Charlotte" +"CityRegion": "4003 - Sandy Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-05-02T21:13:52.304906+00:00" +"CrossStreet": "Rideau St & Cobourg St" +"Directions": "South side of Rideau Street between Friel Street & Augusta Street" +"Exclusions": "Hydro & Water billed separately." +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer & Dryer. A/C, Heat & Rogers WIFI included." +"InteriorFeatures": "None" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "486100" +"MajorChangeTimestamp": "2026-03-30T16:48:54Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:48:54Z" +"OriginalListPrice": 2930.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738756" +"ParcelNumber": "160980078" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T16:48:54Z" +"RentIncludes": array:4 [ …4] +"SecurityFeatures": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rideau" +"StreetNumber": "560" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month's rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "704" +"DDFYN": true +"Locker": "None" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935896')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "61402100108578" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Parking available for $225/month. Storage available for $50/month." +"LaundryLevel": "Main Level" +"LegalStories": "7" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Lower Town - Sandy Hill, ON K1N 5Z8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-03-30" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "As Per Floorplan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"ParkingMonthlyCost": 225.0 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "04" +"MediaChangeTimestamp": "2026-03-30T16:48:54Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "RICHCRAFT RENTAL LIMITED PARTNERSHIP" +"SystemModificationTimestamp": "2026-03-30T16:48:55.629887Z" +"Media": array:50 [ …50] +"ID": "662109" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "702517" +post_author: 1 +"ListingKey": "X12935894" +"ListingId": "X12935894" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:45Z" +"RFModificationTimestamp": "2026-05-02T22:08:14Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9K 0H7" +"UnparsedAddress": "59 Robertson Road, Hamilton, ON L9K 0H7" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 59 Robertson Road, a well-kept family home in the heart of Meadowlands, one of the most desirable communities in Ancaster. This spacious 5-bedroom 3.5 bathrooms detached home offers a comfortable layout with plenty of room to grow, work, and relax.The main level features a bright, open feel with a welcoming entryway and a solid wood staircase that adds warmth and character. Large windows bring in plenty of natural light throughout the home. Upstairs, the bedrooms are generously sized, including a spacious primary retreat with room for a sitting area or workspace.The home sits on a quiet, family-friendly street surrounded by other well-maintained properties. The exterior offers great curb appeal with a brick and stone façade and a double car garage. The unfinished basement is ready for your personal touch with readily available architechtural drawings and a 3 piece bath rough-in. The backyard provides a private space to enjoy warmer months or entertain friends and family. Located close to top-rated schools, parks, shopping, and everyday amenities, with easy access to major highways and transit. Ancaster is known for its strong sense of community, great trails, and convenient access to both nature and city life. A solid home in a sought-after location, perfect for families looking to settle into a mature, established neighbourhood." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Meadowlands" +"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"CoListOfficePhone": "905-568-2121" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-02T21:12:29.201045+00:00" +"CrossStreet": "Garner / Raymond Rd" +"DirectionFaces": "North" +"Directions": "Garner" +"ExpirationDate": "2026-09-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Washer, Dryer, Dishwasher, Microwave, Fridge, Stove" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-28" +"LotSizeSource": "MPAC" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2026-03-30T16:48:45Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-30T16:48:45Z" +"OriginalListPrice": 1100000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3734892" +"ParcelNumber": "175655188" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-03-30T16:48:45Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Robertson" +"StreetNumber": "59" +"StreetSuffix": "Road" +"TaxAnnualAmount": "8238.91" +"TaxLegalDescription": "LOT 150, PLAN 62M1237 TOGETHER WITH AN EASEMENT OVER BLKS 321, 338 & 340, PL 62M1158 AS IN WE766983 TOGETHER WITH AN EASEMENT OVER BLK 321, PL 62M1158 AS IN WE766983 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1187002 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1191716 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1291257 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus hst" +"TransactionType": "For Sale" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 30.59 +"LotWidth": 12.2 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935894')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814028038833" +"SurveyType": "Unknown" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9K 0H7, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 3 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 7 +"LotSizeAreaUnits": "Square Meters" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-03-30T16:48:45Z" +"SystemModificationTimestamp": "2026-03-30T16:48:45.445179Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:28 [ …28] +"ID": "702517" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "702519" +post_author: 1 +"ListingKey": "X12935892" +"ListingId": "X12935892" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:35Z" +"RFModificationTimestamp": "2026-05-03T16:04:16Z" +"ListPrice": 3130.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lower Town - Sandy Hill" +"PostalCode": "K1N 5Z8" +"UnparsedAddress": "560 Rideau Street 703, Lower Town - Sandy Hill, ON K1N 5Z8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "DIGI BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "** UP TO 2 MONTH'S FREE RENT** Welcome to The Charlotte, a modern condo in the heart of Sandy Hill. This bright and well-designed 2-bedroom + den, 2-bathroom suite offers approximately 847 sq ft of functional living space with a smart, open-concept layout and contemporary finishes throughout. The main living area features a spacious kitchen and living/dining combination with a large island offering seating and prep space-ideal for entertaining. The living area is filled with natural light and provides direct access to a private balcony, creating seamless indoor-outdoor living. The primary bedroom includes a private ensuite, while the second bedroom is complemented by its own balcony-offering added light and outdoor access. The separate den is perfect for a home office or flex space. A second full bathroom and in-unit laundry provide everyday convenience. Residents enjoy exceptional amenities including a rooftop pool with expansive terrace and BBQ area, fully equipped fitness centre, yoga studio, party/meeting room, concierge service, guest suites, pet wash station, bike storage, and visitor parking. Located steps to the University of Ottawa, By Ward Market, Rideau Centre, transit, parks, and the Rideau Canal-ideal for professionals, investors, or downsizers seeking stylish urban living." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:6 [ …6] +"Basement": array:1 [ …1] +"BuildingName": "The Charlotte" +"CityRegion": "4003 - Sandy Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-05-02T21:14:07.452317+00:00" +"CrossStreet": "Rideau St & Cobourg St" +"Directions": "South side of Rideau Street between Friel Street & Augusta Street" +"Exclusions": "Hydro & Water billed separately." +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer & Dryer. A/C, Heat & Rogers WIFI included." +"InteriorFeatures": "None" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "486100" +"MajorChangeTimestamp": "2026-03-30T16:48:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:48:35Z" +"OriginalListPrice": 3130.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738242" +"ParcelNumber": "160980078" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T16:48:35Z" +"RentIncludes": array:4 [ …4] +"SecurityFeatures": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rideau" +"StreetNumber": "560" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month's rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "703" +"DDFYN": true +"Locker": "None" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935892')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "61402100108578" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Parking available for $225/month. Storage available for $50/month." +"LaundryLevel": "Main Level" +"LegalStories": "7" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Lower Town - Sandy Hill, ON K1N 5Z8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-03-30" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 1 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "As Per Floorplan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"ParkingMonthlyCost": 225.0 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "03" +"MediaChangeTimestamp": "2026-03-30T16:48:35Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "RICHCRAFT RENTAL LIMITED PARTNERSHIP" +"SystemModificationTimestamp": "2026-03-30T16:48:36.149575Z" +"Media": array:50 [ …50] +"ID": "702519" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "702520" +post_author: 1 +"ListingKey": "X12935884" +"ListingId": "X12935884" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:15Z" +"RFModificationTimestamp": "2026-05-03T16:04:16Z" +"ListPrice": 2725.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lower Town - Sandy Hill" +"PostalCode": "K1N 5Z8" +"UnparsedAddress": "560 Rideau Street 413, Lower Town - Sandy Hill, ON K1N 5Z8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "DIGI BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "** UP TO 2 MONTH'S FREE RENT** Welcome to The Charlotte, a modern condo in the heart of Sandy Hill. This bright and well-designed 2-bedroom, 2-bathroom suite offers approximately 777 sq ft of functional living space with a smart, open-concept layout and contemporary finishes throughout. The main living area features a spacious kitchen and living/dining combination with a large island offering seating and prep space-ideal for entertaining. The kitchen/dining area is filled with natural light and provides access to a private balcony, perfect for morning coffee or evening relaxation. The primary bedroom features a walk-in closet, private ensuite, and its own balcony-creating a comfortable and private retreat. The second bedroom is thoughtfully positioned on the opposite side of the unit for added privacy. A second full bathroom and in-unit laundry provide everyday convenience. Residents enjoy exceptional amenities including a rooftop pool with expansive terrace and BBQ area, fully equipped fitness centre, yoga studio, party/meeting room, concierge service, guest suites, pet wash station, bike storage, and visitor parking. Located steps to the University of Ottawa, By Ward Market, Rideau Centre, transit, parks, and the Rideau Canal-ideal for professionals, investors, or downsizers seeking stylish urban living." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:6 [ …6] +"Basement": array:1 [ …1] +"BuildingName": "The Charlotte" +"CityRegion": "4003 - Sandy Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-05-02T21:14:00.996026+00:00" +"CrossStreet": "Rideau St & Cobourg St" +"Directions": "South side of Rideau Street between Friel Street & Augusta Street" +"Exclusions": "Hydro & Water billed separately." +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer & Dryer. A/C, Heat & Rogers WIFI included." +"InteriorFeatures": "None" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "486100" +"MajorChangeTimestamp": "2026-03-30T16:48:15Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:48:15Z" +"OriginalListPrice": 2725.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3734972" +"ParcelNumber": "160980078" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T16:48:15Z" +"RentIncludes": array:4 [ …4] +"SecurityFeatures": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rideau" +"StreetNumber": "560" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month's rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "413" +"DDFYN": true +"Locker": "None" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935884')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "61402100108578" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Parking available for $225/month. Storage available for $50/month." +"LaundryLevel": "Main Level" +"LegalStories": "4" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Lower Town - Sandy Hill, ON K1N 5Z8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-03-30" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "As Per Floorplan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 6 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"ParkingMonthlyCost": 225.0 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "13" +"MediaChangeTimestamp": "2026-03-30T16:48:15Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "RICHCRAFT RENTAL LIMITED PARTNERSHIP" +"SystemModificationTimestamp": "2026-03-30T16:48:15.824209Z" +"Media": array:48 [ …48] +"ID": "702520" } ] +success: true +page_size: 10 +page_count: 5089 +count: 50885 +after_key: "" } "RF Response Time" => "0.36 seconds" ] "RF Cache Key: 2449a8c4faa9a4863e738c7a611998bfe2d869864da924c0e74a281c4b134c95" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3081 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4289 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "N12935772" +"ListingId": "N12935772" +"PropertyType": "Residential Lease" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:51:56Z" +"RFModificationTimestamp": "2026-05-02T06:49:26Z" +"ListPrice": 1850.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Vaughan" +"PostalCode": "L4H 1S9" +"UnparsedAddress": "67 Castillian Drive Lower, Vaughan, ON L4H 1S9" +"Coordinates": array:2 [ …2] +"Latitude": 43.81897 +"Longitude": -79.610023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REMAX YOUR COMMUNITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rarely Available Spacious Totally Turnkey Furnished Separate Apartment With Private Entrance In High Demand Sonoma Heights. Amazing Value. Plenty Of Lights And Oversized Windows Allow An Abundance Of Lighting. Walkout To Private Patio And Enjoy the Tranquil Garden. Friendly Safe Community & Close To Amenities, Transit & Shops. Apartment Is Above Ground With Full Above Grade Windows. 1 Parking Space. Tenant To Assume 33% Cost Of Utilities." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Sonoma Heights" +"CoListOfficeName": "REMAX YOUR COMMUNITY REALTY" +"CoListOfficePhone": "905-832-6656" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "York" +"CreationDate": "2026-04-16T20:40:27.093023+00:00" +"CrossStreet": "Rutherford Road and Clarence Street" +"DirectionFaces": "East" +"Directions": "Rutherford Road and Clarence Street" +"ExpirationDate": "2026-06-30" +"FoundationDetails": array:1 [ …1] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer. Home Is Super Clean And Neat" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "087000" +"MajorChangeTimestamp": "2026-03-30T16:31:46Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-03-30T16:31:46Z" +"OriginalListPrice": 1850.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738504" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-03-30T16:51:56Z" +"PoolFeatures": array:1 [ …1] +"RentIncludes": array:3 [ …3] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Castillian" +"StreetNumber": "67" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "Lower" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12935772')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 90 +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Vaughan, ON L4H 1S9, CA" +"ContractStatus": "Available" +"PossessionDate": "2026-04-26" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 3 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"CoListOfficeName3": "REMAX YOUR COMMUNITY REALTY" +"PossessionDetails": "April 26, 2026" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T16:51:56Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2026-03-30T16:51:59.767578Z" +"Media": array:7 [ …7] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4290 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12935638" +"ListingId": "X12935638" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:51:24Z" +"RFModificationTimestamp": "2026-05-02T22:08:14Z" +"ListPrice": 1300000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Fort Erie" +"PostalCode": "L2A 3H2" +"UnparsedAddress": "411 Niagara Boulevard, Fort Erie, ON L2A 3H2" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Two properties are offered for sale together. An exciting low-density residential proposal has been submitted to the Town to redesignate and rezone the combined parcels at 411 and 415 Niagara Boulevard, opening the door to a 15-unit townhouse community and a detached house. This prime location delivers both strong investment potential and exceptional lifestyle appeal.The property at 411 Niagara Boulevard features a spacious 4-bedroom, two-storey home with a large picture window showcasing breathtaking views of the Niagara River. With excellent Airbnb potential, you can choose to move into the existing home, generate short-term rental income, redevelop the site into a modern riverside community, or hold it as a valuable long-term asset. This is a rare opportunity to secure premium waterfront-adjacent real estate." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "332 - Central" +"CoListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"CoListOfficePhone": "905-338-3737" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-02T21:12:57.745708+00:00" +"CrossStreet": "Gilmore Rd & Niagara Blvd" +"DirectionFaces": "West" +"Directions": "Central Ave- Gilmore Rd- Niagara Blvd" +"ExpirationDate": "2026-06-30" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in dishwasher, fridge, stove, washer, dryer, all elfs, all window coverings" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-30" +"LotSizeSource": "MPAC" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2026-03-30T16:09:29Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:09:29Z" +"OriginalListPrice": 1300000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3731462" +"ParcelNumber": "642280181" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-03-30T16:09:29Z" +"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": "Niagara" +"StreetNumber": "411" +"StreetSuffix": "Boulevard" +"TaxAnnualAmount": "5965.0" +"TaxAssessedValue": 328000 +"TaxLegalDescription": "PT LT 33 W/S NIAGARA ST PL 525 VILLAGE OF BRIDGEBURG" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"WaterBodyName": "Niagara River" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Water" +"LotDepth": 531.75 +"LotShape": "Irregular" +"LotWidth": 80.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935638')" +"Shoreline": array:1 [ …1] +"WaterView": array:1 [ …1] +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "270301004603600" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"RentalItems": "Hot water heater" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 6 +"WaterBodyType": "River" +"provider_name": "TRREB" +"short_address": "Fort Erie, ON L2A 3H2, CA" +"ApproximateAge": "51-99" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"MortgageComment": "Clear" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 1 +"AccessToProperty": array:1 [ …1] +"PropertyFeatures": array:4 [ …4] +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "905-338-3737" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"WashroomsType5Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T16:09:29Z" +"SystemModificationTimestamp": "2026-03-30T16:51:32.332444Z" +"Media": array:41 [ …41] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4293 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12794370" +"ListingId": "X12794370" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:50:56Z" +"RFModificationTimestamp": "2026-05-02T06:50:44Z" +"ListPrice": 930000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kingston" +"PostalCode": "K7M 9E7" +"UnparsedAddress": "456 Weston Crescent, Kingston, ON K7M 9E7" +"Coordinates": array:2 [ …2] +"Latitude": 44.2538197 +"Longitude": -76.5466712 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD., BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 456 Weston Crescent - a beautifully maintained all-brick two-storey home offering exceptional space and versatility for families, multi-generational living, or investment potential. With seven bedrooms and numerous upgrades throughout, this home truly shows pride of ownership. The main floor features a formal living and dining room, along with a warm and inviting great room complete with a gas fireplace. The bright eat-in kitchen is designed for both everyday living and entertaining, offering a breakfast bar island with quartz countertops and ample workspace. Convenient main-floor laundry adds to the home's functionality. Upstairs, the oversized primary suite provides a private retreat with a luxurious 5-piece ensuite featuring a soaker tub. Three additional generously sized bedrooms and a full bath complete the upper level. The fully finished walkout lower level offers a separate entrance, three bedrooms, a full kitchen, and a bathroom, creating an ideal setup for extended family, older children, or rental income. Outside, enjoy a fully fenced backyard with two decks and no rear neighbours, providing a quiet and private outdoor space. Recent updates include soundproofing, triple-pane windows, roof, furnace, A/C, hot water tank, front and basement doors, lighting, and exhaust fans. Located in the sought-after Waterloo Village neighbourhood, close to Trillium Ridge Park, schools, shopping, downtown Kingston, and Hwy 401, this move-in-ready home offers incredible flexibility and value." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:5 [ …5] +"CityRegion": "35 - East Gardiners Rd" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Frontenac" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-16T20:43:07.125128+00:00" +"CrossStreet": "Waterloo Dr and Grandtrunk" +"DirectionFaces": "East" +"Directions": "Taylor Kidd to Waterloo to Grand trunk to Weston" +"ExpirationDate": "2026-05-31" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "DISHWASHER, DRYER, Garage Door opener, WATERTANK, RANGEHOOD, REFRIGERATOR, STOVE, WASHER" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Kingston & Area Real Estate Association" +"ListingContractDate": "2026-02-17" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "470900" +"MajorChangeTimestamp": "2026-02-17T18:35:02Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2026-02-17T18:35:02Z" +"OriginalListPrice": 930000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3553474" +"ParcelNumber": "360850721" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-02-17T18:35:03Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Weston" +"StreetNumber": "456" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "6028.24" +"TaxLegalDescription": "LOT 127, PLAN 13M26; S/T EASMNT PT 14, 13R15580 IN FAVOUR OF THE CORPORATION OF THE CITY OF KINGSTON AS IN LT28048; KINGSTON" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 125.04 +"LotShape": "Other" +"LotWidth": 31.61 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12794370')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "101108018612700" +"SurveyType": "Unknown" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Kingston, ON K7M 9E7, CA" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 3 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "24 Hours notice. Basement tenants" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-03-30T16:50:56Z" +"SystemModificationTimestamp": "2026-03-30T16:51:07.764526Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:47 [ …47] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4292 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12717994" +"ListingId": "X12717994" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:50:50Z" +"RFModificationTimestamp": "2026-05-02T06:50:40Z" +"ListPrice": 1299000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lakeshore" +"PostalCode": "N8N 4X9" +"UnparsedAddress": "150 Seymour Crescent, Lakeshore, ON N8N 4X9" +"Coordinates": array:2 [ …2] +"Latitude": 42.3067707 +"Longitude": -82.8196745 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Platinum Gate Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime location, unmatched curb appeal! This remarkable full stone and brick 2-storey residence is tucked away on a quiet cul-de-sac in the prestigious Orchard Park community. Thoughtfully custom-built for family living, it offers nearly 4,000 sq. ft. above grade, with 4 bedrooms, 3.5 bathrooms, a butlers pantry, and a private backyard featuring a covered porch and a heated saltwater in-ground pool. The home showcases a spectacular floor plan with soaring 18-ft ceilings in both the foyer and living room, a main-floor den with tray ceilings, a spacious primary suite with dual walk-in closets, convenient main-floor laundry, and a spotless 2.5-car garage. The main floor also includes two dens, either of which could serve as an additional bedroom. The fully finished basement adds even more living space with 2 bedrooms and a full bathroom." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Lakeshore" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Essex" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-26T13:48:12.199843+00:00" +"CrossStreet": "Orchard Park Drive & Seymour Crescent" +"DirectionFaces": "West" +"Directions": "Orchard Park Drive & Seymour Crescent" +"ExpirationDate": "2026-05-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-21" +"MainOfficeKey": "441900" +"MajorChangeTimestamp": "2026-01-21T18:45:46Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-01-21T18:45:46Z" +"OriginalListPrice": 1299000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3466240" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-03-30T16:50:50Z" +"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": "Seymour" +"StreetNumber": "150" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "7500.0" +"TaxLegalDescription": "LT 79 PL 12M340 MAIDSTONE" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotWidth": 57.81 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12717994')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Lakeshore, ON N8N 4X9, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 4 +"RoomsBelowGrade": 1 +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T16:50:50Z" +"SystemModificationTimestamp": "2026-03-30T16:51:00.31442Z" +"Media": array:39 [ …39] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4291 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12935906" +"ListingId": "X12935906" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:49:39Z" +"RFModificationTimestamp": "2026-05-02T06:50:59Z" +"ListPrice": 549900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Trent Hills" +"PostalCode": "K0L 1Y0" +"UnparsedAddress": "8 Church Lane, Trent Hills, ON K0L 1Y0" +"Coordinates": array:2 [ …2] +"Latitude": 44.210178 +"Longitude": -77.914391 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BALL REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this solid 2+1 bedroom brick bungalow, perfectly situated in a quiet, family-friendly residential neighborhood. This well-maintained home offers a functional layout with bright living space and plenty of versatility for a variety of lifestyles. The main level features two comfortable bedrooms, a spacious living area, and a practical kitchen ready for your personal touch. The finished lower level adds a third bedroom and offers excellent in-law suite potential, making it ideal for extended family or additional living space. Outside, you'll find even more to love with both an attached garage and a detached garage/workshop - perfect for hobbyists, storage, or extra parking. Enjoy the peace and privacy of this desirable location while still being close to local amenities. A fantastic opportunity for homeowners, investors, or those looking to customize a home to their needs." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Hastings" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Northumberland" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-16T20:43:09.087077+00:00" +"CrossStreet": "Water St" +"DirectionFaces": "East" +"Directions": "Water St to Church Lane" +"Exclusions": "Personal Possessions" +"ExpirationDate": "2026-06-30" +"ExteriorFeatures": array:4 [ …4] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:2 [ …2] +"GarageYN": true +"Inclusions": "Fridge, Stove, Washer, Dryer, Champion 6500 Generator, Electric Light Fixtures" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2026-03-30" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "333400" +"MajorChangeTimestamp": "2026-03-30T16:49:39Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-30T16:49:39Z" +"OriginalListPrice": 549900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738054" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "512130146" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2026-03-30T17:03:57Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Church" +"StreetNumber": "8" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "3646.0" +"TaxLegalDescription": "LT 30 PL 69 PERCY; TRENT HILLS" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% plus HST" +"TransactionType": "For Sale" +"View": array:2 [ …2] +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 55.95 +"LotWidth": 155.3 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935906')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "143533203011130" +"SurveyType": "None" +"Winterized": "Fully" +"ElectricYNA": "Yes" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"short_address": "Trent Hills, ON K0L 1Y0, CA" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-30" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-03-30T17:03:57Z" +"SystemModificationTimestamp": "2026-03-30T17:03:57.673093Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:28 [ …28] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4288 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12697628" +"ListingId": "X12697628" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:49:06Z" +"RFModificationTimestamp": "2026-05-03T04:08:45Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Windsor" +"PostalCode": "N9A 5H2" +"UnparsedAddress": "377 Elm Avenue, Windsor, ON N9A 5H2" +"Coordinates": array:2 [ …2] +"Latitude": 42.3029482 +"Longitude": -83.0448808 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Platinum Gate Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this well-maintained and versatile property featuring 6 bedrooms plus loft, 3 full washrooms, and 3 kitchens, offering excellent functionality and strong rental potential. The home includes a separate entrance to the basement, ideal for multi-generational living or investment use. Currently fully furnished and configured as a student rental, this property provides a turnkey opportunity. The layout is thoughtfully designed to maximize space and comfort, with multiple kitchens to accommodate shared living arrangements. Conveniently located within close proximity to the university, public transit, and everyday amenities, making it highly desirable for tenants. Additional highlights include parking for up to four vehicles. An excellent opportunity for investors or end-users seeking a property in a high-demand rental area." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Essex" +"CoveredSpaces": "1.0" +"CreationDate": "2026-05-02T21:11:26.164061+00:00" +"CrossStreet": "University Ave And Elm Ave" +"DirectionFaces": "West" +"Directions": "University Ave And Elm Ave" +"ExpirationDate": "2026-05-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"HeatingYN": true +"Inclusions": "All Beds, Wardrobes, And Kitchen/Kitchenette Appliances Cooktop, Microwave, Washer, Dryer, Central AC, Fridge & Stove" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-01-14" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "31.00 x 110.00 Feet" +"MainOfficeKey": "441900" +"MajorChangeTimestamp": "2026-01-14T22:59:42Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2026-01-14T22:59:42Z" +"OriginalListPrice": 549000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3432068" +"ParcelNumber": "012020267" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-03-30T16:49:06Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"RoomsTotal": "11" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Elm" +"StreetNumber": "377" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2032.0" +"TaxLegalDescription": "Pt Lot 36 Plan 638 Windsor; Pt Lot 37 Plan 638 Win" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.0 +"LotWidth": 31.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12697628')" +"PictureYN": true +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "373904018001000" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 3 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Windsor, ON N9A 5H2, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 3 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"AccessToProperty": array:1 [ …1] +"PropertyFeatures": array:5 [ …5] +"StreetSuffixCode": "Ave" +"BoardPropertyType": "Free" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 2 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-03-30T16:49:06Z" +"MLSAreaDistrictOldZone": "X01" +"MLSAreaMunicipalityDistrict": "Windsor" +"SystemModificationTimestamp": "2026-03-30T16:49:13.320443Z" +"Media": array:2 [ …2] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4287 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12935896" +"ListingId": "X12935896" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:54Z" +"RFModificationTimestamp": "2026-05-03T16:04:16Z" +"ListPrice": 2930.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lower Town - Sandy Hill" +"PostalCode": "K1N 5Z8" +"UnparsedAddress": "560 Rideau Street 704, Lower Town - Sandy Hill, ON K1N 5Z8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "DIGI BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "** UP TO 2 MONTH'S FREE RENT** Welcome to The Charlotte, a modern condo in the heart of Sandy Hill. This bright and efficiently designed 2-bedroom + den, 2-bathroom suite offers approximately 797 sq ft of functional living space with a well-appointed open-concept layout and contemporary finishes throughout.The kitchen, living, and dining area is thoughtfully designed with a large island offering seating and prep space-ideal for both everyday living and entertaining. This space is filled with natural light and provides access to multiple private balconies, creating seamless indoor-outdoor living and offering unique outdoor spaces rarely found in condo living.The versatile den is perfect for a home office or additional flex space. The primary bedroom features a private ensuite, while the second bedroom is well-sized and conveniently located near the second full bathroom. In-unit laundry adds to the everyday convenience.Residents enjoy exceptional amenities including a rooftop pool with expansive terrace and BBQ area, fully equipped fitness centre, yoga studio, party/meeting room, concierge service, guest suites, pet wash station, bike storage, and visitor parking.Located steps to the University of Ottawa, By Ward Market, Rideau Centre, transit, parks, and the Rideau Canal-ideal for professionals, investors, or downsizers seeking stylish urban living." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:6 [ …6] +"Basement": array:1 [ …1] +"BuildingName": "The Charlotte" +"CityRegion": "4003 - Sandy Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-05-02T21:13:52.304906+00:00" +"CrossStreet": "Rideau St & Cobourg St" +"Directions": "South side of Rideau Street between Friel Street & Augusta Street" +"Exclusions": "Hydro & Water billed separately." +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer & Dryer. A/C, Heat & Rogers WIFI included." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "486100" +"MajorChangeTimestamp": "2026-03-30T16:48:54Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:48:54Z" +"OriginalListPrice": 2930.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738756" +"ParcelNumber": "160980078" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T16:48:54Z" +"RentIncludes": array:4 [ …4] +"SecurityFeatures": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rideau" +"StreetNumber": "560" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month's rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "704" +"DDFYN": true +"Locker": "None" +"Exposure": "North West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935896')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "61402100108578" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Parking available for $225/month. Storage available for $50/month." +"LaundryLevel": "Main Level" +"LegalStories": "7" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Lower Town - Sandy Hill, ON K1N 5Z8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-03-30" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "As Per Floorplan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"ParkingMonthlyCost": 225.0 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "04" +"MediaChangeTimestamp": "2026-03-30T16:48:54Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "RICHCRAFT RENTAL LIMITED PARTNERSHIP" +"SystemModificationTimestamp": "2026-03-30T16:48:55.629887Z" +"Media": array:50 [ …50] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4286 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12935894" +"ListingId": "X12935894" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:45Z" +"RFModificationTimestamp": "2026-05-02T22:08:14Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9K 0H7" +"UnparsedAddress": "59 Robertson Road, Hamilton, ON L9K 0H7" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 59 Robertson Road, a well-kept family home in the heart of Meadowlands, one of the most desirable communities in Ancaster. This spacious 5-bedroom 3.5 bathrooms detached home offers a comfortable layout with plenty of room to grow, work, and relax.The main level features a bright, open feel with a welcoming entryway and a solid wood staircase that adds warmth and character. Large windows bring in plenty of natural light throughout the home. Upstairs, the bedrooms are generously sized, including a spacious primary retreat with room for a sitting area or workspace.The home sits on a quiet, family-friendly street surrounded by other well-maintained properties. The exterior offers great curb appeal with a brick and stone façade and a double car garage. The unfinished basement is ready for your personal touch with readily available architechtural drawings and a 3 piece bath rough-in. The backyard provides a private space to enjoy warmer months or entertain friends and family. Located close to top-rated schools, parks, shopping, and everyday amenities, with easy access to major highways and transit. Ancaster is known for its strong sense of community, great trails, and convenient access to both nature and city life. A solid home in a sought-after location, perfect for families looking to settle into a mature, established neighbourhood." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Meadowlands" +"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"CoListOfficePhone": "905-568-2121" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-02T21:12:29.201045+00:00" +"CrossStreet": "Garner / Raymond Rd" +"DirectionFaces": "North" +"Directions": "Garner" +"ExpirationDate": "2026-09-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Washer, Dryer, Dishwasher, Microwave, Fridge, Stove" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-28" +"LotSizeSource": "MPAC" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2026-03-30T16:48:45Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-30T16:48:45Z" +"OriginalListPrice": 1100000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3734892" +"ParcelNumber": "175655188" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-03-30T16:48:45Z" +"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": "Robertson" +"StreetNumber": "59" +"StreetSuffix": "Road" +"TaxAnnualAmount": "8238.91" +"TaxLegalDescription": "LOT 150, PLAN 62M1237 TOGETHER WITH AN EASEMENT OVER BLKS 321, 338 & 340, PL 62M1158 AS IN WE766983 TOGETHER WITH AN EASEMENT OVER BLK 321, PL 62M1158 AS IN WE766983 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1187002 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1191716 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1291257 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% plus hst" +"TransactionType": "For Sale" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 30.59 +"LotWidth": 12.2 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935894')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251814028038833" +"SurveyType": "Unknown" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L9K 0H7, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 3 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 7 +"LotSizeAreaUnits": "Square Meters" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2026-03-30T16:48:45Z" +"SystemModificationTimestamp": "2026-03-30T16:48:45.445179Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:28 [ …28] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4285 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12935892" +"ListingId": "X12935892" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:35Z" +"RFModificationTimestamp": "2026-05-03T16:04:16Z" +"ListPrice": 3130.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lower Town - Sandy Hill" +"PostalCode": "K1N 5Z8" +"UnparsedAddress": "560 Rideau Street 703, Lower Town - Sandy Hill, ON K1N 5Z8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "DIGI BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "** UP TO 2 MONTH'S FREE RENT** Welcome to The Charlotte, a modern condo in the heart of Sandy Hill. This bright and well-designed 2-bedroom + den, 2-bathroom suite offers approximately 847 sq ft of functional living space with a smart, open-concept layout and contemporary finishes throughout. The main living area features a spacious kitchen and living/dining combination with a large island offering seating and prep space-ideal for entertaining. The living area is filled with natural light and provides direct access to a private balcony, creating seamless indoor-outdoor living. The primary bedroom includes a private ensuite, while the second bedroom is complemented by its own balcony-offering added light and outdoor access. The separate den is perfect for a home office or flex space. A second full bathroom and in-unit laundry provide everyday convenience. Residents enjoy exceptional amenities including a rooftop pool with expansive terrace and BBQ area, fully equipped fitness centre, yoga studio, party/meeting room, concierge service, guest suites, pet wash station, bike storage, and visitor parking. Located steps to the University of Ottawa, By Ward Market, Rideau Centre, transit, parks, and the Rideau Canal-ideal for professionals, investors, or downsizers seeking stylish urban living." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:6 [ …6] +"Basement": array:1 [ …1] +"BuildingName": "The Charlotte" +"CityRegion": "4003 - Sandy Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-05-02T21:14:07.452317+00:00" +"CrossStreet": "Rideau St & Cobourg St" +"Directions": "South side of Rideau Street between Friel Street & Augusta Street" +"Exclusions": "Hydro & Water billed separately." +"ExpirationDate": "2026-06-30" +"Furnished": "Unfurnished" +"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Washer & Dryer. A/C, Heat & Rogers WIFI included." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"LeaseTerm": "12 Months" +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-03-30" +"MainOfficeKey": "486100" +"MajorChangeTimestamp": "2026-03-30T16:48:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-03-30T16:48:35Z" +"OriginalListPrice": 3130.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3738242" +"ParcelNumber": "160980078" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2026-03-30T16:48:35Z" +"RentIncludes": array:4 [ …4] +"SecurityFeatures": array:3 [ …3] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rideau" +"StreetNumber": "560" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 month's rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "703" +"DDFYN": true +"Locker": "None" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12935892')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "61402100108578" +"SurveyType": "None" +"BalconyType": "Open" +"RentalItems": "Parking available for $225/month. Storage available for $50/month." +"LaundryLevel": "Main Level" +"LegalStories": "7" +"ParkingType1": "None" +"CreditCheckYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Lower Town - Sandy Hill, ON K1N 5Z8, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"PossessionDate": "2026-03-30" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DepositRequired": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 1 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ …6] +"SquareFootSource": "As Per Floorplan" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"ParkingMonthlyCost": 225.0 +"SpecialDesignation": array:1 [ …1] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "03" +"MediaChangeTimestamp": "2026-03-30T16:48:35Z" +"PortionPropertyLease": array:1 [ …1] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "RICHCRAFT RENTAL LIMITED PARTNERSHIP" +"SystemModificationTimestamp": "2026-03-30T16:48:36.149575Z" +"Media": array:50 [ …50] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4284 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12935884" +"ListingId": "X12935884" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T16:48:15Z" +"RFModificationTimestamp": "2026-05-03T16:04:16Z" +"ListPrice": 2725.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Lower Town - Sandy Hill" +"PostalCode": "K1N 5Z8" +"UnparsedAddress": "560 Rideau Street 413, Lower Town - Sandy Hill, ON K1N 5Z8" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "DIGI BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "** UP TO 2 MONTH'S FREE RENT** Welcome to The Charlotte, a modern condo in the heart of Sandy Hill. This bright and well-designed 2-bedroom, 2-bathroom suite offers approximately 777 sq ft of functional living space with a smart, open-concept layout and contemporary finishes throughout. The main living area features a spacious kitchen and living/dining combination with a large island offering seating and prep space-ideal for entertaining. The kitchen/dining area is filled with natural light and provides access to a private balcony, perfect for morning coffee or evening relaxation. The primary bedroom features a walk-in closet, private ensuite, and its own balcony-creating a comfortable and private retreat. The second bedroom is thoughtfully positioned on the opposite side of the unit for added privacy. A second full bathroom and in-unit laundry provide everyday convenience. Residents enjoy exceptional amenities including a rooftop pool with expansive terrace and BBQ area, fully equipped fitness centre, yoga studio, party/meeting room, concierge service, guest suites, pet wash station, bike storage, and visitor parking. Located steps to the University of Ottawa, By Ward Market, Rideau Centre, transit, parks, and the Rideau Canal-ideal for professionals, investors, or downsizers seeking stylish urban living." +"AccessibilityFeatures": array:1 [ …1] +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:6 [ …6] +"Basement": array:1 [ …1] +"BuildingName": "The Charlotte" +"CityRegion": "4003 - Sandy Hill" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-05-02T21:14:00.996026+00:00" …87 } ] +success: true +page_size: 10 +page_count: 5089 +count: 50885 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4277 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4087 …136} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4088 …125} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4089 …125} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4090 …130} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4091 …132} ] +success: true +page_size: 5 +page_count: 10177 +count: 50884 +after_key: "" } ] ]