Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=120&$filter=(StandardStatus eq 'Active') and (ExteriorFeatures eq 'Water Purifier' OR InteriorFeatures eq 'Water Purifier' OR Appliances eq 'Water Purifier')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=120&$filter=(StandardStatus eq 'Active') and (ExteriorFeatures eq 'Water Purifier' OR InteriorFeatures eq 'Water Purifier' OR Appliances eq 'Water Purifier')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=120&$filter=(StandardStatus eq 'Active') and (ExteriorFeatures eq 'Water Purifier' OR InteriorFeatures eq 'Water Purifier' OR Appliances eq 'Water Purifier')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=120&$filter=(StandardStatus eq 'Active') and (ExteriorFeatures eq 'Water Purifier' OR InteriorFeatures eq 'Water Purifier' OR Appliances eq 'Water Purifier')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2862 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2855 +post_id: "663561" +post_author: 1 +"ListingKey": "E12951122" +"ListingId": "E12951122" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T15:02:53Z" +"RFModificationTimestamp": "2026-04-26T10:35:32Z" +"ListPrice": 880000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Scugog" +"PostalCode": "L1C 1T8" +"UnparsedAddress": "81 Carnegie Street, Scugog, ON L1C 1T8" +"Coordinates": array:2 [ …2] +"Latitude": 44.09884068 +"Longitude": -78.93851634 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THE NOOK REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 81 Carnegie Street in Port Perry, a beautifully updated 3+1 bedroom raised bungalow set on a large private fully fenced lot with a rare rear access gate to a quiet court. This home offers a seamless blend of comfort and functionality, featuring a modernized kitchen with quartz countertops, soft close cabinetry, and stainless-steel appliances including a counter depth refrigerator, gas range, and reverse osmosis water system, along with tastefully updated bathrooms throughout. The spacious family room showcases impressive cathedral ceilings, a cozy gas fireplace, and a walkout to a stunning backyard retreat complete with an oversized multi-level deck, dedicated sitting area, and a custom-built outdoor sauna, creating a true private oasis for relaxing or entertaining. The fully insulated garage is equipped with a heat pump system as well as hot and cold-water lines, offering an ideal space for a workshop, hobby area, or the ultimate man cave. Additional highlights include a built-in wardrobe in the primary bedroom, Ample additional storage below family room and an updated front porch with interlocking. Located just a short walk to the lake, downtown Port Perry, parks, and everyday amenities, this is an exceptional opportunity to enjoy both convenience and lifestyle." +"ArchitecturalStyle": "Bungalow-Raised" +"Basement": array:2 [ …2] +"CityRegion": "Port Perry" +"CoListOfficeName": "THE NOOK REALTY INC." +"CoListOfficePhone": "905-419-8833" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Durham" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-22T01:10:03.896915+00:00" +"CrossStreet": "Carnegie And Hwy 7A" +"DirectionFaces": "East" +"Directions": "East on Hwy 7A. South on Carnegie Street." +"Exclusions": "Hot Tub" +"ExpirationDate": "2026-07-31" +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": "Water Purifier" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2026-04-02" +"LotSizeSource": "MPAC" +"MainOfficeKey": "304200" +"MajorChangeTimestamp": "2026-04-02T15:41:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-02T15:41:50Z" +"OriginalListPrice": 880000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3757774" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-14T18:24:23Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Carnegie" +"StreetNumber": "81" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5960.52" +"TaxLegalDescription": "PCL 24-1 SEC 40M1583; LT 24 PL 40M1583 TOWNSHIP OF SCUGOG" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 155.01 +"LotWidth": 58.96 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E12951122')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "182001000808802" +"SurveyType": "None" +"RentalItems": "HWT" +"HoldoverDays": 60 +"HeatTypeMulti": array:2 [ …2] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 9 +"LotSizeAreaUnits": "Acres" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-14T18:24:23Z" +"SystemModificationTimestamp": "2026-04-23T15:03:00.84071Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:47 [ …47] +"ID": "663561" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857 +post_id: 701804 +post_author: 1 +"ListingKey": "X13032260" +"ListingId": "X13032260" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T15:02:26Z" +"RFModificationTimestamp": "2026-04-26T10:38:19Z" +"ListPrice": 549900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2A 0C9" +"UnparsedAddress": "951 Zeller Crescent, Kitchener, ON N2A 0C9" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS INNOVATION REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 951 Zeller Crescent in Kitchener-a well-maintained freehold townhome located in the desirable Idlewood/Lackner Woods community. This 2-storey home offers 3 spacious bedrooms and 2 bathrooms, with approximately 1,300 sq ft of finished living space. The main floor features a bright living area, functional kitchen with dining space, and convenient 2-piece bath. Upstairs, you'll find a large primary bedroom along with two additional bedrooms and a full 4-piece bath. The full unfinished basement provides excellent potential for future living space. Additional highlights include an attached garage with inside entry, private driveway, central air, a recently updated roof (2024) and new A/C (2023). Ideally situated close to parks, schools, shopping, transit, and major highways-perfect for families, first-time buyers, or investors." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-22T21:25:02.457571+00:00" +"CrossStreet": "Old Zeller Drive" +"DirectionFaces": "West" +"Directions": "Old Zeller to Zeller Cres" +"ExpirationDate": "2026-08-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer" +"InteriorFeatures": "Auto Garage Door Remote,Water Purifier,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"LotSizeSource": "MPAC" +"MainOfficeKey": "350800" +"MajorChangeTimestamp": "2026-04-22T19:35:28Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-22T19:35:28Z" +"OriginalListPrice": 549900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3851442" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "227135084" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-22T19:35:28Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Zeller" +"StreetNumber": "951" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "3921.0" +"TaxLegalDescription": "See Geowarehouse" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youtube.com/shorts/Zoiq1819t Uw?feature=share" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/951_zeller_crescent_kitchener_on/" +"Zoning": "R6" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 118.11 +"LotWidth": 18.04 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13032260')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301206001627093" +"SurveyType": "None" +"RentalItems": "hot water heater" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 10 +"LotSizeAreaUnits": "Square Feet" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "60-90" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "broker bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-04-22T19:35:28Z" +"SystemModificationTimestamp": "2026-04-23T15:02:38.134798Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:43 [ …43] +"ID": 701804 } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854 +post_id: 701805 +post_author: 1 +"ListingKey": "X13035402" +"ListingId": "X13035402" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T14:58:03Z" +"RFModificationTimestamp": "2026-04-26T15:57:03Z" +"ListPrice": 1649900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 0B4" +"UnparsedAddress": "325 Deerfoot Trail, Waterloo, ON N2K 0B4" +"Coordinates": array:2 [ …2] +"Latitude": 43.5205717 +"Longitude": -80.4924862 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This is your Carriage Crossing dream home. Welcome to 325 Deerfoot Trail, located in one of Waterloo's most sought-after communities. This custom Klondike-built home offers 5,300+ SF of beautifully finished living space, with 4+1 bedrms & 4 bathrms, thoughtfully designed with quality craftsmanship, timeless finishes, & functional family living. Step inside the grand entry opening to formal living & dining rms with coffered ceilings & detailed millwork. The home is anchored by a stunning 2-storey great rm with gas fireplace & oversized windows flooding the space with natural light. The well-appointed Chervin kitchen features a lrg centre island, granite counters, premium appliances, under-cabinet lighting, backsplash, & a bright breakfast area with walkout to the backyard & covered back porch. The main flr also offers a private office/potential 6th bedrm, mudrm/laundry rm, & powder rm. Upstairs offers 4 spacious bedrms, including an expansive primary retreat with tray ceiling, feature wall with linear electric fireplace, sitting area, walk-in closet with built-ins, additional dual closets, & a 5-pce ensuite with dual vanities, tiled glass shower, & jacuzzi tub. 3 additional sizable bedrms & a 5-pce main bathrm complete the upper level. The fully finished lower level features a lrg rec rm with electric fireplace, additional bedrm, 3-pce bathrm, wet bar (in-law potential), & ample storage. Hardwood & natural stone flring, custom ceiling treatments, crown moulding, curated millwork, & custom window coverings throughout. Set on a professionally landscaped lot with interlocking driveway, covered back porch, expansive patio, & fully fenced private backyard with mature trees, hardscaping, & perennial gardens. Located just mins to top-rated schools, U of W & Wilfrid Laurier University, RIM Park, Grey Silo Golf Club, trails, St. Jacobs Market, & major commuter routes. A rare opportunity to own a beautifully finished home in one of Waterloo's most desirable neighbourhoods." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-23T16:43:46.057619+00:00" +"CrossStreet": "OAK PARK DRIVE" +"DirectionFaces": "West" +"Directions": "MILLENNIUM BLVD TO OAK PARK DRIVE, THEN DEERFOOT TRAIL." +"Exclusions": "ALL DECORATIVE ITEMS: ARTWORK, MIRRORS, CLOCKS. WALL LIGHTS AND CROWN CANOPY (IN KIDS' ROOMS)." +"ExpirationDate": "2026-07-27" +"ExteriorFeatures": "Landscaped,Patio,Porch,Privacy" +"FireplaceFeatures": array:5 [ …5] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings, REVERSE OSMOSIS. ALL BATHROOM MIRRORS ONLY. BEVERAGE FRIDGE BASEMENT." +"InteriorFeatures": "Auto Garage Door Remote,In-Law Capability,Sump Pump,Water Purifier,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-23" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-23T14:58:03Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-23T14:58:03Z" +"OriginalListPrice": 1649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3860170" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "227090567" +"ParkingFeatures": "Private Double" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-23T14:58:03Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Deerfoot" +"StreetNumber": "325" +"StreetSuffix": "Trail" +"TaxAnnualAmount": "12084.9" +"TaxAssessedValue": 885000 +"TaxLegalDescription": "LOT 140, PLAN 58M506 ;T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 537 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574133 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574226 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST (SEE REMARKS)" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://youriguide.com/325_deerfoot_trail_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/325_deerfoot_trail_waterloo_on/" +"VirtualTourURLUnbranded2": "https://youtu.be/Llc Zz MTv NEU" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 108.44 +"LotShape": "Rectangular" +"LotWidth": 59.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13035402')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601000107179" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 0B4, CA" +"ApproximateAge": "6-15" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "PLEASE REMOVE SHOES, & ENSURE DOORS ARE LOCKED BEFORE LEAVING. PLEASE LEAVE ALL LIGHTS ON. LB LOCATED TO THE LEFT OF GARAGE, ATTACHED TO THE GATE." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-04-23T14:58:03Z" +"SystemModificationTimestamp": "2026-04-23T14:58:03.640282Z" +"Media": array:50 [ …50] +"ID": 701805 } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858 +post_id: "691561" +post_author: 1 +"ListingKey": "E13024248" +"ListingId": "E13024248" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T14:00:26Z" +"RFModificationTimestamp": "2026-04-26T10:35:38Z" +"ListPrice": 3199900.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Toronto E06" +"PostalCode": "M1N 1H3" +"UnparsedAddress": "63 Fishleigh Drive, Toronto E06, ON M1N 1H3" +"Coordinates": array:2 [ …2] +"Latitude": 43.700884 +"Longitude": -79.246534 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "UNION REALTY BROKERAGE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "In the entire city of Toronto there are only a handful of waterfront single family homes. This is one of them. Welcome to 63 Fishleigh Drive, an extraordinary waterfront residence perched along the edge of the Scarborough Bluffs on a massive 230' deep lot. With nothing between you and the water, the home is defined by its breathtaking sightlines which are showcased through picturesque floor-to-ceiling windows and a private primary balcony overlooking the lake. Inside, thoughtful design meets high-end finishes. This custom built smart home delivers over 5,000 sq ft of refined living space. This stunning home features 5+2 bedrooms and 6 bathrooms, including a main floor office fully customized with wooden trim and cabinetry. The entire back of the house is filled with floor to ceiling windows that flood the main floor with natural light and frame the breathtaking lake views. No detail has been overlooked, with premium finishes throughout, including marble flooring, rich panelled walls, coffered ceilings, cove lighting, and elegant oak hardwood. A grand circular oak staircase and domed ceiling with oculus skylight create a striking architectural statement. The gourmet kitchen is a chef's dream, complete with Sub-Zero and Wolf appliances, quartz-marble countertops, a butler's pantry, and a walkout to a deck that captures the full beauty of the setting. The finished walk-out basement is a true retreat, featuring a private home theatre, custom wet bar, sauna, and a glass-enclosed wine closet, all opening to a beautifully landscaped backyard oasis perched above the shoreline. Additonal features include a double car garage, 200amp panel, central vacuum, security system with full perimeter camera system, landscape irrigation, and much more. This is truly a unique property and a rare opportunity to own one of the city's most exclusive lakefront homes." +"ArchitecturalStyle": "2-Storey" +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"CityRegion": "Birchcliffe-Cliffside" +"CoListOfficeName": "UNION REALTY BROKERAGE INC." +"CoListOfficePhone": "416-686-9618" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Toronto" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-21T14:03:01.792517+00:00" +"CrossStreet": "Midland and Kingston" +"DirectionFaces": "South" +"Directions": "Right on the water" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-10-20" +"ExteriorFeatures": "Landscaped,Landscape Lighting,Patio,Deck,Porch,Lawn Sprinkler System" +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"HeatingYN": true +"Inclusions": "Sub Zero Fridge, Wolf Stove, Dishwasher, Washer & Dryer and All Elfs, Security System (with central monitoring system and 8 cameras), Central Vac, Sauna, Projector, Audio System & Screen." +"InteriorFeatures": "Sump Pump,Water Heater,Water Purifier,Countertop Range,Central Vacuum,Auto Garage Door Remote,Sauna" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "50.00 x 223.00 Feet" +"MainOfficeKey": "182700" +"MajorChangeTimestamp": "2026-04-21T13:53:14Z" +"MlsStatus": "New" +"NewConstructionYN": true +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T13:53:14Z" +"OriginalListPrice": 3199900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3839340" +"ParcelNumber": "065130055" +"ParkingFeatures": "Private" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-21T13:53:15Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"RoomsTotal": "16" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Fishleigh" +"StreetNumber": "63" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "19500.69" +"TaxBookNumber": "190101302001700" +"TaxLegalDescription": "LT 12 PL 4072 SCARBOROUGH; TORONTO , CITY OF TORONTO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% plus HST" +"TransactionType": "For Sale" +"View": array:4 [ …4] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=PQHDj WZ5RQ8&wh=0&play=0&vr=0&nozoom=1" +"WaterBodyName": "Lake Ontario" +"WaterfrontFeatures": "Not Applicable" +"WaterfrontYN": true +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 232.5 +"LotShape": "Irregular" +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E13024248')" +"PictureYN": true +"Shoreline": array:1 [ …1] +"WaterView": array:2 [ …2] +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "190101302001600" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"DockingType": array:1 [ …1] +"RentalItems": "Hot Water Tank, A/C Unit, Water Purifying System." +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 2 +"WashroomsType4": 1 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 16 +"RoomsBelowGrade": 9 +"WaterFrontageFt": "15.24" +"AccessToProperty": array:1 [ …1] +"AlternativePower": array:1 [ …1] +"PropertyFeatures": array:6 [ …6] +"StreetSuffixCode": "Dr" +"BoardPropertyType": "Free" +"PossessionDetails": "TBA" +"ShorelineExposure": "South" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 7 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"WashroomsType5Pcs": 4 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Lower" +"WashroomsType5Level": "Lower" +"WaterfrontAccessory": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-21T15:49:15Z" +"MLSAreaDistrictOldZone": "E06" +"MLSAreaDistrictToronto": "E06" +"ShorelineExposureMulti": array:1 [ …1] +"MLSAreaMunicipalityDistrict": "Toronto E06" +"SystemModificationTimestamp": "2026-04-23T14:00:46.993636Z" +"Media": array:50 [ …50] +"ID": "691561" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856 +post_id: "658931" +post_author: 1 +"ListingKey": "X12942630" +"ListingId": "X12942630" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T13:03:27Z" +"RFModificationTimestamp": "2026-04-26T10:37:35Z" +"ListPrice": 2199000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 5.87 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "North Dumfries" +"PostalCode": "N1R 5S7" +"UnparsedAddress": "3667 Old Beverly Road, North Dumfries, ON N1R 5S7" +"Coordinates": array:2 [ …2] +"Latitude": 43.3667046 +"Longitude": -80.2185488 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this exceptional country estate set on almost 6 acres of private, picturesque land just minutes from the City of Cambridge. Offering more than 3,850 sq. ft. above grade, plus an unspoiled walk-up basement with impressive 10-foot ceilings, this home blends timeless elegance, everyday comfort, and incredible future potential.The main level is designed for both relaxed living and entertaining, featuring a spacious kitchen with a large pantry, a sun-filled sunroom, a screened-in porch, and multiple inviting living spaces for gathering with family and friends. A separate dining room, private study and three fireplaces, add to the home's warmth and functionality.Upstairs, you'll find four generous bedrooms, including a spacious primary suite with ensuite bath (heated floors), as well as an additional bedroom with a rough-in for a 3-piece bathroom. The basement also includes a bathroom rough-in, offering excellent potential for future finished living space or extended living arrangements, with convenient walk-up access to the garage.Outside, the property continues to impress with a fire pit area, irrigation system, and an expansive driveway leading to the attached 2-car garage. A second detached 2-car garage features a fully equipped studio apartment along with additional flexible space ideal for a home-based business, hobby area, or guest overflow. A charming chicken coop adds to the property's unique country appeal.This is a rare opportunity to enjoy the peace and privacy of country living without sacrificing proximity to city amenities. Please see attached floor plans and full video in the sales brochure." +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "4.0" +"CreationDate": "2026-04-10T08:27:09.214578+00:00" +"CrossStreet": "Sheffield Road" +"DirectionFaces": "South" +"Directions": "Coming from Cambridge, just past Sheffield Road on the Right" +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": "Deck,Patio,Porch,Lawn Sprinkler System,Porch Enclosed,Landscaped,Privacy,Lighting" +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer, Central Vac, All window coverings" +"InteriorFeatures": "Accessory Apartment,Air Exchanger,Auto Garage Door Remote,Central Vacuum,Floor Drain,In-Law Capability,Sewage Pump,Sump Pump,Water Heater Owned,Water Purifier,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-01" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-23T12:44:00Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-01T11:32:07Z" +"OriginalListPrice": 2199000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3740976" +"OtherStructures": array:1 [ …1] +"ParkingFeatures": "Private" +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2026-04-01T11:32:07Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Septic" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "OLD BEVERLY" +"StreetNumber": "3667" +"StreetSuffix": "Road" +"TaxAnnualAmount": "13648.38" +"TaxLegalDescription": "PT LT 7 CON 8 BEVERLY PT 4, 58R13264; NORTH DUMFRIES. T/W EASEMENT OVER PT OF SAID LOT 7 BEING PT 2 ON 58R-13264 AS IN 1531412" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://youriguide.com/3667_old_beverly_rd_cambridge_on/" +"VirtualTourURLBranded2": "https://vimeo.com/1125751092/7ea60bb201?share=copy" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/3667_old_beverly_rd_cambridge_on/" +"VirtualTourURLUnbranded2": "https://vimeo.com/1125750966/1e95515671?share=copy" +"WaterSource": array:1 [ …1] +"Zoning": "Z.1 Z.12" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 644.22 +"LotWidth": 398.14 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12942630')" +"GarageType": "Attached" +"HeatSource": "Propane" +"SurveyType": "None" +"RentalItems": "None" +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"SoundBiteUrl": "https://vimeo.com/1125751092/7ea60bb201?share=copy" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Suspended" +"WashroomsType1": 5 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 16 +"LotSizeAreaUnits": "Acres" +"SalesBrochureUrl": "https://vimeo.com/1125751092/7ea60bb201?share=copy" +"LotSizeRangeAcres": "5-9.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "BROKERBAY" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Second" +"MediaChangeTimestamp": "2026-04-23T13:01:19Z" +"SuspendedEntryTimestamp": "2026-04-16T23:59:02Z" +"SystemModificationTimestamp": "2026-04-23T13:03:41.617385Z" +"SoldConditionalEntryTimestamp": "2026-04-08T19:30:41Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:42 [ …42] +"ID": "658931" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853 +post_id: "646028" +post_author: 1 +"ListingKey": "W12902734" +"ListingId": "W12902734" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T13:00:27Z" +"RFModificationTimestamp": "2026-04-26T10:36:18Z" +"ListPrice": 2988000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7.525 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Milton" +"PostalCode": "L9T 9E2" +"UnparsedAddress": "8656 Esquesing Line, Milton, ON L9T 9E2" +"Coordinates": array:2 [ …2] +"Latitude": 43.5530515 +"Longitude": -79.892222 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 MILLER REAL ESTATE LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 8656 Esquesing Line, a custom- built country estate on a stunning 7. 5- acre property just minutes from Milton, Highway 401, and everyday essentials. Built in 2021, this exceptional home offers 3,154 sq. ft. of above-grade space and a rare combination of modern comfort and peaceful rural surroundings.Surrounded by natural beauty, the property offers ample parking, an oversized main garage, and an additional built- in lower garage. Inside, upscale finishes and thoughtful architectural details create a warm yet sophisticated atmosphere. Premium Kolbe windows bring in abundant natural light, while custom millwork adds character and craftsmanship throughout.The kitchen is a true focal point of the home, featuring imported quartzite countertops, a large chef-inspired island, full-height cabinetry, illuminated display cabinets, and premium integrated appliances. The bedroom layout is equally impressive, with dressing areas and spa-like en-suites finished with curbless glass showers, quartz- topped vanities, custom cabinetry, and large-format tile.Privately positioned, the primary retreat is a standout, complete with a vaulted ceiling, a custom dressing room with a centre island and hidden storage, and a 5-piece ensuite with radiant-heated floors, a soaker tub, and an oversized curbless shower.The unfinished lower level offers an additional 2,063 sq. ft. and is already framed and insulated, with nearly 9-foot ceilings, a bathroom rough-in, direct walkout access to the patio and hot tub area, and a separate entry to its own lower garage. This space offers excellent flexibility for expanded family living, recreational use, or future income opportunities.Outdoors, the 700 sq. ft. rear deck captures stunning panoramic views and beautifully extends the living space. The home is also served by a 400-amp electrical service, ready to support both present and future needs.This is a must- see property for buyers seeking luxury, privacy, and lasting value." +"ArchitecturalStyle": "2-Storey" +"Basement": array:4 [ …4] +"CityRegion": "1034 - MN Milton North" +"CoListOfficeName": "CENTURY 21 MILLER REAL ESTATE LTD." +"CoListOfficePhone": "905-845-9180" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "3.0" +"CreationDate": "2026-04-16T13:55:43.995344+00:00" +"CrossStreet": "4TH LINE/5 SIDE ROAD" +"DirectionFaces": "West" +"Directions": "Steeles to Esquesing Line south of 5 Side Road on West side of street." +"Disclosures": array:2 [ …2] +"Exclusions": "All wall-mounted TVs, fridge in garage, dining room light fixture, light sconces in primary bedroom." +"ExpirationDate": "2026-09-20" +"ExteriorFeatures": "Deck,Hot Tub,Lighting,Patio,Paved Yard,Privacy,Porch,Year Round Living" +"FoundationDetails": array:4 [ …4] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Openers, Gas Stove, Hot Tub, Hot Tub Equipment, Hot Water Tank Owned, Range Hood, Refrigerator, Starlink satellite, Washer, Window Coverings, Beverage Cooler, Tire racks in the garage, Central vacuum w/accessories, Security camera system and recording equipment, DSC whole-home alarm system (monitoring not included), All bathroom mirrors, All light fixtures (except those excluded.)" +"InteriorFeatures": "Air Exchanger,Auto Garage Door Remote,Bar Fridge,Built-In Oven,Carpet Free,Central Vacuum,In-Law Suite,On Demand Water Heater,Rough-In Bath,Storage,Upgraded Insulation,Water Heater Owned,Water Purifier,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-20" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "085100" +"MajorChangeTimestamp": "2026-04-23T13:00:27Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-20T13:31:15Z" +"OriginalListPrice": 3149900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3651470" +"ParcelNumber": "249770546" +"ParkingFeatures": "Private,Inside Entry" +"ParkingTotal": "27.0" +"PhotosChangeTimestamp": "2026-04-23T12:42:16Z" +"PoolFeatures": "None" +"PreviousListPrice": 3149900.0 +"PriceChangeTimestamp": "2026-04-23T13:00:27Z" +"Roof": "Shingles" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Septic" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Esquesing" +"StreetNumber": "8656" +"StreetSuffix": "Line" +"TaxAnnualAmount": "10432.0" +"TaxAssessedValue": 1263000 +"TaxLegalDescription": "PART LOT 5 CON 4 ESQ AS IN 344209 TOWN OF MILTON & PART LOT 5 CON 4 ESQ AS IN 262457 TOWN OF MILTON" +"TaxYear": "2025" +"Topography": array:4 [ …4] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"View": array:3 [ …3] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/8656_esquesing_line_milton_on/" +"WaterSource": array:3 [ …3] +"Zoning": "RE GA" +"DDFYN": true +"Water": "Well" +"GasYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 538.0 +"LotShape": "Irregular" +"LotWidth": 608.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12902734')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "240905000209200" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "NONE" +"HoldoverDays": 180 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParcelNumber2": 249770547 +"ParkingSpaces": 24 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"RuralUtilities": array:2 [ …2] +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 8 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:4 [ …4] +"SalesBrochureUrl": "https://kormendytrott.com/real_estate/8656-esquesing-line/" +"LotSizeRangeAcres": "5-9.99" +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 5 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Main" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-04-23T12:42:16Z" +"WaterDeliveryFeature": array:2 [ …2] +"SystemModificationTimestamp": "2026-04-23T13:00:48.184455Z" +"Media": array:47 [ …47] +"ID": "646028" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847 +post_id: "611112" +post_author: 1 +"ListingKey": "X12821528" +"ListingId": "X12821528" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T03:41:48Z" +"RFModificationTimestamp": "2026-04-26T10:37:16Z" +"ListPrice": 1050000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2S 3Y6" +"UnparsedAddress": "65 Mccaffery Crescent, St. Catharines, ON L2S 3Y6" +"Coordinates": array:2 [ …2] +"Latitude": 43.1241268 +"Longitude": -79.2678296 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning all-brick bungalow with double garage offering over 3,000 sq ft of finished living space in the sought-after Vansickle area. This executive home features 5 bedrooms plus a gym/office and 3 full bathrooms, and impresses from the moment you arrive with its beautiful curb appeal and grand entrance.Inside, you'll find a bright, open layout with a welcoming foyer, hardwood flooring, cathedral ceilings, and decorative pillars throughout the main floor. The formal dining room connects to the well-appointed kitchen through a convenient butler door, while the kitchen itself offers granite countertops, a skylight, and overlooks the dinette with garden doors leading to a large tiered deck, perfect for entertaining. The spacious Great Room features a gas fireplace and California shutters, and the main-level laundry offers direct garage access.The primary bedroom retreat includes a walk-in closet and 5-piece ensuite, while another main-floor bedroom enjoys ensuite privilege. The finished lower level provides two additional bedrooms, a full bathroom, a large rec/games area, storage, and a bonus gym or office space.Additional features include a sprinkler system, BBQ gas line, and (per previous listing) sound-insulated interior walls and RG6 wiring. Located on a quiet street in a fantastic family neighbourhood close to parks, schools, and everyday amenities, and just a short drive to Smart Centres St. Catharines (Fourth Ave) and The Pen Centre.Move-in ready in one of the West End's most desirable pockets. Freestanding home gym/power rack system is negotiable separately from the sale of the home (weights excluded)." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ …2] +"CityRegion": "462 - Rykert/Vansickle" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-23T03:23:32.158314+00:00" +"CrossStreet": "Vansickle Road" +"DirectionFaces": "North" +"Directions": "From Vansickle Rd to Mc Caffery Crescent" +"Exclusions": "The cabinet unit over the toilet in the basement washroom." +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": "Deck,Lawn Sprinkler System" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Existing Fridge, Stove, Washer, Dryer, built-in dishwasher and microwave." +"InteriorFeatures": "Central Vacuum,Water Purifier,Primary Bedroom - Main Floor" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Niagara Association of REALTORS" +"ListingContractDate": "2026-02-26" +"LotSizeDimensions": "114.83 x 54.92" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2026-02-26T05:19:54Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-26T05:19:54Z" +"OriginalListPrice": 1050000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3524426" +"ParcelNumber": "463550208" +"ParkingFeatures": "Private Double,Other" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-04-23T03:16:16Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "17" +"Sewer": "Sewer" +"ShowingRequirements": array:3 [ …3] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "MCCAFFERY" +"StreetNumber": "65" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "7224.0" +"TaxBookNumber": "262902003467932" +"TaxLegalDescription": "LOT 46, PLAN 30M272, S/T EASEMENT OVER PT 11 30R9591 AS IN LT177141; ST. CATHARINES" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 114.83 +"LotWidth": 54.92 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12821528')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "262902003467932" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"RentalItems": "Hot Water Heater" +"HoldoverDays": 120 +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:3 [ …3] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "90 days" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-23T03:16:16Z" +"SystemModificationTimestamp": "2026-04-23T03:42:00.975244Z" +"Media": array:50 [ …50] +"ID": "611112" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859 +post_id: "678572" +post_author: 1 +"ListingKey": "X13004766" +"ListingId": "X13004766" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T01:00:46Z" +"RFModificationTimestamp": "2026-04-26T10:38:07Z" +"ListPrice": 1175000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Laurentian Valley" +"PostalCode": "K8A 6W5" +"UnparsedAddress": "740 Walford Road, Laurentian Valley, ON K8A 6W5" +"Coordinates": array:2 [ …2] +"Latitude": 45.7636909 +"Longitude": -77.126506 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXIT OTTAWA VALLEY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 740 Waldorf Road, a stunning 4-bedroom, 3-bathroom home designed for comfort, efficiency, and luxury living. This impressive stucco residence offers exceptional curb appeal with a fully irrigated lawn supported by an in-ground sprinkler system, plus the added convenience of a prepaid lawn maintenance contract for the upcoming spring and summer seasons.Step inside to discover a thoughtfully designed interior featuring soaring 10+ foot ceilings and durable, high-end hard surface flooring throughout, including marble, porcelain tile, and stamped concrete. At the heart of the home is a custom kitchen complete with premium Kitchen Aid appliances, including fridge, stove, and dishwasher-perfect for both everyday living and entertaining.A standout feature of this property is the indoor saltwater pool, surrounded by stamped concrete and supported by a dedicated HRV system to maintain optimal humidity and air quality year-round-creating your own private retreat regardless of the season.The primary suite offers a true spa-like experience with a luxurious 5-piece ensuite. Enjoy a bubble tub with temperature control, dual sinks positioned on opposite sides for added privacy, and a fully accessible open-concept shower design.This home is built with efficiency and peace of mind in mind, featuring in-floor radiant heating (including front covered patio) powered by a boiler system, supplemented by a backup wood furnace and an additional forced air heating system. Air quality is further enhanced with a full-home HRV system. A 16 k W Generac backup generator ensures uninterrupted power, while a comprehensive water filtration system services the home.A rare offering combining quality construction, thoughtful design, and high-end features-this property is truly one-of-a-kind. See video links for more pictures, 3D Tour, floor plans and documents" +"AccessibilityFeatures": array:2 [ …2] +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ …2] +"CityRegion": "531 - Laurentian Valley" +"CoListOfficeName": "EXIT OTTAWA VALLEY REALTY" +"CoListOfficePhone": "613-629-3948" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Wall Unit(s)" +"Country": "CA" +"CountyOrParish": "Renfrew" +"CoveredSpaces": "3.0" +"CreationDate": "2026-04-23T01:07:48.070639+00:00" +"CrossStreet": "hwy 41 and Walford" +"DirectionFaces": "East" +"Directions": "from Hwy 41 to Walford, turn right follow to 740 Walford home is on the left." +"ExpirationDate": "2026-07-10" +"ExteriorFeatures": "Deck,Lawn Sprinkler System,Year Round Living" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, stove, dishwasher, microwave hoodfan, washer, dryer," +"InteriorFeatures": "Auto Garage Door Remote,Air Exchanger,Generator - Full,Propane Tank,Water Purifier,Water Softener,Water Heater Owned,Ventilation System,Primary Bedroom - Main Floor" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Renfrew County Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "488600" +"MajorChangeTimestamp": "2026-04-16T02:05:35Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-16T02:05:35Z" +"OriginalListPrice": 1175000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3813404" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "571210124" +"ParkingFeatures": "Front Yard Parking" +"ParkingTotal": "9.0" +"PhotosChangeTimestamp": "2026-04-16T02:05:36Z" +"PoolFeatures": "Indoor,Salt" +"Roof": "Fibreglass Shingle" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Septic" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Walford" +"StreetNumber": "740" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7521.0" +"TaxLegalDescription": "PT LT 14 CON A ALICE , PTS 2 & 3, 49R9585 TOWNSHIP OF LAURENTIAN VALLEY" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1.625" +"TransactionType": "For Sale" +"View": array:2 [ …2] +"VirtualTourURLUnbranded": "https://listings.revelmarketingagency.com/740-Walford-Rd-Pembroke-ON-K8A-6W5-Canada" +"WaterSource": array:1 [ …1] +"Zoning": "rural residential" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 1223.9 +"LotWidth": 202.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13004766')" +"GarageType": "Attached" +"HeatSource": "Propane" +"RollNumber": "476607405022910" +"SurveyType": "Available" +"Waterfront": array:1 [ …1] +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:3 [ …3] +"KitchensTotal": 1 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"short_address": "Laurentian Valley, ON K8A 6W5, CA" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"HeatSourceMulti": array:2 [ …2] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 15 +"LotSizeAreaUnits": "Acres" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:2 [ …2] +"LotSizeRangeAcres": "5-9.99" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Main" +"MediaChangeTimestamp": "2026-04-16T02:05:36Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-04-23T01:00:55.571635Z" +"Media": array:40 [ …40] +"ID": "678572" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860 +post_id: "660312" +post_author: 1 +"ListingKey": "W12948618" +"ListingId": "W12948618" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T23:57:37Z" +"RFModificationTimestamp": "2026-04-26T10:36:24Z" +"ListPrice": 2999000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 2.714 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Caledon" +"PostalCode": "L7K 2H5" +"UnparsedAddress": "2814 Forks Of The Credit Road, Caledon, ON L7K 2H5" +"Coordinates": array:2 [ …2] +"Latitude": 43.8297453 +"Longitude": -79.9617246 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SAM MCDADI REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a truly unique and breathtaking country estate where nature, privacy, and exceptional design come together in perfect harmony. Set on a picturesque 2.71 acres and ideally positioned between the Pulpit Club, Caledon Mountain Trout Club, Caledon Ski Club, Brampton Flying Club, and along the Bruce Trail, this magnificent property offers an unmatched lifestyle within close proximity to the city. A resort-like sanctuary awaits, designed for both grand entertaining and quiet, restorative living. An inground saltwater pool, outdoor shower, and cold plunge offer spa-like relaxation, while the wood-fired pizza oven, outdoor bar, and firepit create exceptional gathering spaces. Extensive, thoughtfully constructed walking trails wind throughout the grounds, complemented by aromatic and carefully curated gardens. A charming children's playhouse/bunkie, pool cabana, and 3 decks further enhance this one-of-a-kind outdoor setting. Inside, expansive windows fill the home with natural light and bring the outdoors in. The modern kitchen features marble countertops, stainless steel appliances, and a striking backsplash, flowing into the dining area. The living room is anchored by a stunning brick accent wall and wood-burning fireplace, while a home office with built-in desk and outdoor access provides a serene workspace. The main floor primary suite is a tranquil escape with a luxurious 4-pc ensuite and walk-in shower. Upstairs, 3 spacious bedrooms and 2 well-appointed baths provide comfort for family and guests. The 3rd floor loft serves as a wellness sanctuary with an infrared sauna and custom built-in sauna. Additional highlights include heated marble bathroom floors, new hardwood flooring, and a custom floor-to-ceiling glass wine cellar. Designed for peace of mind, the home features a backup generator, air quality systems, water treatment, and major electrical upgrades. Elegant, modern and immersed in nature - 2814 Forks of the Credit Road leaves nothing to be desired." +"ArchitecturalStyle": "2 1/2 Storey" +"Basement": array:1 [ …1] +"CityRegion": "Rural Caledon" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air,Wall Unit(s)" +"Country": "CA" +"CountyOrParish": "Peel" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-23T00:05:59.806171+00:00" +"CrossStreet": "Hurontario St & Forks of the Credit Rd" +"DirectionFaces": "North" +"Directions": "If heading northbound on Hurontario St, turn left onto Forks of the Credit Rd. If heading southbound on Hurontario St, turn right onto Forks of the Credit Rd. The property will be on your right side." +"ExpirationDate": "2026-07-05" +"ExteriorFeatures": "Backs On Green Belt,Deck,Hot Tub,Landscaped,Lawn Sprinkler System,Lighting,Patio,Privacy,Porch,Private Pond" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "HOME IS BEING SOLD FURNISHED. All existing window coverings including ROLLer Up security shutters, light fixtures, stainless steel kitchen appliances including Frigidaire fridge, GE gas stove and Samsung dishwasher, laundry appliances including LG washer and dryer set, wood-burning fireplace and related equipment, hot tub and related equipment, infrared sauna (2019), 10-person custom-built-in sauna (2023), outdoor pizza oven, automatic garage door opener and remote(s), air exchanger system (2024), air purifier system (2024), water treatment system, sprinkler irrigation system, back-up generator, heat pump system, furnace (2024), AC, hot water tank, and additional furnishings including: king bed, 3 queen beds, night tables, daybed, linens, couch, sofa chairs, property tools, yard work supplies, crockery, cold plunge, patio furniture, storage bins, propane tanks, BBQ, artwork, and dressers." +"InteriorFeatures": "Air Exchanger,Auto Garage Door Remote,Generator - Partial,Guest Accommodations,Primary Bedroom - Main Floor,Sauna,Storage,Water Heater Owned,Water Purifier,Water Softener,Water Treatment" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-01" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "193800" +"MajorChangeTimestamp": "2026-04-02T02:26:27Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-02T02:26:27Z" +"OriginalListPrice": 2999000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3723786" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "142700086" +"ParkingFeatures": "Private" +"ParkingTotal": "7.0" +"PhotosChangeTimestamp": "2026-04-02T02:26:27Z" +"PoolFeatures": "Inground,Outdoor,Salt" +"Roof": "Metal,Fibreglass Shingle,Flat" +"SecurityFeatures": array:3 [ …3] +"Sewer": "Septic" +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Forks Of The Credit" +"StreetNumber": "2814" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7605.0" +"TaxLegalDescription": "LT 20 PL 771 CALEDON ; CALEDON" +"TaxYear": "2026" +"Topography": array:4 [ …4] +"TransactionBrokerCompensation": "2.5% + Aplicable HST*" +"TransactionType": "For Sale" +"View": array:6 [ …6] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/2814_forks_of_the_credit_rd_caledon_village_on/" +"DDFYN": true +"Water": "Well" +"GasYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 405.48 +"LotWidth": 293.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12948618')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "212403001013800" +"SurveyType": "Available" +"ElectricYNA": "Yes" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:2 [ …2] +"KitchensTotal": 1 +"ParkingSpaces": 5 +"provider_name": "TRREB" +"short_address": "Caledon, ON L7K 2H5, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"WashroomsType2": 2 +"WashroomsType3": 2 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 1 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "2-4.99" +"PossessionDetails": "60/90/TBD" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-22T23:57:37Z" +"SystemModificationTimestamp": "2026-04-22T23:57:47.100819Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] +"ID": "660312" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861 +post_id: "463629" +post_author: 1 +"ListingKey": "W12458346" +"ListingId": "W12458346" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-22T23:34:34Z" +"RFModificationTimestamp": "2026-04-26T10:36:10Z" +"ListPrice": 1747000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Caledon" +"PostalCode": "L7E 0C7" +"UnparsedAddress": "10 Costner Place, Caledon, ON L7E 0C7" +"Coordinates": array:2 [ …2] +"Latitude": 43.9632004 +"Longitude": -79.8219549 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL BROKER ONTARIO LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome To 10 Costner Place In The Prestigious Community Of Palgrave. Exhilarating Estate Property On Top Of A Hill With Multiple Beautiful Landscapes Nearby. Very Serene Surroundings Containing Beautiful Nature, Animals And Vibrant View Of The Sky. Upon Entering You Will Be Greeted With An Abundance Of Natural Light And Views Of Lush Greenery Through The Large Windows. Hardwood Floors Throughout The Main Floor and Second Floor With Tiles In The Kitchen and Basement. A Cozy Fireplace To Relax Beside And View the Nature In The Backyard Through The Large Windows. The Basement Is The Perfect Space For Entertainment. Outdoor Access From Kitchen & Family Room Leads To The Deck With A B/I BBQ With Gas Connection, A Stunning Gazebo And A Backyard Shed. And Not To Forget The Caledon Trailway Path Right Next Door. Easy Access To Trails, Golf Courses & Caledon Equestrian Park, Close To Palgrave Park & Equestrian Park, Bolton, Orangeville, Schomberg, & Tottenham." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Palgrave" +"CoListOfficeName": "REAL BROKER ONTARIO LTD." +"CoListOfficePhone": "888-311-1172" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Peel" +"CoveredSpaces": "4.0" +"CreationDate": "2026-04-23T00:16:08.756756+00:00" +"CrossStreet": "Mount Hope & Indiana Drive" +"DirectionFaces": "South" +"Directions": "Going north on Mount Hope road, take a right on Indiana Drive, then take a right on Costner Place and drive to the end of the roundabout." +"ExpirationDate": "2026-06-09" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "All Elf's, Two S/S Fridges, One Stove, One Cooktop, Two S/S Microwave, S/S Oven. AC, Furnace And HWT Owned. B/I BBQ In Backyard." +"InteriorFeatures": "Bar Fridge,Built-In Oven,Carpet Free,Central Vacuum,Countertop Range,Water Purifier,Sump Pump" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-09" +"MainOfficeKey": "384000" +"MajorChangeTimestamp": "2026-04-22T23:20:01Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-10-11T16:44:03Z" +"OriginalListPrice": 2299000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3123120" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "143410232" +"ParkingTotal": "16.0" +"PhotosChangeTimestamp": "2025-10-11T16:44:04Z" +"PoolFeatures": "None" +"PreviousListPrice": 1947000.0 +"PriceChangeTimestamp": "2026-04-22T23:20:01Z" +"Roof": "Shingles" +"Sewer": "Septic" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Costner" +"StreetNumber": "10" +"StreetSuffix": "Place" +"TaxAnnualAmount": "9466.24" +"TaxLegalDescription": "LOT 8, PLAN 43M1266, CALEDON; S/T EASEMENT IN FAVOUR OF THE REGIONAL MUNICIPALITY OF PEEL OVER PT LT 8 43M1266 PT 15 43R22640, AS IN LT1849448 S/T EASEMENT IN FAVOUR OF THE CORPORATION OF THE TOWN OF CALEDON OVER PT LT 8 43M1266 PT 15 43R22640, AS IN LT1849450 etc." +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 380.58 +"LotWidth": 231.86 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12458346')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "212401000289920" +"SurveyType": "Unknown" +"HoldoverDays": 60 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 12 +"provider_name": "TRREB" +"short_address": "Caledon, ON L7E 0C7, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2026-04-30" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:5 [ …5] +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 3 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Ground" +"WashroomsType5Level": "Basement" +"MediaChangeTimestamp": "2025-10-11T16:44:04Z" +"SystemModificationTimestamp": "2026-04-22T23:34:43.923572Z" +"Media": array:40 [ …40] +"ID": "463629" } ] +success: true +page_size: 10 +page_count: 43 +count: 421 +after_key: "" } "RF Response Time" => "0.33 seconds" ] "RF Cache Key: fb454bfb226c8bbbe454def507a72a0efb2a0b6c3b05f8917eb5a9e393279f2e" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3126 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4319 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "E12951122" +"ListingId": "E12951122" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T15:02:53Z" +"RFModificationTimestamp": "2026-04-26T10:35:32Z" +"ListPrice": 880000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Scugog" +"PostalCode": "L1C 1T8" +"UnparsedAddress": "81 Carnegie Street, Scugog, ON L1C 1T8" +"Coordinates": array:2 [ …2] +"Latitude": 44.09884068 +"Longitude": -78.93851634 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THE NOOK REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 81 Carnegie Street in Port Perry, a beautifully updated 3+1 bedroom raised bungalow set on a large private fully fenced lot with a rare rear access gate to a quiet court. This home offers a seamless blend of comfort and functionality, featuring a modernized kitchen with quartz countertops, soft close cabinetry, and stainless-steel appliances including a counter depth refrigerator, gas range, and reverse osmosis water system, along with tastefully updated bathrooms throughout. The spacious family room showcases impressive cathedral ceilings, a cozy gas fireplace, and a walkout to a stunning backyard retreat complete with an oversized multi-level deck, dedicated sitting area, and a custom-built outdoor sauna, creating a true private oasis for relaxing or entertaining. The fully insulated garage is equipped with a heat pump system as well as hot and cold-water lines, offering an ideal space for a workshop, hobby area, or the ultimate man cave. Additional highlights include a built-in wardrobe in the primary bedroom, Ample additional storage below family room and an updated front porch with interlocking. Located just a short walk to the lake, downtown Port Perry, parks, and everyday amenities, this is an exceptional opportunity to enjoy both convenience and lifestyle." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Port Perry" +"CoListOfficeName": "THE NOOK REALTY INC." +"CoListOfficePhone": "905-419-8833" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Durham" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-22T01:10:03.896915+00:00" +"CrossStreet": "Carnegie And Hwy 7A" +"DirectionFaces": "East" +"Directions": "East on Hwy 7A. South on Carnegie Street." +"Exclusions": "Hot Tub" +"ExpirationDate": "2026-07-31" +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Central Lakes Association of REALTORS" +"ListingContractDate": "2026-04-02" +"LotSizeSource": "MPAC" +"MainOfficeKey": "304200" +"MajorChangeTimestamp": "2026-04-02T15:41:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-02T15:41:50Z" +"OriginalListPrice": 880000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3757774" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-14T18:24:23Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Carnegie" +"StreetNumber": "81" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5960.52" +"TaxLegalDescription": "PCL 24-1 SEC 40M1583; LT 24 PL 40M1583 TOWNSHIP OF SCUGOG" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 155.01 +"LotWidth": 58.96 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E12951122')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "182001000808802" +"SurveyType": "None" +"RentalItems": "HWT" +"HoldoverDays": 60 +"HeatTypeMulti": array:2 [ …2] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 9 +"LotSizeAreaUnits": "Acres" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-14T18:24:23Z" +"SystemModificationTimestamp": "2026-04-23T15:03:00.84071Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:47 [ …47] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4320 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13032260" +"ListingId": "X13032260" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T15:02:26Z" +"RFModificationTimestamp": "2026-04-26T10:38:19Z" +"ListPrice": 549900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2A 0C9" +"UnparsedAddress": "951 Zeller Crescent, Kitchener, ON N2A 0C9" +"Coordinates": array:2 [ …2] +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS INNOVATION REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 951 Zeller Crescent in Kitchener-a well-maintained freehold townhome located in the desirable Idlewood/Lackner Woods community. This 2-storey home offers 3 spacious bedrooms and 2 bathrooms, with approximately 1,300 sq ft of finished living space. The main floor features a bright living area, functional kitchen with dining space, and convenient 2-piece bath. Upstairs, you'll find a large primary bedroom along with two additional bedrooms and a full 4-piece bath. The full unfinished basement provides excellent potential for future living space. Additional highlights include an attached garage with inside entry, private driveway, central air, a recently updated roof (2024) and new A/C (2023). Ideally situated close to parks, schools, shopping, transit, and major highways-perfect for families, first-time buyers, or investors." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-04-22T21:25:02.457571+00:00" +"CrossStreet": "Old Zeller Drive" +"DirectionFaces": "West" +"Directions": "Old Zeller to Zeller Cres" +"ExpirationDate": "2026-08-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-22" +"LotSizeSource": "MPAC" +"MainOfficeKey": "350800" +"MajorChangeTimestamp": "2026-04-22T19:35:28Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-22T19:35:28Z" +"OriginalListPrice": 549900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3851442" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "227135084" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-22T19:35:28Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Zeller" +"StreetNumber": "951" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "3921.0" +"TaxLegalDescription": "See Geowarehouse" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youtube.com/shorts/Zoiq1819t Uw?feature=share" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/951_zeller_crescent_kitchener_on/" +"Zoning": "R6" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 118.11 +"LotWidth": 18.04 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13032260')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301206001627093" +"SurveyType": "None" +"RentalItems": "hot water heater" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 10 +"LotSizeAreaUnits": "Square Feet" +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "60-90" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "broker bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"MediaChangeTimestamp": "2026-04-22T19:35:28Z" +"SystemModificationTimestamp": "2026-04-23T15:02:38.134798Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:43 [ …43] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4323 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13035402" +"ListingId": "X13035402" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T14:58:03Z" +"RFModificationTimestamp": "2026-04-26T15:57:03Z" +"ListPrice": 1649900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2K 0B4" +"UnparsedAddress": "325 Deerfoot Trail, Waterloo, ON N2K 0B4" +"Coordinates": array:2 [ …2] +"Latitude": 43.5205717 +"Longitude": -80.4924862 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This is your Carriage Crossing dream home. Welcome to 325 Deerfoot Trail, located in one of Waterloo's most sought-after communities. This custom Klondike-built home offers 5,300+ SF of beautifully finished living space, with 4+1 bedrms & 4 bathrms, thoughtfully designed with quality craftsmanship, timeless finishes, & functional family living. Step inside the grand entry opening to formal living & dining rms with coffered ceilings & detailed millwork. The home is anchored by a stunning 2-storey great rm with gas fireplace & oversized windows flooding the space with natural light. The well-appointed Chervin kitchen features a lrg centre island, granite counters, premium appliances, under-cabinet lighting, backsplash, & a bright breakfast area with walkout to the backyard & covered back porch. The main flr also offers a private office/potential 6th bedrm, mudrm/laundry rm, & powder rm. Upstairs offers 4 spacious bedrms, including an expansive primary retreat with tray ceiling, feature wall with linear electric fireplace, sitting area, walk-in closet with built-ins, additional dual closets, & a 5-pce ensuite with dual vanities, tiled glass shower, & jacuzzi tub. 3 additional sizable bedrms & a 5-pce main bathrm complete the upper level. The fully finished lower level features a lrg rec rm with electric fireplace, additional bedrm, 3-pce bathrm, wet bar (in-law potential), & ample storage. Hardwood & natural stone flring, custom ceiling treatments, crown moulding, curated millwork, & custom window coverings throughout. Set on a professionally landscaped lot with interlocking driveway, covered back porch, expansive patio, & fully fenced private backyard with mature trees, hardscaping, & perennial gardens. Located just mins to top-rated schools, U of W & Wilfrid Laurier University, RIM Park, Grey Silo Golf Club, trails, St. Jacobs Market, & major commuter routes. A rare opportunity to own a beautifully finished home in one of Waterloo's most desirable neighbourhoods." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-23T16:43:46.057619+00:00" +"CrossStreet": "OAK PARK DRIVE" +"DirectionFaces": "West" +"Directions": "MILLENNIUM BLVD TO OAK PARK DRIVE, THEN DEERFOOT TRAIL." +"Exclusions": "ALL DECORATIVE ITEMS: ARTWORK, MIRRORS, CLOCKS. WALL LIGHTS AND CROWN CANOPY (IN KIDS' ROOMS)." +"ExpirationDate": "2026-07-27" +"ExteriorFeatures": array:4 [ …4] +"FireplaceFeatures": array:5 [ …5] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings, REVERSE OSMOSIS. ALL BATHROOM MIRRORS ONLY. BEVERAGE FRIDGE BASEMENT." +"InteriorFeatures": array:5 [ …5] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-23" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-23T14:58:03Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-23T14:58:03Z" +"OriginalListPrice": 1649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3860170" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "227090567" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-23T14:58:03Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Deerfoot" +"StreetNumber": "325" +"StreetSuffix": "Trail" +"TaxAnnualAmount": "12084.9" +"TaxAssessedValue": 885000 +"TaxLegalDescription": "LOT 140, PLAN 58M506 ;T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 537 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574133 SUBJECT TO AN EASEMENT IN GROSS AS IN WR574226 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST (SEE REMARKS)" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://youriguide.com/325_deerfoot_trail_waterloo_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/325_deerfoot_trail_waterloo_on/" +"VirtualTourURLUnbranded2": "https://youtu.be/Llc Zz MTv NEU" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 108.44 +"LotShape": "Rectangular" +"LotWidth": 59.09 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13035402')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "301601000107179" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2K 0B4, CA" +"ApproximateAge": "6-15" +"AssessmentYear": 2026 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:6 [ …6] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "PLEASE REMOVE SHOES, & ENSURE DOORS ARE LOCKED BEFORE LEAVING. PLEASE LEAVE ALL LIGHTS ON. LB LOCATED TO THE LEFT OF GARAGE, ATTACHED TO THE GATE." +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2026-04-23T14:58:03Z" +"SystemModificationTimestamp": "2026-04-23T14:58:03.640282Z" +"Media": array:50 [ …50] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4322 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "E13024248" +"ListingId": "E13024248" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T14:00:26Z" +"RFModificationTimestamp": "2026-04-26T10:35:38Z" +"ListPrice": 3199900.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Toronto E06" +"PostalCode": "M1N 1H3" +"UnparsedAddress": "63 Fishleigh Drive, Toronto E06, ON M1N 1H3" +"Coordinates": array:2 [ …2] +"Latitude": 43.700884 +"Longitude": -79.246534 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "UNION REALTY BROKERAGE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "In the entire city of Toronto there are only a handful of waterfront single family homes. This is one of them. Welcome to 63 Fishleigh Drive, an extraordinary waterfront residence perched along the edge of the Scarborough Bluffs on a massive 230' deep lot. With nothing between you and the water, the home is defined by its breathtaking sightlines which are showcased through picturesque floor-to-ceiling windows and a private primary balcony overlooking the lake. Inside, thoughtful design meets high-end finishes. This custom built smart home delivers over 5,000 sq ft of refined living space. This stunning home features 5+2 bedrooms and 6 bathrooms, including a main floor office fully customized with wooden trim and cabinetry. The entire back of the house is filled with floor to ceiling windows that flood the main floor with natural light and frame the breathtaking lake views. No detail has been overlooked, with premium finishes throughout, including marble flooring, rich panelled walls, coffered ceilings, cove lighting, and elegant oak hardwood. A grand circular oak staircase and domed ceiling with oculus skylight create a striking architectural statement. The gourmet kitchen is a chef's dream, complete with Sub-Zero and Wolf appliances, quartz-marble countertops, a butler's pantry, and a walkout to a deck that captures the full beauty of the setting. The finished walk-out basement is a true retreat, featuring a private home theatre, custom wet bar, sauna, and a glass-enclosed wine closet, all opening to a beautifully landscaped backyard oasis perched above the shoreline. Additonal features include a double car garage, 200amp panel, central vacuum, security system with full perimeter camera system, landscape irrigation, and much more. This is truly a unique property and a rare opportunity to own one of the city's most exclusive lakefront homes." +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:2 [ …2] +"CityRegion": "Birchcliffe-Cliffside" +"CoListOfficeName": "UNION REALTY BROKERAGE INC." +"CoListOfficePhone": "416-686-9618" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Toronto" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-21T14:03:01.792517+00:00" +"CrossStreet": "Midland and Kingston" +"DirectionFaces": "South" +"Directions": "Right on the water" +"Disclosures": array:1 [ …1] +"ExpirationDate": "2026-10-20" +"ExteriorFeatures": array:6 [ …6] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"HeatingYN": true +"Inclusions": "Sub Zero Fridge, Wolf Stove, Dishwasher, Washer & Dryer and All Elfs, Security System (with central monitoring system and 8 cameras), Central Vac, Sauna, Projector, Audio System & Screen." +"InteriorFeatures": array:7 [ …7] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-21" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "50.00 x 223.00 Feet" +"MainOfficeKey": "182700" +"MajorChangeTimestamp": "2026-04-21T13:53:14Z" +"MlsStatus": "New" +"NewConstructionYN": true +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-21T13:53:14Z" +"OriginalListPrice": 3199900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3839340" +"ParcelNumber": "065130055" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-04-21T13:53:15Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"RoomsTotal": "16" +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Fishleigh" +"StreetNumber": "63" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "19500.69" +"TaxBookNumber": "190101302001700" +"TaxLegalDescription": "LT 12 PL 4072 SCARBOROUGH; TORONTO , CITY OF TORONTO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% plus HST" +"TransactionType": "For Sale" +"View": array:4 [ …4] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=PQHDj WZ5RQ8&wh=0&play=0&vr=0&nozoom=1" +"WaterBodyName": "Lake Ontario" +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 232.5 +"LotShape": "Irregular" +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E13024248')" +"PictureYN": true +"Shoreline": array:1 [ …1] +"WaterView": array:2 [ …2] +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "190101302001600" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"DockingType": array:1 [ …1] +"RentalItems": "Hot Water Tank, A/C Unit, Water Purifying System." +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 4 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 2 +"WashroomsType4": 1 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 16 +"RoomsBelowGrade": 9 +"WaterFrontageFt": "15.24" +"AccessToProperty": array:1 [ …1] +"AlternativePower": array:1 [ …1] +"PropertyFeatures": array:6 [ …6] +"StreetSuffixCode": "Dr" +"BoardPropertyType": "Free" +"PossessionDetails": "TBA" +"ShorelineExposure": "South" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 7 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"WashroomsType5Pcs": 4 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "None" +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Lower" +"WashroomsType5Level": "Lower" +"WaterfrontAccessory": array:1 [ …1] +"MediaChangeTimestamp": "2026-04-21T15:49:15Z" +"MLSAreaDistrictOldZone": "E06" +"MLSAreaDistrictToronto": "E06" +"ShorelineExposureMulti": array:1 [ …1] +"MLSAreaMunicipalityDistrict": "Toronto E06" +"SystemModificationTimestamp": "2026-04-23T14:00:46.993636Z" +"Media": array:50 [ …50] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4321 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12942630" +"ListingId": "X12942630" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T13:03:27Z" +"RFModificationTimestamp": "2026-04-26T10:37:35Z" +"ListPrice": 2199000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 5.87 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "North Dumfries" +"PostalCode": "N1R 5S7" +"UnparsedAddress": "3667 Old Beverly Road, North Dumfries, ON N1R 5S7" +"Coordinates": array:2 [ …2] +"Latitude": 43.3667046 +"Longitude": -80.2185488 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this exceptional country estate set on almost 6 acres of private, picturesque land just minutes from the City of Cambridge. Offering more than 3,850 sq. ft. above grade, plus an unspoiled walk-up basement with impressive 10-foot ceilings, this home blends timeless elegance, everyday comfort, and incredible future potential.The main level is designed for both relaxed living and entertaining, featuring a spacious kitchen with a large pantry, a sun-filled sunroom, a screened-in porch, and multiple inviting living spaces for gathering with family and friends. A separate dining room, private study and three fireplaces, add to the home's warmth and functionality.Upstairs, you'll find four generous bedrooms, including a spacious primary suite with ensuite bath (heated floors), as well as an additional bedroom with a rough-in for a 3-piece bathroom. The basement also includes a bathroom rough-in, offering excellent potential for future finished living space or extended living arrangements, with convenient walk-up access to the garage.Outside, the property continues to impress with a fire pit area, irrigation system, and an expansive driveway leading to the attached 2-car garage. A second detached 2-car garage features a fully equipped studio apartment along with additional flexible space ideal for a home-based business, hobby area, or guest overflow. A charming chicken coop adds to the property's unique country appeal.This is a rare opportunity to enjoy the peace and privacy of country living without sacrificing proximity to city amenities. Please see attached floor plans and full video in the sales brochure." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "4.0" +"CreationDate": "2026-04-10T08:27:09.214578+00:00" +"CrossStreet": "Sheffield Road" +"DirectionFaces": "South" +"Directions": "Coming from Cambridge, just past Sheffield Road on the Right" +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": array:8 [ …8] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer, Central Vac, All window coverings" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-04-01" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2026-04-23T12:44:00Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-01T11:32:07Z" +"OriginalListPrice": 2199000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3740976" +"OtherStructures": array:1 [ …1] +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "12.0" +"PhotosChangeTimestamp": "2026-04-01T11:32:07Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "OLD BEVERLY" +"StreetNumber": "3667" +"StreetSuffix": "Road" +"TaxAnnualAmount": "13648.38" +"TaxLegalDescription": "PT LT 7 CON 8 BEVERLY PT 4, 58R13264; NORTH DUMFRIES. T/W EASEMENT OVER PT OF SAID LOT 7 BEING PT 2 ON 58R-13264 AS IN 1531412" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLBranded": "https://youriguide.com/3667_old_beverly_rd_cambridge_on/" +"VirtualTourURLBranded2": "https://vimeo.com/1125751092/7ea60bb201?share=copy" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/3667_old_beverly_rd_cambridge_on/" +"VirtualTourURLUnbranded2": "https://vimeo.com/1125750966/1e95515671?share=copy" +"WaterSource": array:1 [ …1] +"Zoning": "Z.1 Z.12" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 644.22 +"LotWidth": 398.14 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12942630')" +"GarageType": "Attached" +"HeatSource": "Propane" +"SurveyType": "None" +"RentalItems": "None" +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"SoundBiteUrl": "https://vimeo.com/1125751092/7ea60bb201?share=copy" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 2 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Suspended" +"WashroomsType1": 5 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 16 +"LotSizeAreaUnits": "Acres" +"SalesBrochureUrl": "https://vimeo.com/1125751092/7ea60bb201?share=copy" +"LotSizeRangeAcres": "5-9.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "BROKERBAY" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Second" +"MediaChangeTimestamp": "2026-04-23T13:01:19Z" +"SuspendedEntryTimestamp": "2026-04-16T23:59:02Z" +"SystemModificationTimestamp": "2026-04-23T13:03:41.617385Z" +"SoldConditionalEntryTimestamp": "2026-04-08T19:30:41Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:42 [ …42] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4318 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12902734" +"ListingId": "W12902734" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T13:00:27Z" +"RFModificationTimestamp": "2026-04-26T10:36:18Z" +"ListPrice": 2988000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 7.525 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Milton" +"PostalCode": "L9T 9E2" +"UnparsedAddress": "8656 Esquesing Line, Milton, ON L9T 9E2" +"Coordinates": array:2 [ …2] +"Latitude": 43.5530515 +"Longitude": -79.892222 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 MILLER REAL ESTATE LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 8656 Esquesing Line, a custom- built country estate on a stunning 7. 5- acre property just minutes from Milton, Highway 401, and everyday essentials. Built in 2021, this exceptional home offers 3,154 sq. ft. of above-grade space and a rare combination of modern comfort and peaceful rural surroundings.Surrounded by natural beauty, the property offers ample parking, an oversized main garage, and an additional built- in lower garage. Inside, upscale finishes and thoughtful architectural details create a warm yet sophisticated atmosphere. Premium Kolbe windows bring in abundant natural light, while custom millwork adds character and craftsmanship throughout.The kitchen is a true focal point of the home, featuring imported quartzite countertops, a large chef-inspired island, full-height cabinetry, illuminated display cabinets, and premium integrated appliances. The bedroom layout is equally impressive, with dressing areas and spa-like en-suites finished with curbless glass showers, quartz- topped vanities, custom cabinetry, and large-format tile.Privately positioned, the primary retreat is a standout, complete with a vaulted ceiling, a custom dressing room with a centre island and hidden storage, and a 5-piece ensuite with radiant-heated floors, a soaker tub, and an oversized curbless shower.The unfinished lower level offers an additional 2,063 sq. ft. and is already framed and insulated, with nearly 9-foot ceilings, a bathroom rough-in, direct walkout access to the patio and hot tub area, and a separate entry to its own lower garage. This space offers excellent flexibility for expanded family living, recreational use, or future income opportunities.Outdoors, the 700 sq. ft. rear deck captures stunning panoramic views and beautifully extends the living space. The home is also served by a 400-amp electrical service, ready to support both present and future needs.This is a must- see property for buyers seeking luxury, privacy, and lasting value." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:4 [ …4] +"CityRegion": "1034 - MN Milton North" +"CoListOfficeName": "CENTURY 21 MILLER REAL ESTATE LTD." +"CoListOfficePhone": "905-845-9180" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "3.0" +"CreationDate": "2026-04-16T13:55:43.995344+00:00" +"CrossStreet": "4TH LINE/5 SIDE ROAD" +"DirectionFaces": "West" +"Directions": "Steeles to Esquesing Line south of 5 Side Road on West side of street." +"Disclosures": array:2 [ …2] +"Exclusions": "All wall-mounted TVs, fridge in garage, dining room light fixture, light sconces in primary bedroom." +"ExpirationDate": "2026-09-20" +"ExteriorFeatures": array:8 [ …8] +"FoundationDetails": array:4 [ …4] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Garage Door Openers, Gas Stove, Hot Tub, Hot Tub Equipment, Hot Water Tank Owned, Range Hood, Refrigerator, Starlink satellite, Washer, Window Coverings, Beverage Cooler, Tire racks in the garage, Central vacuum w/accessories, Security camera system and recording equipment, DSC whole-home alarm system (monitoring not included), All bathroom mirrors, All light fixtures (except those excluded.)" +"InteriorFeatures": array:14 [ …14] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-03-20" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "085100" +"MajorChangeTimestamp": "2026-04-23T13:00:27Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-03-20T13:31:15Z" +"OriginalListPrice": 3149900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3651470" +"ParcelNumber": "249770546" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "27.0" +"PhotosChangeTimestamp": "2026-04-23T12:42:16Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 3149900.0 +"PriceChangeTimestamp": "2026-04-23T13:00:27Z" +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Esquesing" +"StreetNumber": "8656" +"StreetSuffix": "Line" +"TaxAnnualAmount": "10432.0" +"TaxAssessedValue": 1263000 +"TaxLegalDescription": "PART LOT 5 CON 4 ESQ AS IN 344209 TOWN OF MILTON & PART LOT 5 CON 4 ESQ AS IN 262457 TOWN OF MILTON" +"TaxYear": "2025" +"Topography": array:4 [ …4] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"View": array:3 [ …3] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/8656_esquesing_line_milton_on/" +"WaterSource": array:3 [ …3] +"Zoning": "RE GA" +"DDFYN": true +"Water": "Well" +"GasYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 538.0 +"LotShape": "Irregular" +"LotWidth": 608.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12902734')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "240905000209200" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "NONE" +"HoldoverDays": 180 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParcelNumber2": 249770547 +"ParkingSpaces": 24 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"RuralUtilities": array:2 [ …2] +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "3000-3500" +"RoomsAboveGrade": 8 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:4 [ …4] +"SalesBrochureUrl": "https://kormendytrott.com/real_estate/8656-esquesing-line/" +"LotSizeRangeAcres": "5-9.99" +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 5 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LeaseToOwnEquipment": array:1 [ …1] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Main" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2026-04-23T12:42:16Z" +"WaterDeliveryFeature": array:2 [ …2] +"SystemModificationTimestamp": "2026-04-23T13:00:48.184455Z" +"Media": array:47 [ …47] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4317 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12821528" +"ListingId": "X12821528" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T03:41:48Z" +"RFModificationTimestamp": "2026-04-26T10:37:16Z" +"ListPrice": 1050000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2S 3Y6" +"UnparsedAddress": "65 Mccaffery Crescent, St. Catharines, ON L2S 3Y6" +"Coordinates": array:2 [ …2] +"Latitude": 43.1241268 +"Longitude": -79.2678296 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning all-brick bungalow with double garage offering over 3,000 sq ft of finished living space in the sought-after Vansickle area. This executive home features 5 bedrooms plus a gym/office and 3 full bathrooms, and impresses from the moment you arrive with its beautiful curb appeal and grand entrance.Inside, you'll find a bright, open layout with a welcoming foyer, hardwood flooring, cathedral ceilings, and decorative pillars throughout the main floor. The formal dining room connects to the well-appointed kitchen through a convenient butler door, while the kitchen itself offers granite countertops, a skylight, and overlooks the dinette with garden doors leading to a large tiered deck, perfect for entertaining. The spacious Great Room features a gas fireplace and California shutters, and the main-level laundry offers direct garage access.The primary bedroom retreat includes a walk-in closet and 5-piece ensuite, while another main-floor bedroom enjoys ensuite privilege. The finished lower level provides two additional bedrooms, a full bathroom, a large rec/games area, storage, and a bonus gym or office space.Additional features include a sprinkler system, BBQ gas line, and (per previous listing) sound-insulated interior walls and RG6 wiring. Located on a quiet street in a fantastic family neighbourhood close to parks, schools, and everyday amenities, and just a short drive to Smart Centres St. Catharines (Fourth Ave) and The Pen Centre.Move-in ready in one of the West End's most desirable pockets. Freestanding home gym/power rack system is negotiable separately from the sale of the home (weights excluded)." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "462 - Rykert/Vansickle" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Niagara" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-23T03:23:32.158314+00:00" +"CrossStreet": "Vansickle Road" +"DirectionFaces": "North" +"Directions": "From Vansickle Rd to Mc Caffery Crescent" +"Exclusions": "The cabinet unit over the toilet in the basement washroom." +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Existing Fridge, Stove, Washer, Dryer, built-in dishwasher and microwave." +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Niagara Association of REALTORS" +"ListingContractDate": "2026-02-26" +"LotSizeDimensions": "114.83 x 54.92" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2026-02-26T05:19:54Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-26T05:19:54Z" +"OriginalListPrice": 1050000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3524426" +"ParcelNumber": "463550208" +"ParkingFeatures": array:2 [ …2] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-04-23T03:16:16Z" +"PoolFeatures": array:1 [ …1] +"PropertyAttachedYN": true +"Roof": array:1 [ …1] +"RoomsTotal": "17" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:3 [ …3] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "MCCAFFERY" +"StreetNumber": "65" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "7224.0" +"TaxBookNumber": "262902003467932" +"TaxLegalDescription": "LOT 46, PLAN 30M272, S/T EASEMENT OVER PT 11 30R9591 AS IN LT177141; ST. CATHARINES" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 114.83 +"LotWidth": 54.92 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12821528')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "262902003467932" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"RentalItems": "Hot Water Heater" +"HoldoverDays": 120 +"WaterMeterYN": true +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "90+ days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:3 [ …3] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "90 days" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2026-04-23T03:16:16Z" +"SystemModificationTimestamp": "2026-04-23T03:42:00.975244Z" +"Media": array:50 [ …50] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4316 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X13004766" +"ListingId": "X13004766" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-23T01:00:46Z" +"RFModificationTimestamp": "2026-04-26T10:38:07Z" +"ListPrice": 1175000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Laurentian Valley" +"PostalCode": "K8A 6W5" +"UnparsedAddress": "740 Walford Road, Laurentian Valley, ON K8A 6W5" +"Coordinates": array:2 [ …2] +"Latitude": 45.7636909 +"Longitude": -77.126506 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXIT OTTAWA VALLEY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 740 Waldorf Road, a stunning 4-bedroom, 3-bathroom home designed for comfort, efficiency, and luxury living. This impressive stucco residence offers exceptional curb appeal with a fully irrigated lawn supported by an in-ground sprinkler system, plus the added convenience of a prepaid lawn maintenance contract for the upcoming spring and summer seasons.Step inside to discover a thoughtfully designed interior featuring soaring 10+ foot ceilings and durable, high-end hard surface flooring throughout, including marble, porcelain tile, and stamped concrete. At the heart of the home is a custom kitchen complete with premium Kitchen Aid appliances, including fridge, stove, and dishwasher-perfect for both everyday living and entertaining.A standout feature of this property is the indoor saltwater pool, surrounded by stamped concrete and supported by a dedicated HRV system to maintain optimal humidity and air quality year-round-creating your own private retreat regardless of the season.The primary suite offers a true spa-like experience with a luxurious 5-piece ensuite. Enjoy a bubble tub with temperature control, dual sinks positioned on opposite sides for added privacy, and a fully accessible open-concept shower design.This home is built with efficiency and peace of mind in mind, featuring in-floor radiant heating (including front covered patio) powered by a boiler system, supplemented by a backup wood furnace and an additional forced air heating system. Air quality is further enhanced with a full-home HRV system. A 16 k W Generac backup generator ensures uninterrupted power, while a comprehensive water filtration system services the home.A rare offering combining quality construction, thoughtful design, and high-end features-this property is truly one-of-a-kind. See video links for more pictures, 3D Tour, floor plans and documents" +"AccessibilityFeatures": array:2 [ …2] +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "531 - Laurentian Valley" +"CoListOfficeName": "EXIT OTTAWA VALLEY REALTY" +"CoListOfficePhone": "613-629-3948" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Renfrew" +"CoveredSpaces": "3.0" +"CreationDate": "2026-04-23T01:07:48.070639+00:00" +"CrossStreet": "hwy 41 and Walford" +"DirectionFaces": "East" +"Directions": "from Hwy 41 to Walford, turn right follow to 740 Walford home is on the left." +"ExpirationDate": "2026-07-10" +"ExteriorFeatures": array:3 [ …3] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Fridge, stove, dishwasher, microwave hoodfan, washer, dryer," +"InteriorFeatures": array:9 [ …9] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Renfrew County Real Estate Board" +"ListingContractDate": "2026-04-15" +"LotSizeSource": "MPAC" +"MainOfficeKey": "488600" +"MajorChangeTimestamp": "2026-04-16T02:05:35Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-04-16T02:05:35Z" +"OriginalListPrice": 1175000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3813404" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "571210124" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "9.0" +"PhotosChangeTimestamp": "2026-04-16T02:05:36Z" +"PoolFeatures": array:2 [ …2] +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Walford" +"StreetNumber": "740" +"StreetSuffix": "Road" +"TaxAnnualAmount": "7521.0" +"TaxLegalDescription": "PT LT 14 CON A ALICE , PTS 2 & 3, 49R9585 TOWNSHIP OF LAURENTIAN VALLEY" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1.625" +"TransactionType": "For Sale" +"View": array:2 [ …2] +"VirtualTourURLUnbranded": "https://listings.revelmarketingagency.com/740-Walford-Rd-Pembroke-ON-K8A-6W5-Canada" +"WaterSource": array:1 [ …1] +"Zoning": "rural residential" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 1223.9 +"LotWidth": 202.09 …43 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4315 …132} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4314 …132} ] +success: true +page_size: 10 +page_count: 43 +count: 421 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4078 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4079 …131} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4080 …146} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4081 …136} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4082 …125} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4083 …121} ] +success: true +page_size: 5 +page_count: 6970 +count: 34848 +after_key: "" } ] ]