Fullscreen
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=405&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=405&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=405&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=405&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#13876 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13870 +post_id: "395489" +post_author: 1 +"ListingKey": "X12216011" +"ListingId": "X12216011" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:18:02Z" +"RFModificationTimestamp": "2025-07-11T16:51:40.896242+00:00" +"ListPrice": 974900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 16.73 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrickville-wolford" +"PostalCode": "K0G 1G0" +"UnparsedAddress": "315 Gemmell Road, Merrickville-wolford, ON K0G 1G0" +"Coordinates": array:2 [ 0 => -75.9052417 1 => 44.8641637 ] +"Latitude": 44.8641637 +"Longitude": -75.9052417 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX AFFILIATES REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 315 Gemmell Road, a stunning 2016-built bungalow set on 16.73 acres along the banks of the historic Rideau River. Thoughtfully designed for comfort and style, this home features an open-concept main living space filled with natural light from expansive windows and transoms. At the heart of the home is an impressive floor-to-ceiling wood-burning fireplace, creating a warm and inviting focal point. The kitchen offers stainless steel appliances, an island perfect for gathering, and a seamless flow into the dining and living areasideal for everyday living or entertaining. The spacious primary suite includes a walk-in closet, a partially finished ensuite with a soaker tub, double vanity, and shower, as well as private access to the covered back porch where you can enjoy stunning sunsets. A 4-piece main bath, an attached garage, and an unfinished basement with endless potential complete the interior. Outside, a dock awaits at the waters edge, offering access to over 2,600 feet of private shoreline. Beyond the home, the property features a beautiful blend of waterfront and agriculturally zoned land, currently planted in a soy and corn rotation. This unique combination offers endless opportunities, perfect for farmers looking to expand, investors seeking value, or those dreaming of a peaceful homestead in a rural, waterfront setting. Located on a quiet, year-round maintained road just 15 minutes from Smiths Falls, 315 Gemmell Road delivers the perfect balance of modern living, natural beauty, and rural opportunity." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"CityRegion": "805 - Merrickville/Wolford Twp" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": "Central Air" +"CountyOrParish": "Leeds and Grenville" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-12T16:24:04.091781+00:00" +"CrossStreet": "Gemmell Road and Roses Bridge Road" +"DirectionFaces": "East" +"Directions": "From Smiths Falls, take Jasper Avenue towards Jasper, turn left onto Kilmarnock Road, Right onto Roses Bridge Road, Left onto Gemmell Road, the destination is on your left." +"Disclosures": array:1 [ 0 => "Unknown" ] +"Exclusions": "Window Treatments" +"ExpirationDate": "2025-12-02" +"ExteriorFeatures": "Deck,Porch" +"FireplaceFeatures": array:2 [ 0 => "Living Room" 1 => "Wood" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Stove, Fridge, Dishwasher Microwave, Washer, Dryer, HWT" +"InteriorFeatures": "Auto Garage Door Remote,Primary Bedroom - Main Floor,Water Heater Owned" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2025-06-12" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "501500" +"MajorChangeTimestamp": "2025-06-12T16:02:36Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-12T16:02:36Z" +"OriginalListPrice": 974900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2528968" +"ParcelNumber": "681010315" +"ParkingTotal": "9.0" +"PhotosChangeTimestamp": "2025-07-11T15:19:26Z" +"PoolFeatures": "None" +"Roof": "Metal" +"Sewer": "Septic" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Gemmell" +"StreetNumber": "315" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5372.11" +"TaxLegalDescription": "PT LT 23-24 CON A WOLFORD AS IN PR17092 W OF FORCED ROAD EXCEPT 15R7908; MERRICKVILLE-WOLFORD" +"TaxYear": "2024" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "River" ] +"VirtualTourURLUnbranded": "https://view.spiro.media/315_gemmell_rd-5778" +"VirtualTourURLUnbranded2": "https://youtube.com/shorts/1e VOr759Rz0?feature=share" +"WaterBodyName": "Rideau River" +"WaterfrontFeatures": "Dock" +"WaterfrontYN": true +"Zoning": "Agricultural" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotShape": "Irregular" +"LotWidth": 2683.23 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12216011')" +"Shoreline": array:1 [ 0 => "Natural" ] +"WaterView": array:1 [ 0 => "Direct" ] +"GarageType": "Attached" +"HeatSource": "Propane" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "Direct" ] +"DockingType": array:1 [ 0 => "None" ] +"RentalItems": "Propane tanks" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 8 +"WaterBodyType": "River" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 4 +"AccessToProperty": array:1 [ 0 => "Year Round Municipal Road" ] +"AlternativePower": array:1 [ 0 => "None" ] +"LotSizeAreaUnits": "Acres" +"LotSizeRangeAcres": "10-24.99" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "Owned" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WaterfrontAccessory": array:1 [ 0 => "Not Applicable" ] +"MediaChangeTimestamp": "2025-07-11T15:19:26Z" +"SystemModificationTimestamp": "2025-07-11T15:19:26.24278Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:34 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] ] +"ID": "395489" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13872 +post_id: "439115" +post_author: 1 +"ListingKey": "X12275990" +"ListingId": "X12275990" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:48Z" +"RFModificationTimestamp": "2025-07-11T16:51:41.468103+00:00" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.211 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Wellesley" +"PostalCode": "N0B 2T0" +"UnparsedAddress": "19 Zoeger Court, Wellesley, ON N0B 2T0" +"Coordinates": array:2 [ 0 => -80.7689863 1 => 43.4737025 ] +"Latitude": 43.4737025 +"Longitude": -80.7689863 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL BROKER ONTARIO LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 19 Zoeger Ct Wellesley. This property has the dream backyard youve been searching for, with the stunning executive-style home to match.This all-brick bungalow packs over 3,250 sq ft of finished living space, with 4 bedrooms (2+2) and 3 full bathrooms perfect for families, guests, or just spreading out.Step inside through a soaring stone portico into a large, welcoming foyer. Off the foyer is the stunning front living room and formal dining room with large bright windows and hardwood floors. The custom kitchen is full of personality. This stunning space features built-in appliances, a unique glass tile backsplash, and a darling breakfast nook that walks out to your backyard, where you will experience evening sunset views.The cozy family room has a gas fireplace, engineered hardwood floors, and a gorgeous view of the yard. The bedroom wing features a main-floor laundry with inside entry from the oversized garage, a primary suite featuring an ensuite and a WIC, the 2nd bedroom and the guest bathroom with double sinks and a deep tub.Head downstairs to a fully finished lower level with a huge rec room enhanced by rustic barn board ceilings, 2 more large bedrooms, a full bath with a newer double sink vanity, loads of storage room, a TRANE Furnace and AC in 2022, and a walk-up to the garage, great for teens, in-laws, or a home office setup.But lets talk about that backyard, a heated saltwater pool, with a new salt cell replaced in 2024 still under warranty and a new custom Butterfly effect pool liner with upgraded LED pool lights installed in 2024 will keep you loving your life all summer long. You will enjoy the hot tub, the pergola, the shed, and the big fenced yard, perfect for entertaining. Its the kind of outdoor space that makes staying home feel like a vacation.Peaceful, spacious, and move-in ready, just minutes to Kitchener-Waterloo, New Hamburg, and Elmira, this home gives you your small-town feeling but close to every imaginable amenity." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Central Air" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-10T15:34:56.811117+00:00" +"CrossStreet": "Lawrence St, Gerber Rd/Regional Rd 12" +"DirectionFaces": "West" +"Directions": "Head west on Gerber Rd/Regional Rd 12, Turn right onto Lawrence St, Turn right onto Zoeger Ct, Destination will be on the right" +"Exclusions": "robot vacuum for pool" +"ExpirationDate": "2025-10-31" +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "built-in microwave, carbon monoxide detector, central vac, dishwasher, dryer, freezer, garbage door opener, hot tub equipment, range hood, refrigerator, smoke detector, stove, washer, window coverings, Kreepy crawler pool cleaner, manual vacuum, solar blanket, safety cover, hottub, electric fireplace" +"InteriorFeatures": "Auto Garage Door Remote,Built-In Oven,Central Vacuum,Countertop Range,In-Law Capability,Sump Pump,Water Purifier,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-10" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "384000" +"MajorChangeTimestamp": "2025-07-10T15:08:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-10T15:08:16Z" +"OriginalListPrice": 899900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2692520" +"OtherStructures": array:1 [ 0 => "Garden Shed" ] +"ParcelNumber": "221690297" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-11T13:33:36Z" +"PoolFeatures": "Inground,Outdoor" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detectors" 1 => "Smoke Detector" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Zoeger" +"StreetNumber": "19" +"StreetSuffix": "Court" +"TaxAnnualAmount": "5260.38" +"TaxAssessedValue": 433000 +"TaxLegalDescription": "LT 32, PL 58M-110, TWP OF WELLESLEY" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/19_zoeger_ct_wellesley_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/19_zoeger_ct_wellesley_on/" +"Zoning": "Z3" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 140.02 +"LotShape": "Irregular" +"LotWidth": 65.41 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12275990')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "302401000137420" +"SurveyType": "Unknown" +"Winterized": "Fully" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-08-10" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 6 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:2 [ 0 => "School Bus Route" 1 => "Rec./Commun.Centre" ] +"LotIrregularities": "158.56 x 59.16 x 140.02 x 18.39 x 34.34" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "30 days" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Showing system" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2025-07-11T13:33:36Z" +"SystemModificationTimestamp": "2025-07-11T15:17:52.434474Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] +"ID": "439115" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13869 +post_id: "319804" +post_author: 1 +"ListingKey": "C12128856" +"ListingId": "C12128856" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:38Z" +"RFModificationTimestamp": "2025-07-11T16:51:44.411911+00:00" +"ListPrice": 1752400.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Toronto" +"PostalCode": "M4G 1G1" +"UnparsedAddress": "#301 - 3 Southvale Drive, Toronto, On M4g 1g1" +"Coordinates": array:2 [ 0 => -79.3645108 1 => 43.699689 ] +"Latitude": 43.699689 +"Longitude": -79.3645108 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BRIDLEPATH PROGRESSIVE REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Quiet & Serene 2 Bedroom Plus Den with Exquisite Craftmanship & Keen Attention to Detail in a Perfect Blend of Style & Community. A Boutique Building with Ten minute Accessibility to Downtown Via Bayview Extension & Walking Distance to Restaurants & Best Shops. Bldg Offers Exclusive Access To All the Luxury Amenities You Need. There is Even a Grooming Room For Your Pet. Ready to Move In. Includes 4 Parking Spots & 1 Locker." +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:3 [ 0 => "BBQs Allowed" 1 => "Exercise Room" 2 => "Party Room/Meeting Room" ] +"AssociationFee": "1530.52" +"AssociationFeeIncludes": array:5 [ 0 => "Heat Included" 1 => "Building Insurance Included" 2 => "Common Elements Included" 3 => "Water Included" 4 => "CAC Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Leaside" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": "Central Air" +"CountyOrParish": "Toronto" +"CoveredSpaces": "4.0" +"CreationDate": "2025-05-06T22:36:44.614624+00:00" +"CrossStreet": "Millwood /Laird" +"Directions": "Millwood/Laird" +"ExpirationDate": "2025-09-05" +"FireplaceYN": true +"GarageYN": true +"Inclusions": "All furnishings in the suite, Miele appliances, gas cooktop, Stainless Steel BBQ on balcony, smart 85" TV, Linear Fireplace, window shades (motorized) Solid core doors, 10" baseboards, remotely operated locks, Italian cabinetry & vanities, conduits for EV. 4 Parking spots & 1 Locker." +"InteriorFeatures": "Other,Built-In Oven" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-06" +"MainOfficeKey": "020800" +"MajorChangeTimestamp": "2025-05-06T21:01:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-05-06T21:01:14Z" +"OriginalListPrice": 1752400.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2347786" +"ParkingFeatures": "None" +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-04T15:12:45Z" +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Southvale" +"StreetNumber": "3" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "6995.53" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3% net of HST" +"TransactionType": "For Sale" +"UnitNumber": "301" +"DDFYN": true +"Locker": "Owned" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('C12128856')" +"GarageType": "Underground" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "3" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 2833 +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"SquareFootSource": "Floor plan" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LegalApartmentNumber": "01" +"MediaChangeTimestamp": "2025-07-04T15:12:45Z" +"PropertyManagementCompany": "Canlight Mangement" +"SystemModificationTimestamp": "2025-07-11T15:17:39.608281Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:33 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] ] +"ID": "319804" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13873 +post_id: "411543" +post_author: 1 +"ListingKey": "X12235308" +"ListingId": "X12235308" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:18Z" +"RFModificationTimestamp": "2025-07-11T16:51:47.891338+00:00" +"ListPrice": 1199900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Guelph" +"PostalCode": "N1G 4M2" +"UnparsedAddress": "8 Youngman Drive, Guelph, ON N1G 4M2" +"Coordinates": array:2 [ …2] +"Latitude": 43.518973 +"Longitude": -80.2269306 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Royal City Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Set in the heart of Guelph's desirable Kortright West neighbourhood, 8 Youngman Drive is a thoughtfully updated family home offering an accessory 1-bed apartment & charming inground pool. With three excellent schools just a short walk away & countless amenities and Uo G nearby, this location presents exceptional convenience with a warm community feel. Just minutes from Preservation Park & its network of scenic walking trails. Lovingly owned & cared for by the same family for the past 31 years, this home has great bones, a functional layout, & room to grow. The welcoming main floor features a large foyer and updated laundry room (2023) with custom cabinetry, garage access, side yard access, & a 3pc bath. Upstairs, you'll find three generous bedrooms, including a spacious primary with a bay window, walk-in and additional closet, and a beautifully updated 3pc ensuite (2022). One of the homes greatest assets is its legal 1-bedroom accessory apartment, complete with a den, separate entrance, in-suite laundry, and updated kitchen (2023). Currently rented month-to-month at $1,800/m , the suite offers flexibility & additional income. This private backyard escape is centered around the gorgeous inground pool, visible and inviting whether you're outside or relaxing indoors. Surrounded by greenspace for kids and pets to play, a large composite deck (2021), shed/pool house, beautifully maintained gardens & lawns, and landscape lighting, its the perfect space to relax or entertain. The curb appeal shines with updated fascia, soffits, siding, and garage door (2024), interlock driveway (2018), and meticulous landscaping. Extras include: 200 amp electrical panel (2023), newer furnace (2019), roof (approx 10 yr). Please see supplements for list of features & updates. This is the ideal home for families looking to plant roots, grow, and enjoy all that it has to offer!" +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ …2] +"CityRegion": "Kortright West" +"CoListOfficeName": "Royal Le Page Royal City Realty" +"CoListOfficePhone": "519-824-9050" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Wellington" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-20T14:55:48.647718+00:00" +"CrossStreet": "Edinburgh Rd S and Stone Rd." +"DirectionFaces": "West" +"Directions": "Edinburgh Rd S to Youngman Dr." +"Exclusions": "EV Charger and 6 gauge cable." +"ExpirationDate": "2025-08-19" +"ExteriorFeatures": "Deck,Landscape Lighting,Landscaped,Lighting,Patio,Porch" +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Refrigerator x 2, Stove x 2, Washer x 2, Dryer x 2, Carbon Monoxide Detector, Central Vac, Dishwasher, Freezer in Basement, Garage Door Opener, Smoke Detector, Window Coverings, Pool Equipment" +"InteriorFeatures": "Accessory Apartment,Auto Garage Door Remote,Central Vacuum,Floor Drain,Water Heater,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2025-06-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "558500" +"MajorChangeTimestamp": "2025-06-20T14:49:14Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2025-06-20T14:49:14Z" +"OriginalListPrice": 1199900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2574502" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "712250041" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-06-26T17:32:02Z" +"PoolFeatures": "Outdoor,Inground" +"Roof": "Shingles" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ …2] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Youngman" +"StreetNumber": "8" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "8544.0" +"TaxLegalDescription": "Lot 73, Plan 727 ; GUELPH" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5 + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/8-Youngman-Dr" +"VirtualTourURLBranded2": "https://www.andraarnold.com/properties/8-youngman-drive-guelph-ontario-n1g-4m2" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/8-Youngman-Dr/idx" +"Zoning": "RL.2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Baseboard" +"LotDepth": 148.79 +"LotWidth": 55.77 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12235308')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "230806000943701" +"SurveyType": "Unknown" +"RentalItems": "HWT" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"SoundBiteUrl": "https://www.andraarnold.com/properties/8-youngman-drive-guelph-ontario-n1g-4m2" +"KitchensTotal": 2 +"ParkingSpaces": 6 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2025-08-29" +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 13 +"RoomsBelowGrade": 9 +"PropertyFeatures": array:4 [ …4] +"SalesBrochureUrl": "https://www.andraarnold.com/properties/8-youngman-drive-guelph-ontario-n1g-4m2" +"PossessionDetails": "Aug 29 but flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Easy to show" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-06-26T17:32:03Z" +"SystemModificationTimestamp": "2025-07-11T15:17:22.976947Z" +"Media": array:46 [ …46] +"ID": "411543" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13871 +post_id: "411460" +post_author: 1 +"ListingKey": "X12238693" +"ListingId": "X12238693" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:10Z" +"RFModificationTimestamp": "2025-07-11T16:54:29.032137+00:00" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1082.0 +"City": "Cambridge" +"PostalCode": "N1R 0C9" +"UnparsedAddress": "#g218 - 450 Hespeler Road, Cambridge, ON N1R 0C9" +"Coordinates": array:2 [ …2] +"Latitude": 43.3600536 +"Longitude": -80.3123023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SAVE MAX SUPREME REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "1082 sq ft Prime Office Space with 5 Offices in the Main Artery and Business District of Cambridge Just a Few Blocks South of 401. Ideal Space for Professional Offices such as Real Estate, Law, Accounting, Mortgage, Consulting, Employment, Travel, IT Specialist, Insurance and much more! Corner Unit with Lots of Glass Windows. Across from Cambridge Park Mall, Steps from Transportation and every Amenity. This Commercial Plaza with 3 Freestanding Buildings (approximately 80,000 sq. ft) has Excellent Exposure with 301 Feet of Frontage onto Hespeler Rd. Daily Traffic Roughly 50,000 cars. With the Numerous Stores and the Shopping Mall Nearby, the Cambridge Gateway Centre can become the Incubator for your Business's Success. Don't Miss Out on this Rare Location!!!" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Major Highway,Public Transit" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-06-23T03:03:09.824755+00:00" +"CrossStreet": "Bishop St N & Hespeler Road" +"Directions": "Bishop St N & Hespeler Road" +"ExpirationDate": "2025-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-17" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "x" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "326900" +"MajorChangeTimestamp": "2025-06-23T02:57:07Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-23T02:57:07Z" +"OriginalListPrice": 799900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2603706" +"PhotosChangeTimestamp": "2025-07-11T15:16:25Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "HESPELER" +"StreetNumber": "450" +"StreetSuffix": "Road" +"TaxAnnualAmount": "0.01" +"TaxBookNumber": "000000000000000" +"TaxLegalDescription": "LT 60,62 RCP 1374 CAMBRIDGE; CAMBRIDGE. PT LT 61 1374 CAMBRIDGE PT 1 58R15402 : CAMBRIDGE" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "G218" +"Utilities": "Yes" +"VirtualTourURLUnbranded": "https://youtu.be/i JZuu SQNE1M" +"Zoning": "C4" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12238693')" +"GarageType": "Outside/Surface" +"RollNumber": "0" +"PropertyUse": "Office" +"ElevatorType": "Public" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"ApproximateAge": "New" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"LotIrregularities": "CONDO" +"PossessionDetails": "FLEXIBLE" +"OfficeApartmentArea": 1082.0 +"MediaChangeTimestamp": "2025-07-11T15:16:25Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-07-11T15:17:10.116083Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:38 [ …38] +"ID": "411460" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13868 +post_id: "437746" +post_author: 1 +"ListingKey": "X12277248" +"ListingId": "X12277248" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:05Z" +"RFModificationTimestamp": "2025-07-11T16:51:51.400471+00:00" +"ListPrice": 949900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 5E6" +"UnparsedAddress": "37 Riviera Ridge, Hamilton, ON L8E 5E6" +"Coordinates": array:2 [ …2] +"Latitude": 43.2205401 +"Longitude": -79.6472956 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Absolutely Stunning Renovated 3+1 Bedroom 4 Bathroom home close to the lake! Inside and out, meticulously maintained! Approx. 3100sqft of luxurious living space! Tons of natural light throughout! The living room flows nicely to the formal dining area with entrance to the stunning gourmet kitchen -- with access to the backyard which overlooks the family room with gas fireplace! Renovations include: newly open concept kitchen with granite counters, massive island, stainless steel appliances, 24x24 porcelain tiles, crown moulding, doors and hardware, pot lights, light fixtures, bathrooms, hardwood floors, rec room with wet bar and gas fireplace hookups! Professionally Painted! CCTV cameras! Owned tankless hot water heater! Newer Hi Eff Furnace & A/C! Polished concrete and sealed garage floor! 3 car interlocking driveway! Private Backyard Oasis! Spacious front foyer! Close proximity to Lake Ontario and many amenities, this family-focused locale offers excellent schools, parks, and shopping and is minutes to the QEW!A must see!" +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Winona Park" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-10T20:40:27.695017+00:00" +"CrossStreet": "NORTH SERVICE ROAD - BELLAVISTA GATE - RIVIERA RIDGE" +"DirectionFaces": "North" +"Directions": "NORTH SERVICE ROAD - BELLAVISTA GATE - RIVIERARIDGE" +"Exclusions": "Four flat screen T.V's" +"ExpirationDate": "2025-12-10" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "FRIDGE, STOVE, Microwave, DISHWASHER, WASHER, DRYER, ALL WINDOW COVERINGS, All electrical light fixtures. Don't miss this one!" +"InteriorFeatures": "Central Vacuum,Storage,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-10" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2025-07-10T19:43:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-10T19:43:50Z" +"OriginalListPrice": 949900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2694908" +"ParkingFeatures": "Private Double" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-07-10T22:57:51Z" +"PoolFeatures": "None" +"Roof": "Other" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Riviera" +"StreetNumber": "37" +"StreetSuffix": "Ridge" +"TaxAnnualAmount": "5973.91" +"TaxLegalDescription": "PCL 104-1, SEC 62M665 ; LT 104, PL 62M665" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://tours.vision360tours.ca/37-riviera-ridge-hamilton/nb/" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 135.52 +"LotWidth": 49.21 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12277248')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"RentalItems": "None" +"HoldoverDays": 90 +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 4 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2025-07-11T15:17:05Z" +"SystemModificationTimestamp": "2025-07-11T15:17:08.188788Z" +"Media": array:31 [ …31] +"ID": "437746" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13867 +post_id: "431475" +post_author: 1 +"ListingKey": "X12244192" +"ListingId": "X12244192" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:16:55Z" +"RFModificationTimestamp": "2025-07-11T16:51:55.743009+00:00" +"ListPrice": 1695000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.16 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0E7" +"UnparsedAddress": "779 Snowberry Court, Waterloo, MI N2V 0E7" +"Coordinates": array:2 [ …2] +"Latitude": 43.4626654 +"Longitude": -80.6025367 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ICON REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Vista Hills. Place you would like to be and grow. Welcome to 779 Snowberry court, an excellent family dwelling built by reputable builder "Fusion Homes" on premium corner lot. Families living in this very sought after neighborhood are surrounded by massive forest with numerous historic trails, mountain cycling tracks and mature wild life and greenery. Vista hills make you feel you live in full consensus with Mother Nature by at the time minutes drive from the best schools of all levels, Costco, shopping of all kinds, fine restaurants and fast food joints, open 24/7. Banks, medical offices and government organizations are with in reach at your convenience too. Let me tell you a few words about the house, which is not the right word to describe it. It is definitely a HOME not just a house. Impressive more than 5230 sq. feet spread between 3 levels filled with natural light and abundance of space. I can write 10 thousand words but still won't be able to describe fully and truly all the features and upgrades of this beautiful property. As an example: LEGAL DUPLEX registered with the city of Waterloo with professionally done side separate entrance, EV charger, high quality CAT cable wired throughout the house, 200 AMP electrical panel, laundry on the second floor, speaker wiring trough out all the house including back yard with connections provided to install the control panel in the basement, chair lift (25K worth) installed on gorgeous wooden staircase and much, much more. You absolutely must come and see it yourself, I promise you won't be disappointed." +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-25T14:55:52.788857+00:00" +"CrossStreet": "Autumn Willow Drive" +"DirectionFaces": "East" +"Directions": "COLUMBIA ST. W. TO SUNDEW DR. TO ROCK ELM ST. TO PASTURE ROSE ST. TO SNOWBERRY COURT" +"Exclusions": "all wall mount tvsall wall mount tvs" +"ExpirationDate": "2025-09-24" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave (AS IS word in offer pls), Dishwasher, Dryer, Gas Stove, Range Hood, Washer, Built-In Appliances, ERV/HRV, Sump Pump, Ventilation System, Water Heater, Water Softener, Fridge, Built-in Microwave, Dishwasher, Dryer, Gas Stove, Range Hood, Washer, Built-In Appliances, ERV/HRV, Sump Pump, Ventilation System, Water Heater, Water Softener, Fridge" +"InteriorFeatures": "In-Law Suite,Central Vacuum,Garburator,Storage,Storage Area Lockers,Sump Pump,Ventilation System,Water Softener,Water Heater,ERV/HRV,Auto Garage Door Remote" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-24" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "322400" +"MajorChangeTimestamp": "2025-07-07T11:54:43Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-25T14:39:08Z" +"OriginalListPrice": 1495000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2616950" +"ParcelNumber": "226845414" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-06-25T14:39:08Z" +"PoolFeatures": "None" +"PreviousListPrice": 1495000.0 +"PriceChangeTimestamp": "2025-07-07T11:54:43Z" +"Roof": "Asphalt Shingle" +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Snowberry" +"StreetNumber": "779" +"StreetSuffix": "Court" +"TaxAnnualAmount": "10637.44" +"TaxLegalDescription": "LOT 33, PLAN 58M602 SUBJECT TO AN EASEMENT IN GROSS OVER PART 33 ON 58R19761 AS IN WR1032899 SUBJECT TO AN EASEMENT IN GROSS OVER PART 33 ON 58R19761 AS IN WR1032966 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/779-Snowberry-Cthttps://media.visualadvantage.ca/779-Snowberry-Ct" +"VirtualTourURLBranded2": "https://youtu.be/Wl0Gt Km3w Zc" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/779-Snowberry-Ct/idx" +"Zoning": "R6" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 105.49 +"LotWidth": 61.68 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12244192')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "301604000115347" +"SurveyType": "None" +"RentalItems": "HWT" +"HoldoverDays": 7 +"KitchensTotal": 2 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2025-08-27" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 16 +"RoomsBelowGrade": 3 +"LotSizeAreaUnits": "Acres" +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 5 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Second" +"MediaChangeTimestamp": "2025-07-07T11:54:43Z" +"SystemModificationTimestamp": "2025-07-11T15:17:01.082535Z" +"GreenPropertyInformationStatement": true +"Media": array:50 [ …50] +"ID": "431475" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13874 +post_id: "434212" +post_author: 1 +"ListingKey": "N12264550" +"ListingId": "N12264550" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:16:55Z" +"RFModificationTimestamp": "2025-07-11T16:51:56.790744+00:00" +"ListPrice": 1088800.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6269.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Richmond Hill" +"PostalCode": "L4E 3B2" +"UnparsedAddress": "42 Willowbank Avenue, Richmond Hill, ON L4E 3B2" +"Coordinates": array:2 [ …2] +"Latitude": 43.9525114 +"Longitude": -79.4374826 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE YOUR COMMUNITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Inviting Family Home Steps to Lake Wilcox with Private Lakefront Beach Access .Welcome to this custom 3-bed, 4-bath home on a quiet cul-de-sac in a highly sought-after family community. Enjoy deeded access to the private Elmwood Beach Club with beach, boat launch ramp , and bonfire area ideal for creating unforgettable family memories. This oversized corner lot features a brand new driveway, fully fenced yard, double garage has direct Entrance to Home, and two 8x8 sheds for flexible use (storage, workshop, studio, etc.). Spacious side yard with a separate basement entrance potential. Inside, enjoy updated hardwood floors on main and upper level, new windows and sliding doors (2023), a large eat-in kitchen, family room with gas fireplace, and a covered back porch for year-round outdoor living. Upstairs boasts 3 spacious bedrooms . Primary has a renovated ensuite with walk-in closet . Main bath features gorgeous skylight . Main floor laundry and powder room add convenience for busy families. The finished lower level includes above-grade windows, a rec room, 3-pc bath, cold room, and new high-efficiency furnace. This home offers comfort, privacy, and lake lifestyle living all in one! Full home inspection and list of updates available" +"ArchitecturalStyle": "2-Storey" +"Basement": array:1 [ …1] +"CityRegion": "Oak Ridges Lake Wilcox" +"ConstructionMaterials": array:1 [ …1] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "York" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-05T00:10:27.105366+00:00" +"CrossStreet": "Bayview/North Lake" +"DirectionFaces": "West" +"Directions": "Bayview to Northlake Rd." +"Exclusions": "Bedroom Mirror, Fire Pit Grill, small Windmill" +"ExpirationDate": "2025-09-06" +"ExteriorFeatures": "Deck,Landscaped" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Washer, Dryer, Stainless Whirlpool Fridge Ice Dispenser/Water, Whirlpool Dishwasher, Ceran-top self clean Whirlpool Stove , SS Hood -Fan, all Light-fixtures, 2 exterior Cielings Fans+ remote, Blinds, Garage door-opener+ 1 Remote, Fire-Pit Bowl, Storage Box in Side yard, 2 Garden Sheds, Prime Bedroom Wardrobe +Dresser, Central Air, Hot water Tank, Roof Antenna ( free Channels)" +"InteriorFeatures": "Auto Garage Door Remote,Water Heater Owned,Water Purifier" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-04" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "087000" +"MajorChangeTimestamp": "2025-07-05T00:02:51Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-05T00:02:51Z" +"OriginalListPrice": 1088800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2664544" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "032020080" +"ParkingFeatures": "Private Double" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-05T00:36:23Z" +"PoolFeatures": "None" +"Roof": "Shingles" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Willowbank" +"StreetNumber": "42" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "5932.93" +"TaxLegalDescription": "Plan 240, Pt Lt 60, RS65R16651,Part 1" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"View": array:2 [ …2] +"VirtualTourURLBranded": "http://www.ivrtours.com/viewer.php?tourid=27719" +"VirtualTourURLUnbranded": "http://www.ivrtours.com/unbranded.php?tourid=27719" +"WaterBodyName": "Wilcox Lake" +"WaterfrontFeatures": "Beach Front,Boat Launch,Waterfront-Deeded Access" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.07 +"LotShape": "Irregular" +"LotWidth": 76.44 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12264550')" +"WaterView": array:1 [ …1] +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "193807002511950" +"SurveyType": "Available" +"Waterfront": array:1 [ …1] +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "30/60 TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-07-11T15:16:55Z" +"SystemModificationTimestamp": "2025-07-11T15:16:58.148569Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:49 [ …49] +"ID": "434212" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13875 +post_id: "404486" +post_author: 1 +"ListingKey": "X12232015" +"ListingId": "X12232015" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:16:40Z" +"RFModificationTimestamp": "2025-07-11T16:52:51.953064+00:00" +"ListPrice": 989999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0.11 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2M 1X2" +"UnparsedAddress": "37 Brock Street, Kitchener, ON N2M 1X2" +"Coordinates": array:2 [ …2] +"Latitude": 43.4416794 +"Longitude": -80.4989791 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Royal City Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Don't be fooled by first impressions, this stunning red brick home offers over 3,200 square feet of beautifully finished living space. Nestled on a stately, tree-lined street just steps from Victoria Park, St. Mary's Hospital, the Iron Horse Trail, and vibrant Downtown Kitchener, the location is as charming as it is convenient. From the moment you arrive, you'll appreciate the long private driveway, welcoming covered front porch, and elegant newer front doors. Inside, the carpet-free main floor features a formal living room, a sunlit dining room, and a fully renovated kitchen designed to impress with abundant cabinetry, stainless steel appliances, a large island, quartz countertops, and a cozy eat-in area. A stylish 2-piece bath and main floor laundry provide added functionality, with direct access to a covered rear deck and fully fenced backyard oasis. Step outside and discover your own private retreat, complete with a recently built bunkie/life accessory building, a versatile space that can become whatever your heart desires: a home office, yoga studio, art space, or guest hideaway. Upstairs, the expansive primary bedroom features wall-to-wall closets and is joined by three additional bedrooms, a separate shower, and a generous 3-piece bathroom with a relaxing jetted tub. The fully finished walk-up attic offers an additional flexible space, ideal as a studio, playroom, or guest suite.The lower level is fully finished and offers even more living potential with a cozy recreation room, a craft room, and an office that could easily serve as an additional bedroom with a walk-in closet. You'll also find a 2-piece rough-in bath, ample storage, and a utility room with a walk-up to the driveway and separate entrance, making it perfect for an in-law suite or potential rental income. Thoughtfully updated and impeccably maintained, this home delivers space, character, and endless versatility in a truly exceptional location." +"ArchitecturalStyle": "3-Storey" +"Basement": array:2 [ …2] +"CoListOfficeName": "ROYAL LEPAGE WOLLE REALTY" +"CoListOfficePhone": "519-578-7300" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-06-19T23:22:51.522513+00:00" +"CrossStreet": "Queen St S" +"DirectionFaces": "South" +"Directions": "Queen St S" +"Exclusions": "Brewing equipment" +"ExpirationDate": "2025-09-26" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Dishwasher, Dryer, Gas oven/ Range, Gas Stove, Range Hood, Refrigerator, Washer, Window Coverings" +"InteriorFeatures": "Upgraded Insulation,Water Softener" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2025-06-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "558500" +"MajorChangeTimestamp": "2025-06-19T14:16:30Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-19T14:16:30Z" +"OriginalListPrice": 989999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2578140" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "224310105" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-26T17:28:36Z" +"PoolFeatures": "None" +"Roof": "Asphalt Shingle" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Brock" +"StreetNumber": "37" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5073.91" +"TaxLegalDescription": "LT 20 PL 158 KITCHENER; KITCHENER" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/37-Brock-St" +"VirtualTourURLBranded2": "https://www.andraarnold.com/properties/37-brock-street-kitchener-ontario-n2m-1x2" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/37-Brock-St/idx" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 122.5 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12232015')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301205000500700" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"SoundBiteUrl": "https://www.andraarnold.com/properties/37-brock-street-kitchener-ontario-n2m-1x2" +"KitchensTotal": 1 +"ParkingSpaces": 3 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 17 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:4 [ …4] +"SalesBrochureUrl": "https://www.andraarnold.com/properties/37-brock-street-kitchener-ontario-n2m-1x2" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 1 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 6 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-06-26T17:28:36Z" +"SystemModificationTimestamp": "2025-07-11T15:16:45.13061Z" +"Media": array:45 [ …45] +"ID": "404486" } ] +success: true +page_size: 9 +page_count: 13809 +count: 124277 +after_key: "" } "RF Response Time" => "0.59 seconds" ] "RF Cache Key: 9aa92c2272238489db7048b8cd258ff77f43e9d702f6f6e8c81781a8adffb219" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14130 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13891 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12216011" +"ListingId": "X12216011" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:18:02Z" +"RFModificationTimestamp": "2025-07-11T16:51:40.896242+00:00" +"ListPrice": 974900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 16.73 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Merrickville-wolford" +"PostalCode": "K0G 1G0" +"UnparsedAddress": "315 Gemmell Road, Merrickville-wolford, ON K0G 1G0" +"Coordinates": array:2 [ …2] +"Latitude": 44.8641637 +"Longitude": -75.9052417 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX AFFILIATES REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 315 Gemmell Road, a stunning 2016-built bungalow set on 16.73 acres along the banks of the historic Rideau River. Thoughtfully designed for comfort and style, this home features an open-concept main living space filled with natural light from expansive windows and transoms. At the heart of the home is an impressive floor-to-ceiling wood-burning fireplace, creating a warm and inviting focal point. The kitchen offers stainless steel appliances, an island perfect for gathering, and a seamless flow into the dining and living areasideal for everyday living or entertaining. The spacious primary suite includes a walk-in closet, a partially finished ensuite with a soaker tub, double vanity, and shower, as well as private access to the covered back porch where you can enjoy stunning sunsets. A 4-piece main bath, an attached garage, and an unfinished basement with endless potential complete the interior. Outside, a dock awaits at the waters edge, offering access to over 2,600 feet of private shoreline. Beyond the home, the property features a beautiful blend of waterfront and agriculturally zoned land, currently planted in a soy and corn rotation. This unique combination offers endless opportunities, perfect for farmers looking to expand, investors seeking value, or those dreaming of a peaceful homestead in a rural, waterfront setting. Located on a quiet, year-round maintained road just 15 minutes from Smiths Falls, 315 Gemmell Road delivers the perfect balance of modern living, natural beauty, and rural opportunity." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "805 - Merrickville/Wolford Twp" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Leeds and Grenville" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-12T16:24:04.091781+00:00" +"CrossStreet": "Gemmell Road and Roses Bridge Road" +"DirectionFaces": "East" +"Directions": "From Smiths Falls, take Jasper Avenue towards Jasper, turn left onto Kilmarnock Road, Right onto Roses Bridge Road, Left onto Gemmell Road, the destination is on your left." +"Disclosures": array:1 [ …1] +"Exclusions": "Window Treatments" +"ExpirationDate": "2025-12-02" +"ExteriorFeatures": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Stove, Fridge, Dishwasher Microwave, Washer, Dryer, HWT" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2025-06-12" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "501500" +"MajorChangeTimestamp": "2025-06-12T16:02:36Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-12T16:02:36Z" +"OriginalListPrice": 974900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2528968" +"ParcelNumber": "681010315" +"ParkingTotal": "9.0" +"PhotosChangeTimestamp": "2025-07-11T15:19:26Z" +"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": "Gemmell" +"StreetNumber": "315" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5372.11" +"TaxLegalDescription": "PT LT 23-24 CON A WOLFORD AS IN PR17092 W OF FORCED ROAD EXCEPT 15R7908; MERRICKVILLE-WOLFORD" +"TaxYear": "2024" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://view.spiro.media/315_gemmell_rd-5778" +"VirtualTourURLUnbranded2": "https://youtube.com/shorts/1e VOr759Rz0?feature=share" +"WaterBodyName": "Rideau River" +"WaterfrontFeatures": array:1 [ …1] +"WaterfrontYN": true +"Zoning": "Agricultural" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotShape": "Irregular" +"LotWidth": 2683.23 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12216011')" +"Shoreline": array:1 [ …1] +"WaterView": array:1 [ …1] +"GarageType": "Attached" +"HeatSource": "Propane" +"SurveyType": "Unknown" +"Waterfront": array:1 [ …1] +"DockingType": array:1 [ …1] +"RentalItems": "Propane tanks" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 8 +"WaterBodyType": "River" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 4 +"AccessToProperty": array:1 [ …1] +"AlternativePower": array:1 [ …1] +"LotSizeAreaUnits": "Acres" +"LotSizeRangeAcres": "10-24.99" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"ShorelineAllowance": "Owned" +"SpecialDesignation": array:1 [ …1] +"WaterfrontAccessory": array:1 [ …1] +"MediaChangeTimestamp": "2025-07-11T15:19:26Z" +"SystemModificationTimestamp": "2025-07-11T15:19:26.24278Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:34 [ …34] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13854 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12275990" +"ListingId": "X12275990" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:48Z" +"RFModificationTimestamp": "2025-07-11T16:51:41.468103+00:00" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.211 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Wellesley" +"PostalCode": "N0B 2T0" +"UnparsedAddress": "19 Zoeger Court, Wellesley, ON N0B 2T0" +"Coordinates": array:2 [ …2] +"Latitude": 43.4737025 +"Longitude": -80.7689863 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL BROKER ONTARIO LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 19 Zoeger Ct Wellesley. This property has the dream backyard youve been searching for, with the stunning executive-style home to match.This all-brick bungalow packs over 3,250 sq ft of finished living space, with 4 bedrooms (2+2) and 3 full bathrooms perfect for families, guests, or just spreading out.Step inside through a soaring stone portico into a large, welcoming foyer. Off the foyer is the stunning front living room and formal dining room with large bright windows and hardwood floors. The custom kitchen is full of personality. This stunning space features built-in appliances, a unique glass tile backsplash, and a darling breakfast nook that walks out to your backyard, where you will experience evening sunset views.The cozy family room has a gas fireplace, engineered hardwood floors, and a gorgeous view of the yard. The bedroom wing features a main-floor laundry with inside entry from the oversized garage, a primary suite featuring an ensuite and a WIC, the 2nd bedroom and the guest bathroom with double sinks and a deep tub.Head downstairs to a fully finished lower level with a huge rec room enhanced by rustic barn board ceilings, 2 more large bedrooms, a full bath with a newer double sink vanity, loads of storage room, a TRANE Furnace and AC in 2022, and a walk-up to the garage, great for teens, in-laws, or a home office setup.But lets talk about that backyard, a heated saltwater pool, with a new salt cell replaced in 2024 still under warranty and a new custom Butterfly effect pool liner with upgraded LED pool lights installed in 2024 will keep you loving your life all summer long. You will enjoy the hot tub, the pergola, the shed, and the big fenced yard, perfect for entertaining. Its the kind of outdoor space that makes staying home feel like a vacation.Peaceful, spacious, and move-in ready, just minutes to Kitchener-Waterloo, New Hamburg, and Elmira, this home gives you your small-town feeling but close to every imaginable amenity." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-10T15:34:56.811117+00:00" +"CrossStreet": "Lawrence St, Gerber Rd/Regional Rd 12" +"DirectionFaces": "West" +"Directions": "Head west on Gerber Rd/Regional Rd 12, Turn right onto Lawrence St, Turn right onto Zoeger Ct, Destination will be on the right" +"Exclusions": "robot vacuum for pool" +"ExpirationDate": "2025-10-31" +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "built-in microwave, carbon monoxide detector, central vac, dishwasher, dryer, freezer, garbage door opener, hot tub equipment, range hood, refrigerator, smoke detector, stove, washer, window coverings, Kreepy crawler pool cleaner, manual vacuum, solar blanket, safety cover, hottub, electric fireplace" +"InteriorFeatures": array:8 [ …8] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-10" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "384000" +"MajorChangeTimestamp": "2025-07-10T15:08:16Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-10T15:08:16Z" +"OriginalListPrice": 899900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2692520" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "221690297" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-11T13:33:36Z" +"PoolFeatures": array:2 [ …2] +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Zoeger" +"StreetNumber": "19" +"StreetSuffix": "Court" +"TaxAnnualAmount": "5260.38" +"TaxAssessedValue": 433000 +"TaxLegalDescription": "LT 32, PL 58M-110, TWP OF WELLESLEY" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/19_zoeger_ct_wellesley_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/19_zoeger_ct_wellesley_on/" +"Zoning": "Z3" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 140.02 +"LotShape": "Irregular" +"LotWidth": 65.41 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12275990')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "302401000137420" +"SurveyType": "Unknown" +"Winterized": "Fully" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2025-08-10" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 6 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:2 [ …2] +"LotIrregularities": "158.56 x 59.16 x 140.02 x 18.39 x 34.34" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "30 days" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Showing system" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Basement" +"MediaChangeTimestamp": "2025-07-11T13:33:36Z" +"SystemModificationTimestamp": "2025-07-11T15:17:52.434474Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ …50] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13865 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "C12128856" +"ListingId": "C12128856" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:38Z" +"RFModificationTimestamp": "2025-07-11T16:51:44.411911+00:00" +"ListPrice": 1752400.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Toronto C11" +"PostalCode": "M4G 1G1" +"UnparsedAddress": "#301 - 3 Southvale Drive, Toronto, On M4g 1g1" +"Coordinates": array:2 [ …2] +"Latitude": 43.699689 +"Longitude": -79.3645108 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BRIDLEPATH PROGRESSIVE REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Quiet & Serene 2 Bedroom Plus Den with Exquisite Craftmanship & Keen Attention to Detail in a Perfect Blend of Style & Community. A Boutique Building with Ten minute Accessibility to Downtown Via Bayview Extension & Walking Distance to Restaurants & Best Shops. Bldg Offers Exclusive Access To All the Luxury Amenities You Need. There is Even a Grooming Room For Your Pet. Ready to Move In. Includes 4 Parking Spots & 1 Locker." +"ArchitecturalStyle": array:1 [ …1] +"AssociationAmenities": array:3 [ …3] +"AssociationFee": "1530.52" +"AssociationFeeIncludes": array:5 [ …5] +"Basement": array:1 [ …1] +"CityRegion": "Leaside" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Toronto" +"CoveredSpaces": "4.0" +"CreationDate": "2025-05-06T22:36:44.614624+00:00" +"CrossStreet": "Millwood /Laird" +"Directions": "Millwood/Laird" +"ExpirationDate": "2025-09-05" +"FireplaceYN": true +"GarageYN": true +"Inclusions": "All furnishings in the suite, Miele appliances, gas cooktop, Stainless Steel BBQ on balcony, smart 85" TV, Linear Fireplace, window shades (motorized) Solid core doors, 10" baseboards, remotely operated locks, Italian cabinetry & vanities, conduits for EV. 4 Parking spots & 1 Locker." +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-06" +"MainOfficeKey": "020800" +"MajorChangeTimestamp": "2025-05-06T21:01:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-05-06T21:01:14Z" +"OriginalListPrice": 1752400.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2347786" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "4.0" +"PetsAllowed": array:1 [ …1] +"PhotosChangeTimestamp": "2025-07-04T15:12:45Z" +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Southvale" +"StreetNumber": "3" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "6995.53" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3% net of HST" +"TransactionType": "For Sale" +"UnitNumber": "301" +"DDFYN": true +"Locker": "Owned" +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('C12128856')" +"GarageType": "Underground" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "3" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 2833 +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"SquareFootSource": "Floor plan" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"LegalApartmentNumber": "01" +"MediaChangeTimestamp": "2025-07-04T15:12:45Z" +"PropertyManagementCompany": "Canlight Mangement" +"SystemModificationTimestamp": "2025-07-11T15:17:39.608281Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:33 [ …33] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13864 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12235308" +"ListingId": "X12235308" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:18Z" +"RFModificationTimestamp": "2025-07-11T16:51:47.891338+00:00" +"ListPrice": 1199900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Guelph" +"PostalCode": "N1G 4M2" +"UnparsedAddress": "8 Youngman Drive, Guelph, ON N1G 4M2" +"Coordinates": array:2 [ …2] +"Latitude": 43.518973 +"Longitude": -80.2269306 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Royal City Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Set in the heart of Guelph's desirable Kortright West neighbourhood, 8 Youngman Drive is a thoughtfully updated family home offering an accessory 1-bed apartment & charming inground pool. With three excellent schools just a short walk away & countless amenities and Uo G nearby, this location presents exceptional convenience with a warm community feel. Just minutes from Preservation Park & its network of scenic walking trails. Lovingly owned & cared for by the same family for the past 31 years, this home has great bones, a functional layout, & room to grow. The welcoming main floor features a large foyer and updated laundry room (2023) with custom cabinetry, garage access, side yard access, & a 3pc bath. Upstairs, you'll find three generous bedrooms, including a spacious primary with a bay window, walk-in and additional closet, and a beautifully updated 3pc ensuite (2022). One of the homes greatest assets is its legal 1-bedroom accessory apartment, complete with a den, separate entrance, in-suite laundry, and updated kitchen (2023). Currently rented month-to-month at $1,800/m , the suite offers flexibility & additional income. This private backyard escape is centered around the gorgeous inground pool, visible and inviting whether you're outside or relaxing indoors. Surrounded by greenspace for kids and pets to play, a large composite deck (2021), shed/pool house, beautifully maintained gardens & lawns, and landscape lighting, its the perfect space to relax or entertain. The curb appeal shines with updated fascia, soffits, siding, and garage door (2024), interlock driveway (2018), and meticulous landscaping. Extras include: 200 amp electrical panel (2023), newer furnace (2019), roof (approx 10 yr). Please see supplements for list of features & updates. This is the ideal home for families looking to plant roots, grow, and enjoy all that it has to offer!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CityRegion": "Kortright West" +"CoListOfficeName": "Royal Le Page Royal City Realty" +"CoListOfficePhone": "519-824-9050" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Wellington" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-20T14:55:48.647718+00:00" +"CrossStreet": "Edinburgh Rd S and Stone Rd." +"DirectionFaces": "West" +"Directions": "Edinburgh Rd S to Youngman Dr." +"Exclusions": "EV Charger and 6 gauge cable." +"ExpirationDate": "2025-08-19" +"ExteriorFeatures": array:6 [ …6] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Refrigerator x 2, Stove x 2, Washer x 2, Dryer x 2, Carbon Monoxide Detector, Central Vac, Dishwasher, Freezer in Basement, Garage Door Opener, Smoke Detector, Window Coverings, Pool Equipment" +"InteriorFeatures": array:6 [ …6] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2025-06-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "558500" +"MajorChangeTimestamp": "2025-06-20T14:49:14Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2025-06-20T14:49:14Z" +"OriginalListPrice": 1199900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2574502" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "712250041" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-06-26T17:32:02Z" +"PoolFeatures": array:2 [ …2] +"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": "Youngman" +"StreetNumber": "8" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "8544.0" +"TaxLegalDescription": "Lot 73, Plan 727 ; GUELPH" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5 + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/8-Youngman-Dr" +"VirtualTourURLBranded2": "https://www.andraarnold.com/properties/8-youngman-drive-guelph-ontario-n1g-4m2" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/8-Youngman-Dr/idx" +"Zoning": "RL.2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Baseboard" +"LotDepth": 148.79 +"LotWidth": 55.77 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12235308')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "230806000943701" +"SurveyType": "Unknown" +"RentalItems": "HWT" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"SoundBiteUrl": "https://www.andraarnold.com/properties/8-youngman-drive-guelph-ontario-n1g-4m2" +"KitchensTotal": 2 +"ParkingSpaces": 6 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2025-08-29" +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 13 +"RoomsBelowGrade": 9 +"PropertyFeatures": array:4 [ …4] +"SalesBrochureUrl": "https://www.andraarnold.com/properties/8-youngman-drive-guelph-ontario-n1g-4m2" +"PossessionDetails": "Aug 29 but flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 5 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"ShowingAppointments": "Easy to show" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-06-26T17:32:03Z" +"SystemModificationTimestamp": "2025-07-11T15:17:22.976947Z" +"Media": array:46 [ …46] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11212 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12238693" +"ListingId": "X12238693" +"PropertyType": "Commercial Sale" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:10Z" +"RFModificationTimestamp": "2025-07-11T16:54:29.032137+00:00" +"ListPrice": 799900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1082.0 +"City": "Cambridge" +"PostalCode": "N1R 0C9" +"UnparsedAddress": "#g218 - 450 Hespeler Road, Cambridge, ON N1R 0C9" +"Coordinates": array:2 [ …2] +"Latitude": 43.3600536 +"Longitude": -80.3123023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SAVE MAX SUPREME REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "1082 sq ft Prime Office Space with 5 Offices in the Main Artery and Business District of Cambridge Just a Few Blocks South of 401. Ideal Space for Professional Offices such as Real Estate, Law, Accounting, Mortgage, Consulting, Employment, Travel, IT Specialist, Insurance and much more! Corner Unit with Lots of Glass Windows. Across from Cambridge Park Mall, Steps from Transportation and every Amenity. This Commercial Plaza with 3 Freestanding Buildings (approximately 80,000 sq. ft) has Excellent Exposure with 301 Feet of Frontage onto Hespeler Rd. Daily Traffic Roughly 50,000 cars. With the Numerous Stores and the Shopping Mall Nearby, the Cambridge Gateway Centre can become the Incubator for your Business's Success. Don't Miss Out on this Rare Location!!!" +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-06-23T03:03:09.824755+00:00" +"CrossStreet": "Bishop St N & Hespeler Road" +"Directions": "Bishop St N & Hespeler Road" +"ExpirationDate": "2025-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-17" +"LotFeatures": array:1 [ …1] +"LotSizeDimensions": "x" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "326900" +"MajorChangeTimestamp": "2025-06-23T02:57:07Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-23T02:57:07Z" +"OriginalListPrice": 799900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2603706" +"PhotosChangeTimestamp": "2025-07-11T15:16:25Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "HESPELER" +"StreetNumber": "450" +"StreetSuffix": "Road" +"TaxAnnualAmount": "0.01" +"TaxBookNumber": "000000000000000" +"TaxLegalDescription": "LT 60,62 RCP 1374 CAMBRIDGE; CAMBRIDGE. PT LT 61 1374 CAMBRIDGE PT 1 58R15402 : CAMBRIDGE" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "G218" +"Utilities": array:1 [ …1] +"VirtualTourURLUnbranded": "https://youtu.be/i JZuu SQNE1M" +"Zoning": "C4" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12238693')" +"GarageType": "Outside/Surface" +"RollNumber": "0" +"PropertyUse": "Office" +"ElevatorType": "Public" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"ApproximateAge": "New" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"LotIrregularities": "CONDO" +"PossessionDetails": "FLEXIBLE" +"OfficeApartmentArea": 1082.0 +"MediaChangeTimestamp": "2025-07-11T15:16:25Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-07-11T15:17:10.116083Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:38 [ …38] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13887 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12277248" +"ListingId": "X12277248" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:17:05Z" +"RFModificationTimestamp": "2025-07-11T16:51:51.400471+00:00" +"ListPrice": 949900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 5E6" +"UnparsedAddress": "37 Riviera Ridge, Hamilton, ON L8E 5E6" +"Coordinates": array:2 [ …2] +"Latitude": 43.2205401 +"Longitude": -79.6472956 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Absolutely Stunning Renovated 3+1 Bedroom 4 Bathroom home close to the lake! Inside and out, meticulously maintained! Approx. 3100sqft of luxurious living space! Tons of natural light throughout! The living room flows nicely to the formal dining area with entrance to the stunning gourmet kitchen -- with access to the backyard which overlooks the family room with gas fireplace! Renovations include: newly open concept kitchen with granite counters, massive island, stainless steel appliances, 24x24 porcelain tiles, crown moulding, doors and hardware, pot lights, light fixtures, bathrooms, hardwood floors, rec room with wet bar and gas fireplace hookups! Professionally Painted! CCTV cameras! Owned tankless hot water heater! Newer Hi Eff Furnace & A/C! Polished concrete and sealed garage floor! 3 car interlocking driveway! Private Backyard Oasis! Spacious front foyer! Close proximity to Lake Ontario and many amenities, this family-focused locale offers excellent schools, parks, and shopping and is minutes to the QEW!A must see!" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Winona Park" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-10T20:40:27.695017+00:00" +"CrossStreet": "NORTH SERVICE ROAD - BELLAVISTA GATE - RIVIERA RIDGE" +"DirectionFaces": "North" +"Directions": "NORTH SERVICE ROAD - BELLAVISTA GATE - RIVIERARIDGE" +"Exclusions": "Four flat screen T.V's" +"ExpirationDate": "2025-12-10" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "FRIDGE, STOVE, Microwave, DISHWASHER, WASHER, DRYER, ALL WINDOW COVERINGS, All electrical light fixtures. Don't miss this one!" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-10" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2025-07-10T19:43:50Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-10T19:43:50Z" +"OriginalListPrice": 949900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2694908" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-07-10T22:57:51Z" +"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": "Riviera" +"StreetNumber": "37" +"StreetSuffix": "Ridge" +"TaxAnnualAmount": "5973.91" +"TaxLegalDescription": "PCL 104-1, SEC 62M665 ; LT 104, PL 62M665" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://tours.vision360tours.ca/37-riviera-ridge-hamilton/nb/" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 135.52 +"LotWidth": 49.21 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12277248')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"RentalItems": "None" +"HoldoverDays": 90 +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 4 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 2 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2025-07-11T15:17:05Z" +"SystemModificationTimestamp": "2025-07-11T15:17:08.188788Z" +"Media": array:31 [ …31] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13888 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12244192" +"ListingId": "X12244192" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:16:55Z" +"RFModificationTimestamp": "2025-07-11T16:51:55.743009+00:00" +"ListPrice": 1695000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.16 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2V 0E7" +"UnparsedAddress": "779 Snowberry Court, Waterloo, MI N2V 0E7" +"Coordinates": array:2 [ …2] +"Latitude": 43.4626654 +"Longitude": -80.6025367 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ICON REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Vista Hills. Place you would like to be and grow. Welcome to 779 Snowberry court, an excellent family dwelling built by reputable builder "Fusion Homes" on premium corner lot. Families living in this very sought after neighborhood are surrounded by massive forest with numerous historic trails, mountain cycling tracks and mature wild life and greenery. Vista hills make you feel you live in full consensus with Mother Nature by at the time minutes drive from the best schools of all levels, Costco, shopping of all kinds, fine restaurants and fast food joints, open 24/7. Banks, medical offices and government organizations are with in reach at your convenience too. Let me tell you a few words about the house, which is not the right word to describe it. It is definitely a HOME not just a house. Impressive more than 5230 sq. feet spread between 3 levels filled with natural light and abundance of space. I can write 10 thousand words but still won't be able to describe fully and truly all the features and upgrades of this beautiful property. As an example: LEGAL DUPLEX registered with the city of Waterloo with professionally done side separate entrance, EV charger, high quality CAT cable wired throughout the house, 200 AMP electrical panel, laundry on the second floor, speaker wiring trough out all the house including back yard with connections provided to install the control panel in the basement, chair lift (25K worth) installed on gorgeous wooden staircase and much, much more. You absolutely must come and see it yourself, I promise you won't be disappointed." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-25T14:55:52.788857+00:00" +"CrossStreet": "Autumn Willow Drive" +"DirectionFaces": "East" +"Directions": "COLUMBIA ST. W. TO SUNDEW DR. TO ROCK ELM ST. TO PASTURE ROSE ST. TO SNOWBERRY COURT" +"Exclusions": "all wall mount tvsall wall mount tvs" +"ExpirationDate": "2025-09-24" +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Built-in Microwave (AS IS word in offer pls), Dishwasher, Dryer, Gas Stove, Range Hood, Washer, Built-In Appliances, ERV/HRV, Sump Pump, Ventilation System, Water Heater, Water Softener, Fridge, Built-in Microwave, Dishwasher, Dryer, Gas Stove, Range Hood, Washer, Built-In Appliances, ERV/HRV, Sump Pump, Ventilation System, Water Heater, Water Softener, Fridge" +"InteriorFeatures": array:11 [ …11] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-24" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "322400" +"MajorChangeTimestamp": "2025-07-07T11:54:43Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-25T14:39:08Z" +"OriginalListPrice": 1495000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2616950" +"ParcelNumber": "226845414" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-06-25T14:39:08Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 1495000.0 +"PriceChangeTimestamp": "2025-07-07T11:54:43Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Snowberry" +"StreetNumber": "779" +"StreetSuffix": "Court" +"TaxAnnualAmount": "10637.44" +"TaxLegalDescription": "LOT 33, PLAN 58M602 SUBJECT TO AN EASEMENT IN GROSS OVER PART 33 ON 58R19761 AS IN WR1032899 SUBJECT TO AN EASEMENT IN GROSS OVER PART 33 ON 58R19761 AS IN WR1032966 CITY OF WATERLOO" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/779-Snowberry-Cthttps://media.visualadvantage.ca/779-Snowberry-Ct" +"VirtualTourURLBranded2": "https://youtu.be/Wl0Gt Km3w Zc" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/779-Snowberry-Ct/idx" +"Zoning": "R6" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 105.49 +"LotWidth": 61.68 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12244192')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "301604000115347" +"SurveyType": "None" +"RentalItems": "HWT" +"HoldoverDays": 7 +"KitchensTotal": 2 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionDate": "2025-08-27" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 16 +"RoomsBelowGrade": 3 +"LotSizeAreaUnits": "Acres" +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 5 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Second" +"MediaChangeTimestamp": "2025-07-07T11:54:43Z" +"SystemModificationTimestamp": "2025-07-11T15:17:01.082535Z" +"GreenPropertyInformationStatement": true +"Media": array:50 [ …50] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13889 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "N12264550" +"ListingId": "N12264550" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:16:55Z" +"RFModificationTimestamp": "2025-07-11T16:51:56.790744+00:00" +"ListPrice": 1088800.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6269.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Richmond Hill" +"PostalCode": "L4E 3B2" +"UnparsedAddress": "42 Willowbank Avenue, Richmond Hill, ON L4E 3B2" +"Coordinates": array:2 [ …2] +"Latitude": 43.9525114 +"Longitude": -79.4374826 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE YOUR COMMUNITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Inviting Family Home Steps to Lake Wilcox with Private Lakefront Beach Access .Welcome to this custom 3-bed, 4-bath home on a quiet cul-de-sac in a highly sought-after family community. Enjoy deeded access to the private Elmwood Beach Club with beach, boat launch ramp , and bonfire area ideal for creating unforgettable family memories. This oversized corner lot features a brand new driveway, fully fenced yard, double garage has direct Entrance to Home, and two 8x8 sheds for flexible use (storage, workshop, studio, etc.). Spacious side yard with a separate basement entrance potential. Inside, enjoy updated hardwood floors on main and upper level, new windows and sliding doors (2023), a large eat-in kitchen, family room with gas fireplace, and a covered back porch for year-round outdoor living. Upstairs boasts 3 spacious bedrooms . Primary has a renovated ensuite with walk-in closet . Main bath features gorgeous skylight . Main floor laundry and powder room add convenience for busy families. The finished lower level includes above-grade windows, a rec room, 3-pc bath, cold room, and new high-efficiency furnace. This home offers comfort, privacy, and lake lifestyle living all in one! Full home inspection and list of updates available" +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "Oak Ridges Lake Wilcox" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "York" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-05T00:10:27.105366+00:00" +"CrossStreet": "Bayview/North Lake" +"DirectionFaces": "West" +"Directions": "Bayview to Northlake Rd." +"Exclusions": "Bedroom Mirror, Fire Pit Grill, small Windmill" +"ExpirationDate": "2025-09-06" +"ExteriorFeatures": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"Inclusions": "Washer, Dryer, Stainless Whirlpool Fridge Ice Dispenser/Water, Whirlpool Dishwasher, Ceran-top self clean Whirlpool Stove , SS Hood -Fan, all Light-fixtures, 2 exterior Cielings Fans+ remote, Blinds, Garage door-opener+ 1 Remote, Fire-Pit Bowl, Storage Box in Side yard, 2 Garden Sheds, Prime Bedroom Wardrobe +Dresser, Central Air, Hot water Tank, Roof Antenna ( free Channels)" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-04" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "087000" +"MajorChangeTimestamp": "2025-07-05T00:02:51Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-05T00:02:51Z" +"OriginalListPrice": 1088800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2664544" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "032020080" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-05T00:36:23Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Willowbank" +"StreetNumber": "42" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "5932.93" +"TaxLegalDescription": "Plan 240, Pt Lt 60, RS65R16651,Part 1" +"TaxYear": "2025" +"Topography": array:1 [ …1] +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"View": array:2 [ …2] +"VirtualTourURLBranded": "http://www.ivrtours.com/viewer.php?tourid=27719" +"VirtualTourURLUnbranded": "http://www.ivrtours.com/unbranded.php?tourid=27719" +"WaterBodyName": "Wilcox Lake" +"WaterfrontFeatures": array:3 [ …3] +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.07 +"LotShape": "Irregular" +"LotWidth": 76.44 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12264550')" +"WaterView": array:1 [ …1] +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "193807002511950" +"SurveyType": "Available" +"Waterfront": array:1 [ …1] +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 3 +"PropertyFeatures": array:6 [ …6] +"PossessionDetails": "30/60 TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-07-11T15:16:55Z" +"SystemModificationTimestamp": "2025-07-11T15:16:58.148569Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:49 [ …49] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13890 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12232015" +"ListingId": "X12232015" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T15:16:40Z" +"RFModificationTimestamp": "2025-07-11T16:52:51.953064+00:00" +"ListPrice": 989999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0.11 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2M 1X2" +"UnparsedAddress": "37 Brock Street, Kitchener, ON N2M 1X2" +"Coordinates": array:2 [ …2] +"Latitude": 43.4416794 +"Longitude": -80.4989791 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Royal Le Page Royal City Realty" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Don't be fooled by first impressions, this stunning red brick home offers over 3,200 square feet of beautifully finished living space. Nestled on a stately, tree-lined street just steps from Victoria Park, St. Mary's Hospital, the Iron Horse Trail, and vibrant Downtown Kitchener, the location is as charming as it is convenient. From the moment you arrive, you'll appreciate the long private driveway, welcoming covered front porch, and elegant newer front doors. Inside, the carpet-free main floor features a formal living room, a sunlit dining room, and a fully renovated kitchen designed to impress with abundant cabinetry, stainless steel appliances, a large island, quartz countertops, and a cozy eat-in area. A stylish 2-piece bath and main floor laundry provide added functionality, with direct access to a covered rear deck and fully fenced backyard oasis. Step outside and discover your own private retreat, complete with a recently built bunkie/life accessory building, a versatile space that can become whatever your heart desires: a home office, yoga studio, art space, or guest hideaway. Upstairs, the expansive primary bedroom features wall-to-wall closets and is joined by three additional bedrooms, a separate shower, and a generous 3-piece bathroom with a relaxing jetted tub. The fully finished walk-up attic offers an additional flexible space, ideal as a studio, playroom, or guest suite.The lower level is fully finished and offers even more living potential with a cozy recreation room, a craft room, and an office that could easily serve as an additional bedroom with a walk-in closet. You'll also find a 2-piece rough-in bath, ample storage, and a utility room with a walk-up to the driveway and separate entrance, making it perfect for an in-law suite or potential rental income. Thoughtfully updated and impeccably maintained, this home delivers space, character, and endless versatility in a truly exceptional location." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:2 [ …2] +"CoListOfficeName": "ROYAL LEPAGE WOLLE REALTY" +"CoListOfficePhone": "519-578-7300" +"ConstructionMaterials": array:2 [ …2] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-06-19T23:22:51.522513+00:00" +"CrossStreet": "Queen St S" +"DirectionFaces": "South" +"Directions": "Queen St S" +"Exclusions": "Brewing equipment" +"ExpirationDate": "2025-09-26" +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ …1] +"Inclusions": "Dishwasher, Dryer, Gas oven/ Range, Gas Stove, Range Hood, Refrigerator, Washer, Window Coverings" +"InteriorFeatures": array:2 [ …2] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2025-06-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "558500" +"MajorChangeTimestamp": "2025-06-19T14:16:30Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-19T14:16:30Z" +"OriginalListPrice": 989999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2578140" +"OtherStructures": array:2 [ …2] +"ParcelNumber": "224310105" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-26T17:28:36Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:2 [ …2] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Brock" +"StreetNumber": "37" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5073.91" +"TaxLegalDescription": "LT 20 PL 158 KITCHENER; KITCHENER" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/37-Brock-St" +"VirtualTourURLBranded2": "https://www.andraarnold.com/properties/37-brock-street-kitchener-ontario-n2m-1x2" +"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/37-Brock-St/idx" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 122.5 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12232015')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301205000500700" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"SoundBiteUrl": "https://www.andraarnold.com/properties/37-brock-street-kitchener-ontario-n2m-1x2" +"KitchensTotal": 1 +"ParkingSpaces": 3 +"UnderContract": array:1 [ …1] +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 17 +"RoomsBelowGrade": 6 +"PropertyFeatures": array:4 [ …4] +"SalesBrochureUrl": "https://www.andraarnold.com/properties/37-brock-street-kitchener-ontario-n2m-1x2" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 1 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 6 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-06-26T17:28:36Z" +"SystemModificationTimestamp": "2025-07-11T15:16:45.13061Z" +"Media": array:45 [ …45] } ] +success: true +page_size: 9 +page_count: 13809 +count: 124277 +after_key: "" } ] ]
