Overview

Property ID: 40513306
  • Single Family Residence
  • Property Type
  • 3
  • Bedrooms
  • 1.5
  • Bathrooms
  • 1786
  • Sq Ft
  • 1880
  • Year Built

Description

Rare opportunity to own a landmark Equestrian centre on over 20 acres of farmland on the Beamsville Escarpment! Prime location with 1000′ of frontage and 3 km to town and 6 km to QEW. The main farmhouse was built in 1880 and features an oversized, enclosed front porch in which to sit and enjoy endless views of the countryside. Enter into the spacious living room from which to greet family and friends. Formal dining room with tin ceiling looking over the deck at the back of the home. Country kitchen, laundry room, storage and guest bath off front part of house. The main floor continues with additional family room currently being used as an office and additional sitting/dining rooms, a second enclosed porch and additional storage space. The piece de resistance is the huge deck accessible from the dining room on the main level. The deck overlooks the vast, heart-shaped pond with waterfall and is perfect for dining, grilling and entertaining in the serenity that surrounds this property while enjoying majestic sunsets. Three bedrooms up plus family bath and additional storage. The property has 2 driveways , one leading to the main house and the other to several barns, a large riding arena, an outdoor riding ring and outbuildings. There is a long history of rental income. Barns were built in 1900 and 1968. Property is serviced by several wells, has natural gas, septic tank and bed at house and 2 additional tanks for barns and apartment. Property is being sold in as is/where is condition. Long term development prospects or build your dream estate! Endless possibilities!

  • Address Mountain
  • City Lincoln
  • State/county Niagara
  • Zip/Postal Code L3J 2C6

Details

Updated on January 24, 2024 at 11:28 am
  • Property ID: 40513306
  • Price: $1,649,000
  • Property Size: 1786 Sq Ft
  • Bedrooms: 3
  • Bathrooms: 1.5
  • Year Built: 1880
  • Property Type: Single Family Residence
  • Property Status: Residential

Additional details

  • ITSO_NumberOf2PieceBathrooms: 1
  • CoListAgentCellPhone: 905-380-6410
  • LaundryFeatures: Laundry Room,Main Level
  • PhotosCount: 50
  • WaterfrontFeatures: Pond
  • ITSO_UnderContract: Hot Water Heater
  • Cooling: Central Air
  • ITSO_CoListAgent2Designation: Salesperson
  • AboveGradeFinishedArea: 1786
  • ITSO_SurveyType: Available
  • ListingKeyNumeric: 145319757
  • MajorChangeType: New Listing
  • MLSAreaMajor: Lincoln
  • TaxAnnualAmount: 6000
  • CoListAgentPreferredPhone: 905-688-4561
  • BathroomsTotalDecimal: 1.5
  • OriginatingSystemName: Niagara
  • MlsStatus: Active
  • StreetNumber: 3814
  • ListingKey: 464f012af200497ba316000582ef9395
  • ITSO_StreetViewParam: 1$43.14362751536321$-79.48238865276811$283.94$13.33$1.00$eEDDmfGvH7_ZDB1DM3VPPg
  • Directions: King St to Mountain
  • Roof: Asphalt Shing
  • ParkingTotal: 10
  • CoListOfficeKeyNumeric: 1021794
  • BathroomsFull: 1
  • InternetAddressDisplayYN: 1
  • WaterSource: Drilled Well
  • ITSO_LaundryTotal: 1
  • ITSO_SurveyYear: 2004
  • CoListAgentKeyNumeric: 142045543
  • ParkingFeatures: Gravel
  • Heating: Forced Air,Natural Gas
  • ITSO_NumberOfRoomsAboveGrade: 13
  • BuildingAreaSource: Assessor
  • CoListAgentMlsId: NI6586
  • ITSO_BathsOnLevelSecondCount: 1
  • ITSO_AcresRange: 10-24.99
  • ITSO_BathsTotalRooms: 2
  • BuildingAreaUnits: Square Feet
  • InternetEntireListingDisplayYN: 1
  • ITSO_NumberOf5PlusPieceBathrooms: 0
  • InternetAutomatedValuationDisplayYN: 1
  • ITSO_NumberOf3PieceBathrooms: 0
  • ConstructionMaterials: Vinyl Siding
  • ITSO_LaundryMainCount: 1
  • ITSO_NumberOf4PieceBathrooms: 1
  • ITSO_BedsOnLevelSecondCount: 3
  • InternetConsumerCommentYN: 1
  • BuildingAreaTotal: 1786
  • YearBuiltSource: Other
  • CoListAgentDesignation: Salesperson
  • CoListAgentDirectPhone: 905-688-4561
  • RoomKitchenLevel: Main
  • ITSO_KitchensTotal: 1
  • ITSO_CoListAgent3Designation: Salesperson
  • MajorChangeTimestamp: 2023-11-15T15:18:28.460Z
  • CoListOfficeName: ROYAL LEPAGE NRC REALTY
  • ITSO_PropertyAttached: Detached
  • ITSO_TransactionType: Sale
  • ListingContractDate: 2023-11-15
  • MLSAreaMinor: 982 - Beamsville
  • FarmLandAreaUnits: Square Feet
  • Zoning: NC
  • ITSO_StatusContractualSearchDate: 2023-11-15
  • Basement: Partial,Unfinished
  • ITSO_HSTApplicableToSalePrice: Yes
  • PhotosChangeTimestamp: 2023-11-22T16:26:11.427Z
  • ITSO_BedsAboveGrade: 3
  • CoListOfficeMlsId: NI490
  • ITSO_KitchensBelowGrade: 0
  • AssociationFee2Frequency: Monthly
  • StateOrProvince: ON
  • AboveGradeFinishedAreaUnits: Square Feet
  • CoListAgentEmail: [email protected]
  • BridgeModificationTimestamp: 2024-01-17T06:05:07.670Z
  • MainLevelBathrooms: 1
  • PropertyCondition: 100+ Years
  • FrontageType: East
  • ParcelNumber: 461040889
  • FoundationDetails: Stone
  • View: Pasture,Pond,Trees/Woods
  • ITSO_CurrentPrice: 1649000
  • YearBuiltDetails: Town Records
  • ITSO_DrivewayParking: Private Drive Single Wide
  • StreetSuffix: Road
  • ModificationTimestamp: 2024-01-16T21:14:50.450Z
  • ITSO_CommonInterest: Freehold/None
  • ITSO_NumberOfRoomsBelowGrade: 0
  • Inclusions: Dryer,Refrigerator,Stove,Washer
  • CoListAgentFullName: Lolita Hale
  • BelowGradeFinishedAreaUnits: Square Feet
  • ITSO_Restrictions: Escarpment
  • BathroomsHalf: 1
  • Sewer: Septic Tank
  • AboveGradeFinishedAreaSource: Assessor
  • PatioAndPorchFeatures: Deck
  • ITSO_KitchensAboveGrade: 1
  • ITSO_BedsBelowGrade: 0
  • NumberOfBuildings: 2
  • ITSO_RATIO_CurrentPrice_By_AboveGradeFinishedArea: 923.29227
  • Exclusions: All Tenant's Belongings. See Listing Agent For List And Details.
  • LotFeatures: Rural,Quiet Area
  • NumberOfUnitsTotal: 2
  • ArchitecturalStyle: 1.5 Storey
  • OpenParkingSpaces: 10
  • CoListOfficePhone: 905-688-4561
  • CoListAgentAOR: Niagara Association of REALTORS®
  • FeedTypes: IDX

Mortgage Calculator

Monthly
  • Down Payment
  • Loan Amount
  • Monthly Mortgage Payment
  • Property Tax
  • Home Insurance
  • PMI
  • Monthly HOA Fees
$
%
%
%
$
$
%

Contact Information

View Listings

Enquire About This Property

0 Review

Sort by:
Leave a Review

Leave a Review

Compare listings

Compare