Fullscreen
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=79650&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=79650&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=79650&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=79650&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#12530 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12524 +post_id: "117448" +post_author: 1 +"ListingKey": "X11935315" +"ListingId": "X11935315" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:51:31Z" +"RFModificationTimestamp": "2025-04-18T13:06:26.028595+00:00" +"ListPrice": 750000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Southgate" +"PostalCode": "N0C 1B0" +"UnparsedAddress": "25 Corbett Street, Southgate, On N0c 1b0" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover the ideal starter family home in one of Southgates most sought-after neighbourhoods! Perfectly situated, this property offers unparalleled convenience with easy access to Grey Bruce Trails, Owen Sound, Collingwood, ski hills, golf courses, the Markdale hospital, Dundalk Community Center, and local amenities including Foodland, restaurants, and downtown Dundalk.This stunning home features a thoughtfully designed modern open-concept layout, complete with 4 spacious bedrooms, 3.5 bathrooms, and a 2-car garage. Impeccable top-of-the-line finishes create a sophisticated and contemporary aesthetic, providing both style and functionality for your family. Don't miss this opportunity to embrace a lifestyle of comfort and convenience in a highly desirable location. Your dream home awaits at 25 Corbett Street! **EXTRAS** Property is being sold under power of sale in as-is, where-is condition" +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Southgate" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Grey County" +"CoveredSpaces": "2.0" +"CreationDate": "2025-01-23T07:55:33.961736+00:00" +"CrossStreet": "Main St/Dundalk St" +"DirectionFaces": "South" +"Exclusions": "Existing Belongings" +"ExpirationDate": "2025-04-30" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Inclusions": "Existing appliances such as stove, dishwasher, fridge, washer and dryer" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2025-01-22T15:08:01Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-22T15:08:02Z" +"OriginalListPrice": 750000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1884126" +"ParcelNumber": "372670500" +"ParkingFeatures": "Available" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-01-22T15:08:02Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"Sewer": "Other" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Corbett" +"StreetNumber": "25" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5760.0" +"TaxLegalDescription": "LOT 50, PLAN 16M85 SUBJECT TO AN EASEMENT FOR ENTRY AS IN GY243616 TOWNSHIP OF SOUTHGATE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 96.42 +"LotWidth": 41.01 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11935315')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RentalItems": "Hot water tank" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"RoomsAboveGrade": 11 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2025-01-22T15:08:02Z" +"SystemModificationTimestamp": "2025-04-12T15:03:29.709491Z" +"Media": array:15 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] ] +"ID": "117448" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12526 +post_id: "118433" +post_author: 1 +"ListingKey": "X11934878" +"ListingId": "X11934878" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:49:49Z" +"RFModificationTimestamp": "2025-04-18T13:06:26.759781+00:00" +"ListPrice": 859900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N3W 0E6" +"UnparsedAddress": "19 Rainbow Drive, Haldimand, On N3w 0e6" +"Coordinates": array:2 [ 0 => -79.927644001684 1 => 43.076101423815 ] +"Latitude": 43.076101423815 +"Longitude": -79.927644001684 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "YOUR HOME SOLD GUARANTEED REALTY - THE ELITE REALTY GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Its HERE! The Moment You Walk In The Grand Foyer Entryway, It Feels Like Home. This Stunning Rosebery Model Home Is Situated In A Growing Family-Friendly Neighbourhood in Caledonia. Its Only 4 Years Old And Approx 2313 Sqft. This Bright, Beautiful Home Is An Entertainers Delight With An Open Concept Kitchen And Living Room. The Kitchen Includes Stainless Steel Appliances, A Breakfast Bar And Walk-Out Access To The Backyard Deck! The Second Level Boasts 4 Spacious Bedrooms. The Huge Primary Bedroom Includes A Luxurious Private Spa-Like 5Pc Ensuite & His/Hers Walk-In Closets. All Bedrooms Feature Large Windows For Tons Of Natural Light. Unfinished Full Basement Has The Opportunity And Potential For Home Growth And Personal Touch. Walking Distance From Park, Trails And Within Close Proximity To Schools, Hospitals, Shopping Destinations And The Grand River. Hurry, Come See For Yourself, It Won't Last! **EXTRAS** SS Fridge, SS Stove, SS Dishwasher, Washer & Dryer. All Light Fixtures Included. All Appliances As Is." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Haldimand" +"CoveredSpaces": "2.0" +"CreationDate": "2025-01-22T05:06:07.888576+00:00" +"CrossStreet": "Mcclung Rd And Rainbow Dr" +"DirectionFaces": "North" +"Exclusions": "Freezer In Garage" +"ExpirationDate": "2025-06-30" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "SS Fridge, SS Stove, SS Dishwasher, Washer & Dryer. All Light Fixtures Included. All Appliances As Is." +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "268700" +"MajorChangeTimestamp": "2025-01-31T23:16:33Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-22T03:27:17Z" +"OriginalListPrice": 769900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1837814" +"ParcelNumber": "381551196" +"ParkingFeatures": "Private Double" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-01-22T03:27:18Z" +"PoolFeatures": "None" +"PreviousListPrice": 769900.0 +"PriceChangeTimestamp": "2025-01-31T23:16:33Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rainbow" +"StreetNumber": "19" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5632.76" +"TaxLegalDescription": "LOT 9, PLAN 18M60 SUBJECT TO AN EASEMENT FOR ENTRY AS IN CH113525 HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/19_rainbow_dr_haldimand_on/" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 91.86 +"LotWidth": 33.14 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934878')" +"GarageType": "Attached" +"HeatSource": "Gas" +"ElectricYNA": "Yes" +"RentalItems": "HWT" +"HoldoverDays": 120 +"LaundryLevel": "Upper Level" +"TelephoneYNA": "Yes" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 10 +"SalesBrochureUrl": "https://youriguide.com/19_rainbow_dr_haldimand_on/" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 5 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-01-22T03:27:18Z" +"SystemModificationTimestamp": "2025-02-14T19:49:49.406204Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] +"ID": "118433" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12523 +post_id: "127664" +post_author: 1 +"ListingKey": "X11934811" +"ListingId": "X11934811" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:49:19Z" +"RFModificationTimestamp": "2025-03-30T11:15:26.162502+00:00" +"ListPrice": 410000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "South Glengarry" +"PostalCode": "K0C 1E0" +"UnparsedAddress": "21255 Mc Naughton Court, South Glengarry, On K0c 1e0" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK REALTY GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Creg Quay Estates, a serene, adult-only private community nestled along the stunning shores of Lake St. Francis in Ontario. Ideally located just 5 kilometers from the Quebec/Ontario border with easy access to Highway 401, this charming semi-detached home combines tranquil living with exceptional convenience.This home features 2 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, offering functionality and comfort. Located on a private street just steps from the canal, it provides the perfect blend of privacy and community.Creg Quay Estates is renowned for its vibrant yet peaceful atmosphere, offering exceptional amenities like a heated saltwater pool, tennis and pickleball courts, a community centre, and beautifully landscaped gardens. Outdoor enthusiasts will enjoy the shuffleboard, bocce, and horseshoe pits, along with the community docks for water activities. Residents often gather for social events, creating a strong sense of community and belonging.The community is managed by the non-profit Quay Estates Residents' Association (QERA), ensuring a welcoming and well-maintained environment. Residents agree to By-Laws to preserve the communitys charm and foster a strong social network. This cooperative spirit is evident in the meticulous care of the surroundings and the vibrant atmosphere that makes Creg Quay so special.With an HOA fee of $315/month, services include road and common area maintenance, water, sewer, driveway snow removal, clubhouse upkeep, and caretaker services. Lawn care is available at an additional cost, offering further convenience for homeowners. This low-maintenance lifestyle is ideal for snowbirds or retirees seeking comfort and ease, allowing residents to focus on enjoying their leisure time. Its proximity to natural beauty, combined with modern amenities and a convenient location, makes it a sought-after destination for those seeking the best of both worlds. Dont miss this rare gem to make it yours! **EXTRAS** Recent upgrades: Roof from last year, renovated kitchen in the last 3 years, new furnace & heatpump changed in the last 2 years, updated water softener." +"ArchitecturalStyle": "Bungalow" +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "724 - South Glengarry (Lancaster) Twp" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Stormont, Dundas and Glengarry" +"CreationDate": "2025-01-22T06:06:42.725548+00:00" +"CrossStreet": "Located only 5 kms from the Quebec/Ontario border on Hwy 401. From exit 825 on 401 go on service rd to Creg Quay Estates. Located At 35 Minutes From The Faiview Shopping Centre" +"DirectionFaces": "North" +"Exclusions": "Dishwasher, Washer, Dryer, Microwave and All personal items and furniture belonging to the tenant" +"ExpirationDate": "2025-07-10" +"ExteriorFeatures": "Patio,Privacy" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Appliances including Fridge & Stove & Water Softener" +"InteriorFeatures": "Carpet Free,Primary Bedroom - Main Floor,Propane Tank,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2025-01-16" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "504300" +"MajorChangeTimestamp": "2025-01-22T01:16:08Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-22T01:16:08Z" +"OriginalListPrice": 410000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1888136" +"ParcelNumber": "671360464" +"ParkingFeatures": "Private,Tandem" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-01-22T01:16:08Z" +"PoolFeatures": "Inground" +"Roof": "Asphalt Shingle" +"SeniorCommunityYN": true +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mc Naughton" +"StreetNumber": "21255" +"StreetSuffix": "Court" +"TaxAnnualAmount": "2208.0" +"TaxLegalDescription": "LT 7 PL 156; SOUTH GLENGARRY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"WaterBodyName": "St. Lawrence River" +"WaterSource": array:1 [ 0 => "Comm Well" ] +"WaterfrontFeatures": "Dock,Marina Services,River Access" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 109.94 +"LotWidth": 27.98 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934811')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "010100100332909" +"Waterfront": array:2 [ 0 => "Indirect" 1 => "Waterfront Community" ] +"RentalItems": "Propane Tank" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Propane Tank" ] +"WaterBodyType": "River" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PossessionDate": "2025-04-01" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 3 +"AccessToProperty": array:2 [ 0 => "Marina Docking" 1 => "Private Road" ] +"PropertyFeatures": array:6 [ 0 => "Beach" 1 => "Cul de Sac/Dead End" 2 => "Lake Access" 3 => "Marina" 4 => "Rec./Commun.Centre" 5 => "Waterfront" ] +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 1 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-01-22T01:16:08Z" +"SystemModificationTimestamp": "2025-02-28T23:25:46.964136Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] ] +"ID": "127664" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12527 +post_id: "246129" +post_author: 1 +"ListingKey": "W11973628" +"ListingId": "W11973628" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:48:14Z" +"RFModificationTimestamp": "2025-03-30T14:36:18.234108+00:00" +"ListPrice": 21.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 4491.0 +"City": "Burlington" +"PostalCode": "L7N 3V1" +"UnparsedAddress": "860 Cumberland Avenue, Burlington, On L7n 3v1" +"Coordinates": array:2 [ 0 => -79.791469 1 => 43.3559887 ] +"Latitude": 43.3559887 +"Longitude": -79.791469 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great location for your company's home office . Upgraded finishes, large offices and common space open deck to outside on second floor. Worththe look you wont be disappointed. Offers lots of parking. Many uses permitted." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Industrial Burlington" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Halton" +"CreationDate": "2025-03-30T11:15:35.905427+00:00" +"CrossStreet": "Harvester Rd & Cumberland Ave" +"ExpirationDate": "2025-04-30" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-02-10" +"LotSizeSource": "MPAC" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2025-02-14T19:48:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-02-14T19:48:14Z" +"OriginalListPrice": 21.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1960566" +"ParcelNumber": "070570163" +"PhotosChangeTimestamp": "2025-02-14T19:48:14Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cumberland" +"StreetNumber": "860" +"StreetSuffix": "Avenue" +"TaxYear": "2024" +"TransactionBrokerCompensation": "4% and 2%" +"TransactionType": "For Lease" +"Utilities": "Yes" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/860_cumberland_avenue_burlington_on/" +"Zoning": "GE1-334" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotWidth": 329.3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W11973628')" +"GarageType": "Outside/Surface" +"PropertyUse": "Office" +"ElevatorType": "Public" +"HoldoverDays": 30 +"ListPriceUnit": "Sq Ft Gross" +"provider_name": "TRREB" +"short_address": "Burlington, ON L7N 3V1, CA" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"PossessionDetails": "Immediate" +"OfficeApartmentArea": 4491.0 +"MediaChangeTimestamp": "2025-03-17T20:50:01Z" +"MaximumRentalMonthsTerm": 24 +"MinimumRentalTermMonths": 24 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-03-22T08:25:23.186463Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] ] +"ID": "246129" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12525 +post_id: "123364" +post_author: 1 +"ListingKey": "X11934578" +"ListingId": "X11934578" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:47:48Z" +"RFModificationTimestamp": "2025-03-30T11:16:14.784079+00:00" +"ListPrice": 3000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1360.0 +"City": "Orleans - Convent Glen And Area" +"PostalCode": "K1C 1G3" +"UnparsedAddress": "2585 St.joseph Boulevard, Orleans Convent Glenand Area, On K1c 1g3" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER SARAZEN REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "NO MORE SHOWINGS.....PLACE LEASED.. **EXTRAS** COMMON AREA EXPENSES..$1150 PER MONTH" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Retail Store Related" ] +"CityRegion": "2007 - Convent Glen South" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2025-01-22T12:18:56.277311+00:00" +"CrossStreet": "BELCOURT" +"ExpirationDate": "2025-05-30" +"Inclusions": "AS IS CONDITION" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2025-01-20" +"MainOfficeKey": "484800" +"MajorChangeTimestamp": "2025-01-21T21:28:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-21T21:28:40Z" +"OriginalListPrice": 3000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1887098" +"PhotosChangeTimestamp": "2025-01-22T16:49:11Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "ST.JOSEPH" +"StreetNumber": "2585" +"StreetSuffix": "Boulevard" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1/2 MO.RENT" +"TransactionType": "For Lease" +"Utilities": "Yes" +"Zoning": "AM3" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "N/A" +"HeatType": "Gas Forced Air Closed" +"LotDepth": 100.0 +"LotWidth": 100.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934578')" +"GarageType": "Outside/Surface" +"RetailArea": 1360.0 +"PropertyUse": "Retail" +"RentalItems": "HOT WATER TANK" +"HoldoverDays": 120 +"ListPriceUnit": "Month" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-01-24" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"ClearHeightFeet": 18 +"PossessionDetails": "TBA" +"MediaChangeTimestamp": "2025-01-22T16:49:11Z" +"HandicappedEquippedYN": true +"MaximumRentalMonthsTerm": 36 +"MinimumRentalTermMonths": 12 +"PropertyManagementCompany": "LANDLORD" +"SystemModificationTimestamp": "2025-03-23T17:24:53.707019Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] ] +"ID": "123364" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12522 +post_id: "128130" +post_author: 1 +"ListingKey": "X11934422" +"ListingId": "X11934422" +"PropertyType": "Commercial Sale" +"PropertySubType": "Store W Apt/Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:47:00Z" +"RFModificationTimestamp": "2025-04-18T13:06:29.044037+00:00" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1500.0 +"City": "Niagara Falls" +"PostalCode": "L2E 4C8" +"UnparsedAddress": "5002 Victoria Avenue, Niagara Falls, On L2e 4c8" +"Coordinates": array:2 [ 0 => -79.0729174 1 => 43.101787825 ] +"Latitude": 43.101787825 +"Longitude": -79.0729174 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Sale of Building. Attention Investors! Fantastic Opportunity To Own A Turn Key Mixed Use Commercial Building In The Heart Of Niagara Falls Tourist District With GC Zoning. The Building Offers A Wonderful Ground Floor Retail Space Currently Set Up As A Pharmacy Along With 3 Separate One Bedroom Apartment Units, Each With Their Own Kitchen & Bathrooms. Retail Space & 3Apartment Units Offer Great Rental Income For Long Term Lease Or Year Round Airbnb Opportunities That Can Offer A Cash Flow Positive Investment. All Units Have Been Recently Renovated & Have Hydro Metered Separately. Current Lease In Place For Roof Signage Company For Additional Income. Conveniently Located Close To The Falls, Clifton Hill Tourist Area, Casino, Restaurants & Entertainment, University of Niagara Falls Canada. Easy Access To QEW Highway & Walking Distance To Niagara Falls GO Station. Schedule A Showing Today! **EXTRAS** All Existing Furniture And Equipment In Retail and Residential Units. Buyer To Assume Existing Signage Lease." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "210 - Downtown" +"Cooling": "Partial" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2025-01-22T19:41:20.346394+00:00" +"CrossStreet": "Victoria Ave/Falls Ave" +"ExpirationDate": "2025-08-31" +"Inclusions": "Please Contact Listing Agent For Full List." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2025-01-21T20:31:27Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-21T20:31:27Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1866394" +"PhotosChangeTimestamp": "2025-01-21T20:31:27Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Victoria" +"StreetNumber": "5002" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4252.0" +"TaxLegalDescription": "PT LT 33 PL 276 TOWN OF NIAGARA FALLS AS IN BB8193" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + hst" +"TransactionType": "For Sale" +"Utilities": "Available" +"Zoning": "GC" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Other" +"LotDepth": 150.0 +"LotWidth": 20.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934422')" +"GarageType": "None" +"RetailArea": 300.0 +"PropertyUse": "Store With Apt/Office" +"ElevatorType": "None" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "Included" ] +"PossessionDate": "2025-01-13" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "Flexible" +"OfficeApartmentArea": 1200.0 +"MediaChangeTimestamp": "2025-01-21T20:31:27Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-03-12T13:46:20.256948Z" +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] +"ID": "128130" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12521 +post_id: "127308" +post_author: 1 +"ListingKey": "X11934370" +"ListingId": "X11934370" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:46:36Z" +"RFModificationTimestamp": "2025-04-18T13:06:30.036921+00:00" +"ListPrice": 539900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 1H8" +"UnparsedAddress": "#806 - 150 Main Street, Hamilton, On L8p 1h8" +"Coordinates": array:2 [ 0 => -114.1555462 1 => 46.2472045 ] +"Latitude": 46.2472045 +"Longitude": -114.1555462 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX GOLD REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "First Time Home Buyers Dream or Great Income Generator for Investors! "CALL HOME" 150 Main St W 806 In The Heart Of Downtown Hamilton. Minutes away from Mc Master University, Mohawk College, Hospitals, GO Transit, Shopping Malls, First Ontario Centre, Hwy 403 and Just Steps from PUBLIC TRANSPORT. Enjoy Living In The Spacious, 9Ft Ceiling, Elegantly Upgraded, Open Concept Layout & A Modern Kitchen With Granite Counter top, S/S Appliances, Backsplash, Ensuite Laundry, A Sun Filled Living Room And Walk Out To A Spacious Balcony. Primary Bed Has A Luxurious Ensuite Washroom & A Walk-In Closet. Your Urban Living Experience Is Further Enhanced By The State-of-the-Art Gym, Indoor Swimming Pool, BBQ Courtyard, Social/Party Rooms With Full Kitchen. A Great Living Experience For Professionals, Families and Investors! Showings Available from 9:00am to 9:00pm **EXTRAS** All the furniture can be bought along with the apartment for $2000" +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:6 [ 0 => "BBQs Allowed" 1 => "Concierge" 2 => "Exercise Room" 3 => "Gym" 4 => "Indoor Pool" 5 => "Media Room" ] +"AssociationFee": "638.92" +"AssociationFeeIncludes": array:5 [ 0 => "Heat Included" 1 => "Water Included" 2 => "CAC Included" 3 => "Common Elements Included" 4 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Central" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Concrete" ] +"Cooling": "Central Air" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-22T07:06:24.943089+00:00" +"CrossStreet": "CAROLINE ST & MAIN ST W" +"ExpirationDate": "2025-06-20" +"Inclusions": "Stainless Steel Fridge, Stove, Microwave, Dishwasher & Washer & Dryer, All Window Blinds." +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "187100" +"MajorChangeTimestamp": "2025-01-21T20:09:03Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-21T20:09:03Z" +"OriginalListPrice": 539900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1886496" +"ParkingFeatures": "None" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-01-21T20:09:03Z" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Main" +"StreetNumber": "150" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4100.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3%" +"TransactionType": "For Sale" +"UnitNumber": "806" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934370')" +"GarageType": "Underground" +"HeatSource": "Gas" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "9" +"ParkingType1": "None" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"PossessionDate": "2025-01-31" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 543 +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:5 [ 0 => "Hospital" 1 => "Library" 2 => "Park" 3 => "Public Transit" 4 => "Rec./Commun.Centre" ] +"SquareFootSource": "As per builder" +"PossessionDetails": "IMMEDIATE" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2025-01-21T20:09:03Z" +"PropertyManagementCompany": "FIRST SERVICE RESIDENTIAL" +"SystemModificationTimestamp": "2025-02-14T19:46:36.635072Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] +"ID": "127308" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12528 +post_id: "128229" +post_author: 1 +"ListingKey": "X11934304" +"ListingId": "X11934304" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:46:06Z" +"RFModificationTimestamp": "2025-03-30T11:15:32.506239+00:00" +"ListPrice": 1600.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 860.0 +"City": "Quinte West" +"PostalCode": "K8V 4A1" +"UnparsedAddress": "#2 - 20 Joseph Street, Quinte West, On K8v 4a1" +"Coordinates": array:2 [ 0 => -77.5748551 1 => 44.0988246 ] +"Latitude": 44.0988246 +"Longitude": -77.5748551 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "UNIT AVAILABLE FOR LEASE IN A FREESTANDING COMMERCIAL BUILDING FOR General OFFICE AND MEDICAL USE , RENT IS 1600+HST PER MONTH INCLUDES HEAT HYDRO WATER. **EXTRAS** RENT IS 1600+HST PER MONTH INCLUDES HEAT HYDRO WATER." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Medical/Dental" ] +"CityRegion": "Trenton Ward" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Hastings" +"CreationDate": "2025-01-22T23:36:44.164520+00:00" +"CrossStreet": "Joseph & Queen St" +"ExpirationDate": "2025-05-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2025-01-21T19:47:17Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-21T19:47:17Z" +"OriginalListPrice": 1600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1886802" +"ParcelNumber": "403920091" +"PhotosChangeTimestamp": "2025-01-21T19:47:17Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": "Sanitary" +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Joseph" +"StreetNumber": "20" +"StreetSuffix": "Street" +"TaxYear": "2024" +"TransactionBrokerCompensation": "Half Month Rent" +"TransactionType": "For Lease" +"UnitNumber": "2" +"Utilities": "Available" +"Zoning": "R4" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "N/A" +"Expenses": "Estimated" +"HeatType": "Electric Forced Air" +"LotDepth": 132.0 +"LotWidth": 127.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934304')" +"GarageType": "Outside/Surface" +"PropertyUse": "Office" +"RentalItems": "HOT WATER TANK" +"ElevatorType": "None" +"HoldoverDays": 90 +"ListPriceUnit": "Month" +"provider_name": "TRREB" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-02-01" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "%" +"WashroomsType1": 1 +"ClearHeightFeet": 8 +"PercentBuilding": "20" +"PossessionDetails": "TBD" +"IndustrialAreaCode": "%" +"OfficeApartmentArea": 860.0 +"MediaChangeTimestamp": "2025-01-21T19:47:17Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 24 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-03-25T19:38:10.084612Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:8 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] ] +"ID": "128229" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12529 +post_id: "108589" +post_author: 1 +"ListingKey": "X9412589" +"ListingId": "X9412589" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:45:42Z" +"RFModificationTimestamp": "2025-04-18T13:06:31.164435+00:00" +"ListPrice": 1199900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 4589.0 +"City": "Kingston" +"PostalCode": "K7P 0B2" +"UnparsedAddress": "876 Roshan Drive, Kingston, On K7p 0b2" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Finest Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover unparalleled craftsmanship and refined living in this stunning 4-bedroom, 3-bath, executive bungalow. Built in 2020, this residence blends timeless elegance with modern luxury, sitting gracefully on a corner lot across from a park in the sought-after Westbrook community of Kingston. From the moment you step through the grand tiled entryway, you're welcomed into an impressive great room boasting a soaring cathedral ceiling and a striking stone fireplace, creating a perfect backdrop for both intimate family gatherings and large-scale entertaining. The open-concept design effortlessly connects the living room, dining area, and breakfast nook with the gourmet kitchen - truly a chef's dream. Featuring expansive quartz countertops, abundant cabinetry, and top-tier appliances, this kitchen is as functional as it is beautiful. The principal bedroom suite offers a private retreat, complete with a cozy lounging area, a luxurious five-piece marble ensuite, and a spacious walk-in closet with a dedicated dressing area. Downstairs, the newly completed lower level serves as an ideal in-law suite or independent living space. With a separate entrance through the two-car garage, this bright and airy area includes a large recreation room, kitchenette/wet bar, two generously-sized bedrooms, a full bath, and a dedicated gym/activity space - perfect for multi-generational living or accommodating guests. Located near top-rated schools, with quick access to the 401, and just minutes from all the conveniences of Kingston's west end, this home offers an unmatched blend of luxury, comfort, and practicality." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "42 - City Northwest" +"CoListOfficeName": "RE/MAX Finest Realty Inc., Brokerage" +"CoListOfficePhone": "(613) 389-7777" +"ConstructionMaterials": array:2 [ 0 => "Board & Batten" 1 => "Stone" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Frontenac" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T15:20:01.007609+00:00" +"CrossStreet": "Princess Street, north on Westbrook Road, west on Roshan." +"DirectionFaces": "West" +"Directions": "Princess Street, north on Westbrook Road, west on Roshan." +"Exclusions": "Steam Punk floor to ceiling lamp in office." +"ExpirationDate": "2025-04-30" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Smoke Detector, Stove, Washer" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Kingston & Area Real Estate Association" +"ListingContractDate": "2024-10-01" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "112.53 x 74.34" +"LotSizeSource": "Survey" +"MainOfficeKey": "470300" +"MajorChangeTimestamp": "2024-12-02T19:48:21Z" +"MlsStatus": "Extension" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-01T16:02:12Z" +"OriginalListPrice": 1199900.0 +"OriginatingSystemID": "kar" +"OriginatingSystemKey": "40656241" +"ParcelNumber": "362650351" +"ParkingFeatures": "Private Double" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T03:47:28Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "16" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "kar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ROSHAN" +"StreetNumber": "876" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "8269.81" +"TaxAssessedValue": 590000 +"TaxBookNumber": "101108022001628" +"TaxLegalDescription": "LOT 8, PLAN 13M89 CITY OF KINGSTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=xy SBpq WY9io" +"Zoning": "UR1.A" +"DDFYN": true +"Water": "Municipal" +"Exposure": "East" +"HeatType": "Forced Air" +"LotDepth": 112.53 +"LotWidth": 74.34 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9412589')" +"GarageType": "Attached" +"HeatSource": "Gas" +"Waterfront": array:1 [ 0 => "None" ] +"HoldoverDays": 30 +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 7 +"UnavailableDate": "2024-12-02" +"SalesBrochureUrl": "https://propertyperspectives.ca/branded_pages/876roshandrive/" +"SquareFootSource": "Plans" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2024-11-17T03:47:28Z" +"ExtensionEntryTimestamp": "2024-12-02T19:48:21Z" +"SystemModificationTimestamp": "2025-03-31T14:02:18.724419Z" +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] +"ID": "108589" } ] +success: true +page_size: 9 +page_count: 11684 +count: 105156 +after_key: "" } "RF Response Time" => "0.4 seconds" ] "RF Cache Key: b1cc1621b7d0b7a025577bedcd7f6801eff855b38bdad1bf9707c4ea3c72ff3d" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#12758 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12545 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11935315" +"ListingId": "X11935315" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:51:31Z" +"RFModificationTimestamp": "2025-04-18T13:06:26.028595+00:00" +"ListPrice": 750000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Southgate" +"PostalCode": "N0C 1B0" +"UnparsedAddress": "25 Corbett Street, Southgate, On N0c 1b0" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover the ideal starter family home in one of Southgates most sought-after neighbourhoods! Perfectly situated, this property offers unparalleled convenience with easy access to Grey Bruce Trails, Owen Sound, Collingwood, ski hills, golf courses, the Markdale hospital, Dundalk Community Center, and local amenities including Foodland, restaurants, and downtown Dundalk.This stunning home features a thoughtfully designed modern open-concept layout, complete with 4 spacious bedrooms, 3.5 bathrooms, and a 2-car garage. Impeccable top-of-the-line finishes create a sophisticated and contemporary aesthetic, providing both style and functionality for your family. Don't miss this opportunity to embrace a lifestyle of comfort and convenience in a highly desirable location. Your dream home awaits at 25 Corbett Street! **EXTRAS** Property is being sold under power of sale in as-is, where-is condition" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Southgate" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Grey County" +"CoveredSpaces": "2.0" +"CreationDate": "2025-01-23T07:55:33.961736+00:00" +"CrossStreet": "Main St/Dundalk St" +"DirectionFaces": "South" +"Exclusions": "Existing Belongings" +"ExpirationDate": "2025-04-30" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Inclusions": "Existing appliances such as stove, dishwasher, fridge, washer and dryer" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2025-01-22T15:08:01Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-22T15:08:02Z" +"OriginalListPrice": 750000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1884126" +"ParcelNumber": "372670500" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-01-22T15:08:02Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Other" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Corbett" +"StreetNumber": "25" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5760.0" +"TaxLegalDescription": "LOT 50, PLAN 16M85 SUBJECT TO AN EASEMENT FOR ENTRY AS IN GY243616 TOWNSHIP OF SOUTHGATE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 96.42 +"LotWidth": 41.01 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11935315')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RentalItems": "Hot water tank" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"RoomsAboveGrade": 11 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2025-01-22T15:08:02Z" +"SystemModificationTimestamp": "2025-04-12T15:03:29.709491Z" +"Media": array:15 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12508 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11934878" +"ListingId": "X11934878" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:49:49Z" +"RFModificationTimestamp": "2025-04-18T13:06:26.759781+00:00" +"ListPrice": 859900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haldimand" +"PostalCode": "N3W 0E6" +"UnparsedAddress": "19 Rainbow Drive, Haldimand, On N3w 0e6" +"Coordinates": array:2 [ 0 => -79.927644001684 1 => 43.076101423815 ] +"Latitude": 43.076101423815 +"Longitude": -79.927644001684 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "YOUR HOME SOLD GUARANTEED REALTY - THE ELITE REALTY GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Its HERE! The Moment You Walk In The Grand Foyer Entryway, It Feels Like Home. This Stunning Rosebery Model Home Is Situated In A Growing Family-Friendly Neighbourhood in Caledonia. Its Only 4 Years Old And Approx 2313 Sqft. This Bright, Beautiful Home Is An Entertainers Delight With An Open Concept Kitchen And Living Room. The Kitchen Includes Stainless Steel Appliances, A Breakfast Bar And Walk-Out Access To The Backyard Deck! The Second Level Boasts 4 Spacious Bedrooms. The Huge Primary Bedroom Includes A Luxurious Private Spa-Like 5Pc Ensuite & His/Hers Walk-In Closets. All Bedrooms Feature Large Windows For Tons Of Natural Light. Unfinished Full Basement Has The Opportunity And Potential For Home Growth And Personal Touch. Walking Distance From Park, Trails And Within Close Proximity To Schools, Hospitals, Shopping Destinations And The Grand River. Hurry, Come See For Yourself, It Won't Last! **EXTRAS** SS Fridge, SS Stove, SS Dishwasher, Washer & Dryer. All Light Fixtures Included. All Appliances As Is." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Haldimand" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Haldimand" +"CoveredSpaces": "2.0" +"CreationDate": "2025-01-22T05:06:07.888576+00:00" +"CrossStreet": "Mcclung Rd And Rainbow Dr" +"DirectionFaces": "North" +"Exclusions": "Freezer In Garage" +"ExpirationDate": "2025-06-30" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "SS Fridge, SS Stove, SS Dishwasher, Washer & Dryer. All Light Fixtures Included. All Appliances As Is." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "268700" +"MajorChangeTimestamp": "2025-01-31T23:16:33Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-22T03:27:17Z" +"OriginalListPrice": 769900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1837814" +"ParcelNumber": "381551196" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-01-22T03:27:18Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 769900.0 +"PriceChangeTimestamp": "2025-01-31T23:16:33Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rainbow" +"StreetNumber": "19" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5632.76" +"TaxLegalDescription": "LOT 9, PLAN 18M60 SUBJECT TO AN EASEMENT FOR ENTRY AS IN CH113525 HALDIMAND COUNTY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/19_rainbow_dr_haldimand_on/" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 91.86 +"LotWidth": 33.14 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934878')" +"GarageType": "Attached" +"HeatSource": "Gas" +"ElectricYNA": "Yes" +"RentalItems": "HWT" +"HoldoverDays": 120 +"LaundryLevel": "Upper Level" +"TelephoneYNA": "Yes" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 10 +"SalesBrochureUrl": "https://youriguide.com/19_rainbow_dr_haldimand_on/" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 5 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-01-22T03:27:18Z" +"SystemModificationTimestamp": "2025-02-14T19:49:49.406204Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12519 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11934811" +"ListingId": "X11934811" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:49:19Z" +"RFModificationTimestamp": "2025-03-30T11:15:26.162502+00:00" +"ListPrice": 410000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "South Glengarry" +"PostalCode": "K0C 1E0" +"UnparsedAddress": "21255 Mc Naughton Court, South Glengarry, On K0c 1e0" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK REALTY GROUP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Creg Quay Estates, a serene, adult-only private community nestled along the stunning shores of Lake St. Francis in Ontario. Ideally located just 5 kilometers from the Quebec/Ontario border with easy access to Highway 401, this charming semi-detached home combines tranquil living with exceptional convenience.This home features 2 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, offering functionality and comfort. Located on a private street just steps from the canal, it provides the perfect blend of privacy and community.Creg Quay Estates is renowned for its vibrant yet peaceful atmosphere, offering exceptional amenities like a heated saltwater pool, tennis and pickleball courts, a community centre, and beautifully landscaped gardens. Outdoor enthusiasts will enjoy the shuffleboard, bocce, and horseshoe pits, along with the community docks for water activities. Residents often gather for social events, creating a strong sense of community and belonging.The community is managed by the non-profit Quay Estates Residents' Association (QERA), ensuring a welcoming and well-maintained environment. Residents agree to By-Laws to preserve the communitys charm and foster a strong social network. This cooperative spirit is evident in the meticulous care of the surroundings and the vibrant atmosphere that makes Creg Quay so special.With an HOA fee of $315/month, services include road and common area maintenance, water, sewer, driveway snow removal, clubhouse upkeep, and caretaker services. Lawn care is available at an additional cost, offering further convenience for homeowners. This low-maintenance lifestyle is ideal for snowbirds or retirees seeking comfort and ease, allowing residents to focus on enjoying their leisure time. Its proximity to natural beauty, combined with modern amenities and a convenient location, makes it a sought-after destination for those seeking the best of both worlds. Dont miss this rare gem to make it yours! **EXTRAS** Recent upgrades: Roof from last year, renovated kitchen in the last 3 years, new furnace & heatpump changed in the last 2 years, updated water softener." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "724 - South Glengarry (Lancaster) Twp" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Stormont, Dundas and Glengarry" +"CreationDate": "2025-01-22T06:06:42.725548+00:00" +"CrossStreet": "Located only 5 kms from the Quebec/Ontario border on Hwy 401. From exit 825 on 401 go on service rd to Creg Quay Estates. Located At 35 Minutes From The Faiview Shopping Centre" +"DirectionFaces": "North" +"Exclusions": "Dishwasher, Washer, Dryer, Microwave and All personal items and furniture belonging to the tenant" +"ExpirationDate": "2025-07-10" +"ExteriorFeatures": array:2 [ 0 => "Patio" 1 => "Privacy" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Appliances including Fridge & Stove & Water Softener" +"InteriorFeatures": array:4 [ 0 => "Carpet Free" 1 => "Primary Bedroom - Main Floor" 2 => "Propane Tank" 3 => "Water Softener" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2025-01-16" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "504300" +"MajorChangeTimestamp": "2025-01-22T01:16:08Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-22T01:16:08Z" +"OriginalListPrice": 410000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1888136" +"ParcelNumber": "671360464" +"ParkingFeatures": array:2 [ 0 => "Private" 1 => "Tandem" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-01-22T01:16:08Z" +"PoolFeatures": array:1 [ 0 => "Inground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SeniorCommunityYN": true +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mc Naughton" +"StreetNumber": "21255" +"StreetSuffix": "Court" +"TaxAnnualAmount": "2208.0" +"TaxLegalDescription": "LT 7 PL 156; SOUTH GLENGARRY" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"WaterBodyName": "St. Lawrence River" +"WaterSource": array:1 [ 0 => "Comm Well" ] +"WaterfrontFeatures": array:3 [ 0 => "Dock" 1 => "Marina Services" 2 => "River Access" ] +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 109.94 +"LotWidth": 27.98 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934811')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "010100100332909" +"Waterfront": array:2 [ 0 => "Indirect" 1 => "Waterfront Community" ] +"RentalItems": "Propane Tank" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Propane Tank" ] +"WaterBodyType": "River" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PossessionDate": "2025-04-01" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"RoomsAboveGrade": 5 +"RoomsBelowGrade": 3 +"AccessToProperty": array:2 [ 0 => "Marina Docking" 1 => "Private Road" ] +"PropertyFeatures": array:6 [ 0 => "Beach" 1 => "Cul de Sac/Dead End" 2 => "Lake Access" 3 => "Marina" 4 => "Rec./Commun.Centre" 5 => "Waterfront" ] +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 1 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-01-22T01:16:08Z" +"SystemModificationTimestamp": "2025-02-28T23:25:46.964136Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:13 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12518 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W11973628" +"ListingId": "W11973628" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:48:14Z" +"RFModificationTimestamp": "2025-03-30T14:36:18.234108+00:00" +"ListPrice": 21.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 4491.0 +"City": "Burlington" +"PostalCode": "L7N 3V1" +"UnparsedAddress": "860 Cumberland Avenue, Burlington, On L7n 3v1" +"Coordinates": array:2 [ 0 => -79.791469 1 => 43.3559887 ] +"Latitude": 43.3559887 +"Longitude": -79.791469 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great location for your company's home office . Upgraded finishes, large offices and common space open deck to outside on second floor. Worththe look you wont be disappointed. Offers lots of parking. Many uses permitted." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Industrial Burlington" +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CreationDate": "2025-03-30T11:15:35.905427+00:00" +"CrossStreet": "Harvester Rd & Cumberland Ave" +"ExpirationDate": "2025-04-30" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-02-10" +"LotSizeSource": "MPAC" +"MainOfficeKey": "519000" +"MajorChangeTimestamp": "2025-02-14T19:48:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-02-14T19:48:14Z" +"OriginalListPrice": 21.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1960566" +"ParcelNumber": "070570163" +"PhotosChangeTimestamp": "2025-02-14T19:48:14Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cumberland" +"StreetNumber": "860" +"StreetSuffix": "Avenue" +"TaxYear": "2024" +"TransactionBrokerCompensation": "4% and 2%" +"TransactionType": "For Lease" +"Utilities": array:1 [ 0 => "Yes" ] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/860_cumberland_avenue_burlington_on/" +"Zoning": "GE1-334" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotWidth": 329.3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W11973628')" +"GarageType": "Outside/Surface" +"PropertyUse": "Office" +"ElevatorType": "Public" +"HoldoverDays": 30 +"ListPriceUnit": "Sq Ft Gross" +"provider_name": "TRREB" +"short_address": "Burlington, ON L7N 3V1, CA" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"PossessionDetails": "Immediate" +"OfficeApartmentArea": 4491.0 +"MediaChangeTimestamp": "2025-03-17T20:50:01Z" +"MaximumRentalMonthsTerm": 24 +"MinimumRentalTermMonths": 24 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-03-22T08:25:23.186463Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12192 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11934578" +"ListingId": "X11934578" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:47:48Z" +"RFModificationTimestamp": "2025-03-30T11:16:14.784079+00:00" +"ListPrice": 3000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1360.0 +"City": "Orleans - Convent Glen And Area" +"PostalCode": "K1C 1G3" +"UnparsedAddress": "2585 St.joseph Boulevard, Orleans Convent Glenand Area, On K1c 1g3" +"Coordinates": array:2 [ 0 => 0 1 => 0 ] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER SARAZEN REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "NO MORE SHOWINGS.....PLACE LEASED.. **EXTRAS** COMMON AREA EXPENSES..$1150 PER MONTH" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Retail Store Related" ] +"CityRegion": "2007 - Convent Glen South" +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2025-01-22T12:18:56.277311+00:00" +"CrossStreet": "BELCOURT" +"ExpirationDate": "2025-05-30" +"Inclusions": "AS IS CONDITION" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2025-01-20" +"MainOfficeKey": "484800" +"MajorChangeTimestamp": "2025-01-21T21:28:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-21T21:28:40Z" +"OriginalListPrice": 3000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1887098" +"PhotosChangeTimestamp": "2025-01-22T16:49:11Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "ST.JOSEPH" +"StreetNumber": "2585" +"StreetSuffix": "Boulevard" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1/2 MO.RENT" +"TransactionType": "For Lease" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "AM3" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "N/A" +"HeatType": "Gas Forced Air Closed" +"LotDepth": 100.0 +"LotWidth": 100.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934578')" +"GarageType": "Outside/Surface" +"RetailArea": 1360.0 +"PropertyUse": "Retail" +"RentalItems": "HOT WATER TANK" +"HoldoverDays": 120 +"ListPriceUnit": "Month" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-01-24" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"ClearHeightFeet": 18 +"PossessionDetails": "TBA" +"MediaChangeTimestamp": "2025-01-22T16:49:11Z" +"HandicappedEquippedYN": true +"MaximumRentalMonthsTerm": 36 +"MinimumRentalTermMonths": 12 +"PropertyManagementCompany": "LANDLORD" +"SystemModificationTimestamp": "2025-03-23T17:24:53.707019Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12541 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11934422" +"ListingId": "X11934422" +"PropertyType": "Commercial Sale" +"PropertySubType": "Store W Apt/Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:47:00Z" +"RFModificationTimestamp": "2025-04-18T13:06:29.044037+00:00" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1500.0 +"City": "Niagara Falls" +"PostalCode": "L2E 4C8" +"UnparsedAddress": "5002 Victoria Avenue, Niagara Falls, On L2e 4c8" +"Coordinates": array:2 [ 0 => -79.0729174 1 => 43.101787825 ] +"Latitude": 43.101787825 +"Longitude": -79.0729174 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Sale of Building. Attention Investors! Fantastic Opportunity To Own A Turn Key Mixed Use Commercial Building In The Heart Of Niagara Falls Tourist District With GC Zoning. The Building Offers A Wonderful Ground Floor Retail Space Currently Set Up As A Pharmacy Along With 3 Separate One Bedroom Apartment Units, Each With Their Own Kitchen & Bathrooms. Retail Space & 3Apartment Units Offer Great Rental Income For Long Term Lease Or Year Round Airbnb Opportunities That Can Offer A Cash Flow Positive Investment. All Units Have Been Recently Renovated & Have Hydro Metered Separately. Current Lease In Place For Roof Signage Company For Additional Income. Conveniently Located Close To The Falls, Clifton Hill Tourist Area, Casino, Restaurants & Entertainment, University of Niagara Falls Canada. Easy Access To QEW Highway & Walking Distance To Niagara Falls GO Station. Schedule A Showing Today! **EXTRAS** All Existing Furniture And Equipment In Retail and Residential Units. Buyer To Assume Existing Signage Lease." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "210 - Downtown" +"Cooling": array:1 [ 0 => "Partial" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2025-01-22T19:41:20.346394+00:00" +"CrossStreet": "Victoria Ave/Falls Ave" +"ExpirationDate": "2025-08-31" +"Inclusions": "Please Contact Listing Agent For Full List." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2025-01-21T20:31:27Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-21T20:31:27Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1866394" +"PhotosChangeTimestamp": "2025-01-21T20:31:27Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Victoria" +"StreetNumber": "5002" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4252.0" +"TaxLegalDescription": "PT LT 33 PL 276 TOWN OF NIAGARA FALLS AS IN BB8193" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.25% + hst" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "GC" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Other" +"LotDepth": 150.0 +"LotWidth": 20.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934422')" +"GarageType": "None" +"RetailArea": 300.0 +"PropertyUse": "Store With Apt/Office" +"ElevatorType": "None" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "Included" ] +"PossessionDate": "2025-01-13" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"PossessionDetails": "Flexible" +"OfficeApartmentArea": 1200.0 +"MediaChangeTimestamp": "2025-01-21T20:31:27Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-03-12T13:46:20.256948Z" +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] …32 ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12542 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11934370" +"ListingId": "X11934370" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:46:36Z" +"RFModificationTimestamp": "2025-04-18T13:06:30.036921+00:00" +"ListPrice": 539900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 1H8" +"UnparsedAddress": "#806 - 150 Main Street, Hamilton, On L8p 1h8" +"Coordinates": array:2 [ …2] +"Latitude": 46.2472045 +"Longitude": -114.1555462 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX GOLD REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "First Time Home Buyers Dream or Great Income Generator for Investors! "CALL HOME" 150 Main St W 806 In The Heart Of Downtown Hamilton. Minutes away from Mc Master University, Mohawk College, Hospitals, GO Transit, Shopping Malls, First Ontario Centre, Hwy 403 and Just Steps from PUBLIC TRANSPORT. Enjoy Living In The Spacious, 9Ft Ceiling, Elegantly Upgraded, Open Concept Layout & A Modern Kitchen With Granite Counter top, S/S Appliances, Backsplash, Ensuite Laundry, A Sun Filled Living Room And Walk Out To A Spacious Balcony. Primary Bed Has A Luxurious Ensuite Washroom & A Walk-In Closet. Your Urban Living Experience Is Further Enhanced By The State-of-the-Art Gym, Indoor Swimming Pool, BBQ Courtyard, Social/Party Rooms With Full Kitchen. A Great Living Experience For Professionals, Families and Investors! Showings Available from 9:00am to 9:00pm **EXTRAS** All the furniture can be bought along with the apartment for $2000" +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:6 [ …6] +"AssociationFee": "638.92" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"CityRegion": "Central" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-22T07:06:24.943089+00:00" +"CrossStreet": "CAROLINE ST & MAIN ST W" +"ExpirationDate": "2025-06-20" +"Inclusions": "Stainless Steel Fridge, Stove, Microwave, Dishwasher & Washer & Dryer, All Window Blinds." +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "187100" +"MajorChangeTimestamp": "2025-01-21T20:09:03Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-21T20:09:03Z" +"OriginalListPrice": 539900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1886496" +"ParkingFeatures": array:1 [ …1] +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-01-21T20:09:03Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Main" +"StreetNumber": "150" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4100.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3%" +"TransactionType": "For Sale" +"UnitNumber": "806" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934370')" +"GarageType": "Underground" +"HeatSource": "Gas" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "9" +"ParkingType1": "None" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2025-01-31" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 543 +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:5 [ …5] +"SquareFootSource": "As per builder" +"PossessionDetails": "IMMEDIATE" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Flat" +"WashroomsType2Level": "Flat" +"LegalApartmentNumber": "6" +"MediaChangeTimestamp": "2025-01-21T20:09:03Z" +"PropertyManagementCompany": "FIRST SERVICE RESIDENTIAL" +"SystemModificationTimestamp": "2025-02-14T19:46:36.635072Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:26 [ …26] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12543 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11934304" +"ListingId": "X11934304" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:46:06Z" +"RFModificationTimestamp": "2025-03-30T11:15:32.506239+00:00" +"ListPrice": 1600.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 860.0 +"City": "Quinte West" +"PostalCode": "K8V 4A1" +"UnparsedAddress": "#2 - 20 Joseph Street, Quinte West, On K8v 4a1" +"Coordinates": array:2 [ …2] +"Latitude": 44.0988246 +"Longitude": -77.5748551 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "UNIT AVAILABLE FOR LEASE IN A FREESTANDING COMMERCIAL BUILDING FOR General OFFICE AND MEDICAL USE , RENT IS 1600+HST PER MONTH INCLUDES HEAT HYDRO WATER. **EXTRAS** RENT IS 1600+HST PER MONTH INCLUDES HEAT HYDRO WATER." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ …1] +"CityRegion": "Trenton Ward" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Hastings" +"CreationDate": "2025-01-22T23:36:44.164520+00:00" +"CrossStreet": "Joseph & Queen St" +"ExpirationDate": "2025-05-31" +"HoursDaysOfOperation": array:1 [ …1] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-21" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2025-01-21T19:47:17Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-21T19:47:17Z" +"OriginalListPrice": 1600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1886802" +"ParcelNumber": "403920091" +"PhotosChangeTimestamp": "2025-01-21T19:47:17Z" +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Joseph" +"StreetNumber": "20" +"StreetSuffix": "Street" +"TaxYear": "2024" +"TransactionBrokerCompensation": "Half Month Rent" +"TransactionType": "For Lease" +"UnitNumber": "2" +"Utilities": array:1 [ …1] +"Zoning": "R4" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "N/A" +"Expenses": "Estimated" +"HeatType": "Electric Forced Air" +"LotDepth": 132.0 +"LotWidth": 127.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11934304')" +"GarageType": "Outside/Surface" +"PropertyUse": "Office" +"RentalItems": "HOT WATER TANK" +"ElevatorType": "None" +"HoldoverDays": 90 +"ListPriceUnit": "Month" +"provider_name": "TRREB" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-02-01" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "%" +"WashroomsType1": 1 +"ClearHeightFeet": 8 +"PercentBuilding": "20" +"PossessionDetails": "TBD" +"IndustrialAreaCode": "%" +"OfficeApartmentArea": 860.0 +"MediaChangeTimestamp": "2025-01-21T19:47:17Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 24 +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-03-25T19:38:10.084612Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:8 [ …8] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#12544 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9412589" +"ListingId": "X9412589" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:45:42Z" +"RFModificationTimestamp": "2025-04-18T13:06:31.164435+00:00" +"ListPrice": 1199900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 4589.0 +"City": "Kingston" +"PostalCode": "K7P 0B2" +"UnparsedAddress": "876 Roshan Drive, Kingston, On K7p 0b2" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Finest Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover unparalleled craftsmanship and refined living in this stunning 4-bedroom, 3-bath, executive bungalow. Built in 2020, this residence blends timeless elegance with modern luxury, sitting gracefully on a corner lot across from a park in the sought-after Westbrook community of Kingston. From the moment you step through the grand tiled entryway, you're welcomed into an impressive great room boasting a soaring cathedral ceiling and a striking stone fireplace, creating a perfect backdrop for both intimate family gatherings and large-scale entertaining. The open-concept design effortlessly connects the living room, dining area, and breakfast nook with the gourmet kitchen - truly a chef's dream. Featuring expansive quartz countertops, abundant cabinetry, and top-tier appliances, this kitchen is as functional as it is beautiful. The principal bedroom suite offers a private retreat, complete with a cozy lounging area, a luxurious five-piece marble ensuite, and a spacious walk-in closet with a dedicated dressing area. Downstairs, the newly completed lower level serves as an ideal in-law suite or independent living space. With a separate entrance through the two-car garage, this bright and airy area includes a large recreation room, kitchenette/wet bar, two generously-sized bedrooms, a full bath, and a dedicated gym/activity space - perfect for multi-generational living or accommodating guests. Located near top-rated schools, with quick access to the 401, and just minutes from all the conveniences of Kingston's west end, this home offers an unmatched blend of luxury, comfort, and practicality." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "42 - City Northwest" +"CoListOfficeName": "RE/MAX Finest Realty Inc., Brokerage" +"CoListOfficePhone": "(613) 389-7777" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Frontenac" +"CoveredSpaces": "2.0" +"CreationDate": "2024-10-18T15:20:01.007609+00:00" +"CrossStreet": "Princess Street, north on Westbrook Road, west on Roshan." +"DirectionFaces": "West" +"Directions": "Princess Street, north on Westbrook Road, west on Roshan." +"Exclusions": "Steam Punk floor to ceiling lamp in office." +"ExpirationDate": "2025-04-30" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Smoke Detector, Stove, Washer" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Kingston & Area Real Estate Association" +"ListingContractDate": "2024-10-01" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "112.53 x 74.34" +"LotSizeSource": "Survey" +"MainOfficeKey": "470300" +"MajorChangeTimestamp": "2024-12-02T19:48:21Z" +"MlsStatus": "Extension" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-01T16:02:12Z" +"OriginalListPrice": 1199900.0 +"OriginatingSystemID": "kar" +"OriginatingSystemKey": "40656241" +"ParcelNumber": "362650351" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-11-17T03:47:28Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "16" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "kar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ROSHAN" +"StreetNumber": "876" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "8269.81" +"TaxAssessedValue": 590000 +"TaxBookNumber": "101108022001628" +"TaxLegalDescription": "LOT 8, PLAN 13M89 CITY OF KINGSTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=xy SBpq WY9io" +"Zoning": "UR1.A" +"DDFYN": true +"Water": "Municipal" +"Exposure": "East" +"HeatType": "Forced Air" +"LotDepth": 112.53 +"LotWidth": 74.34 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9412589')" +"GarageType": "Attached" +"HeatSource": "Gas" +"Waterfront": array:1 [ …1] +"HoldoverDays": 30 +"KitchensTotal": 1 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 7 +"UnavailableDate": "2024-12-02" +"SalesBrochureUrl": "https://propertyperspectives.ca/branded_pages/876roshandrive/" +"SquareFootSource": "Plans" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Lower" +"MediaChangeTimestamp": "2024-11-17T03:47:28Z" +"ExtensionEntryTimestamp": "2024-12-02T19:48:21Z" +"SystemModificationTimestamp": "2025-03-31T14:02:18.724419Z" +"Media": array:40 [ …40] } ] +success: true +page_size: 9 +page_count: 11684 +count: 105156 +after_key: "" } ] ]
