Header

 

logo

header

$1,248,800
Available - For Sale
Listing ID: X12420323
Custom Waterfront Masterpiece. Welcome to 37 Front Street West, Hastings a one-of-a-kind custom-built residence with upgrades and finishes you'd expect to see in a magazine. Perfectly set along the Trent River, part of the Trent-Severn Waterway, this 3-bedroom, 4-bathroom home offers panoramic water views from every level. Inside, enjoy a gourmet kitchen, open concept dining and family areas, and spa-inspired bathrooms all crafted with premium materials and modern elegance. Expansive windows and multiple balconies capture both sunrises and sunsets over the river, bringing natural beauty into daily living. Outdoors, the massive 200-foot deep yard provides endless space for entertaining, recreation, or future enhancements. A rare find, the oversized 3-car garage features a rear door with direct access to the backyard perfect for storing a boat or water toys. This property is more than a home its a lifestyle of boating, fishing, and year-round waterfront enjoyment. A rare opportunity to own a brand-new custom build in Hastings that combines luxury, comfort, and the very best of waterfront living.
Price $1,248,800
Taxes: $2,310.08
Occupancy by: Owner
Address: 37 Front Stre , Trent Hills, K0L 1Y0, Northumberland
Directions/Cross Streets: Front St West at Elizabeth St
Rooms: 9
Bedrooms: 3
Bedrooms +: 0
Washrooms: 4
Family Room: T
Basement: Finished wit
  Level/Floor Room Length(ft) Width(ft) Descriptions
Room 1: Main Recreatio 16.10 14.10
Room 2: Second Kitchen 21.68 15.71
Room 3: Second Dining Ro 21.68 15.71 Combined w/Kitchen
Room 4: Second Family Ro 17.58 15.71
Room 5: Second Office 8.99 7.90
Room 6: Third Primary B 18.50 16.99
Room 7: Third Bedroom 2 14.07 13.61
Room 8: Second Bedroom 3 14.07 13.61
No. of Pieces Level
Washroom 1:  5 Second
Washroom 2:  3 Second
Washroom 3:  2 Ground
Washroom 4:  2 Lower
Washroom 5:  0
Washroom 6:  5 Second
Washroom 7:  3 Second
Washroom 8:  2 Ground
Washroom 9:  2 Lower
Washroom 10:  0
Washroom 11:  5 Second
Washroom 12:  3 Second
Washroom 13:  2 Ground
Washroom 14:  2 Lower
Washroom 15:  0
Property Type: Detached
Style: 2-Storey
Exterior: Stone
Garage Type: Built-In
(Parking/)Drive: Private
Drive Parking Spaces: 4
Park #1
Parking Type: Private
Park #2
Parking Type: Private
Pool: None
Approximatly Age: New
Approximatly Square Footage: 2000-2500
Property Features: Fenced Yard
Electric Car Charg
CAC Included: N
Water Included: N
Cabel TV Included: N
Common Elements Included: N
Heat Included: N
Parking Included: N
Condo Tax Included: N
Building Insurance Included: N
Fireplace/Stove: Y
Heat Type: Forced Air
Central Air Conditioning: Central Air
Central Vac: N
Laundry Level: Syste
Ensuite Laundry: F
Sewers: Sewer
First Name: *
Last Name: *
Phone: *
Email: *
Showing Date:
Showing Time:
I Am Thinking of Moving
 
First Name: *
Last Name: *
Phone: *
Email: *

Message:

From:

Name:
Email:

To:

Name:
Email:

Comment:

 

Down payment: $  
Interest Rate: %  
Amortization :  Years
Payment Frequency:
Your Payment:
This calculator is for demonstration purposes only. Always consult a professional financial advisor before making personal financial decisions.
Asking Price: $ Heating: $ /Year  
Interest Rate: % Condo Fee: $ /Year
Taxes:   $ /Year Other Debt: $ /Year  
Amortization:     Years GDS: %
    TDS: %
Percent Down:
Down Payment $ $ $ $
First Mortgage $ $ $ $
CMHC/GE $ $ $ $
Total Financing $ $ $ $
Monthly P&I $ $ $ $
Expenses $ $ $ $
Total Payment $ $ $ $
Income Required $ $ $ $

This chart is for demonstration purposes only. Always consult a professional financial advisor before making personal financial decisions.

Although the information displayed is believed to be accurate, no warranties or representations are made of any kind.
CENTURY 21 HERITAGE GROUP LTD.

37 Front Stre , Trent Hills, K0L 1Y0, Northumberland


 
 Virtual Tour   Book Showing   Email a Friend 
Jump To:
At a Glance:
Type: Freehold - Detached
Area: Northumberland
Municipality: Trent Hills
Neighbourhood: Hastings
Style: 2-Storey
Lot Size: x 200.00(Feet)
Approximate Age: New
Tax: $2,310.08
Maintenance Fee: $0
Beds: 3
Baths: 4
Garage: 0
Fireplace: Y
Air Conditioning:
Pool: None
Locatin Map:
View Larger Map
Payment Calculator:
Price:
Down Payment: %
Rate: %
Amortization:  Years
Frequency
Calculate
Down Payment:
Mortgage Payment:
This calculator is for demonstration purposes only. Always consult a professional financial advisor before making personal financial decisions.
Listing info
Description
General Details
Room & Interior
Exterior
Utilities
Get More Info:
Book Showing
Request More Info
Email Friend
Photos and movies:
View Slide Show
View All Photos
Virtual Tour
Calculator:
Affordability Chart
Mortgage Calculator
More To Do:
Print This Page

Listing added to compare list, click here  to view comparison chart.
!-- start of askavenue script -->