WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dc6.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dc7.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dc8.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) INNER JOIN DZl3SCX_postmeta AS mt2 ON ( DZl3SCX_posts.ID = mt2.post_id ) INNER JOIN DZl3SCX_postmeta AS mt3 ON ( DZl3SCX_posts.ID = mt3.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = 'wpcb_enabled' AND DZl3SCX_postmeta.meta_value = '1' ) AND ( mt1.meta_key = 'wpcb_run_type' AND mt1.meta_value = 'always' ) AND (( mt2.meta_key = 'wpcb_where_to_run' AND mt2.meta_value = 'custom' ) OR ( mt3.meta_key = 'wpcb_code_type' AND mt3.meta_value != 'php' ) )) AND DZl3SCX_posts.post_type = 'wpcb_snippet_post' GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.menu_order

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dc9.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_postmeta`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dca.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = 'elementskit_template_activation' AND DZl3SCX_postmeta.meta_value = 'yes' ) ) AND DZl3SCX_posts.post_type = 'elementskit_template' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dcb.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( DZl3SCX_postmeta.meta_key = '_seopress_redirections_enabled_regex' AND DZl3SCX_postmeta.meta_value = 'yes' ) AND ( ( mt1.meta_key = '_seopress_redirections_logged_status' AND mt1.meta_value = 'only_not_logged_in' ) OR ( mt1.meta_key = '_seopress_redirections_logged_status' AND mt1.meta_value = 'both' ) ) ) AND DZl3SCX_posts.post_type = 'seopress_404' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dcc.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_posts`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dcd.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dce.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_wflivetraffichuman`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dcf.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dd0.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dd1.MAI' (Errcode: 30 "Read-only file system")]
SHOW COLUMNS FROM `DZl3SCX_wpl_properties`

Listings - ComFree Realty

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dd7.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_options`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dd8.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts LEFT JOIN DZl3SCX_term_relationships ON (DZl3SCX_posts.ID = DZl3SCX_term_relationships.object_id) WHERE 1=1 AND ( DZl3SCX_term_relationships.term_taxonomy_id IN (3599) ) AND DZl3SCX_posts.post_type = 'wp_template' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_posts.post_date DESC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11ddc.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( DZl3SCX_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_head' ) ) ) AND DZl3SCX_posts.post_type = 'elementor_snippet' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_postmeta.meta_value+0 ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11ddd.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( DZl3SCX_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_start' ) ) ) AND DZl3SCX_posts.post_type = 'elementor_snippet' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_postmeta.meta_value+0 ASC

Contact
1-877-888-3131
Sign-in/up
Search for Sale
Buyer Cashback

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de0.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de1.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de2.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

Back to Map
Share
$669,000
Ontario,Tiny
For Sale Active
2 BELLE VUE AVENUE, Tiny, Ontario L9M0H5
  • 3
  • 2
  • 1100 - 1500Square Feet
Contact Seller

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de3.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

Basic Details
Description

Live steps from your deeded part-ownership to sprawling Belle-Eau-Clair Beach on sparkling Georgian Bay. This bright bungalow is lovingly cared-for, beautifully renovated, and is just bursting with good vibes! It has wide-open living spaces up and down, a stone fireplace with gas insert in the living room, and a fantastic primary bedroom with an ensuite and spacious walk-in closet that

is a room in itself. You have 2 walkouts to a large wraparound deck for seamless outdoor living, and a walk-up entrance from the lower level which also has larger windows to welcome the sunshine all year around. Recent updates include: Deck reno (2025), roof shingles (2024), bathrooms (2022-23), kitchen (2021), gas furnace/central air/gas fireplace insert (2019), and freshly painted throughout. A short drive to our many downtown shops, restaurants, the YMCA, rec centre, arena, curling club, miles of trails, the marina, the library, the hospital, golf courses and all the other amenities our wonderful shoreline communities have to offer you. Commuting distance to Barrie, Wasaga Beach, Orillia, and 90 minutes to the Toronto area. This is the perfect opportunity for couples or families to build memories here. Beach association fee – $50/year. Utility amounts are average per month. Gas – $155. Electricity – $75.75. Homeowners use Bell Fibe. What are you waiting for? Call to schedule your personal visit and come over to Tiny Beaches! (id:66098)

Read More
Basic Details
  • Property Type: Residential
  • Listing Type: For Sale
  • Listing ID: S12951088
  • Price: $669,000
  • Bedrooms: 3
  • Bathrooms: 2
  • Square Footage: 1100 - 1500 Sqft
  • Status: Active
  • Office Name: W Real Estate Inc.
  • Property Sub Type: Single Family
  • Office Key: 47968
Features & Appliances
Features
  • Heating System: Forced air, Natural gas
  • Cooling System: Central air conditioning
  • Basement: Finished, Full
  • Parking: No Garage
  • Architectural Style: Raised bungalow
  • Exterior Features: Vinyl siding
  • Flooring: Tile
  • Sewer: Septic System
  • Fireplaces Total: 1
Address Map
  • Location: CA, Ontario, Tiny, L9M0H5
  • Street: Belle Vue
  • Street Number: 2
  • Street Suffix: Avenue
  • Longitude: W81° 56' 31.5''
  • Latitude: N44° 43' 52.8''
Additional Information
  • Water Body Name: Georgian Bay
  • Water Source:
  • Foundation Details:
  • Lot Features:
  • Lot Size Dimensions: 110.5 x 124.8 FT
  • Stories: 1.0
Financial
  • Tax Annual Amount: 2050
Powered by REALTOR.ca
Listing updated: 2026-06-14 02:28:27
Schedule a Tour
List Your Property
Mortgage Calculator
Get Pre-Approved
$
$
%
%
years
Monthly Payment (Est.) $
Similar Properties

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de4.MAI' (Errcode: 30 "Read-only file system")]
SELECT * FROM `DZl3SCX_wpl_dbst` WHERE 1 AND `type`='tag' AND `enabled`>='1' GROUP BY `table_column` ORDER BY `index` ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de5.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11de6.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`

Listing Information
  • List Agent Key: 1596860
  • List Office Key: 47968
  • Modification Timestamp: 2026-06-06T21:10:43Z
  • Originating System Name: OnePoint Association of REALTORS®
  • Status Change Timestamp: 2026-06-06T21:00:38Z
Powered by REALTOR.ca
Listing updated: 2026-06-14 02:28:27
REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By‐Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.
The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy.
Website is operated by a brokerage or salesperson who is a member of The Canadian Real Estate Association.
The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non‐commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, “screen scraping”, “database scraping”, and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.

By continuing to use this website and its services, you agree to these

Terms of Use

These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.

I acknowledge I can only access these forms as a ComFree customer under contract.

These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.

I acknowledge I can only access these forms as a ComFree customer under contract.

These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.

I acknowledge I can only access these forms as a ComFree customer under contract.

How It Works

1. Purchase Your Package

2. We Ship Your ‘For Sale’ Sign

3. Book Your VR Tour

4. Complete Listing Input Forms

5. We Make Your Listing Live

6. Get Support 7 Days a Week

7. iSOLD!

Learn More

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11dec.MAI' (Errcode: 30 "Read-only file system")]
SELECT DZl3SCX_posts.* FROM DZl3SCX_posts INNER JOIN DZl3SCX_postmeta ON ( DZl3SCX_posts.ID = DZl3SCX_postmeta.post_id ) INNER JOIN DZl3SCX_postmeta AS mt1 ON ( DZl3SCX_posts.ID = mt1.post_id ) WHERE 1=1 AND ( DZl3SCX_postmeta.meta_key = '_elementor_priority' AND ( ( mt1.meta_key = '_elementor_location' AND mt1.meta_value = 'elementor_body_end' ) ) ) AND DZl3SCX_posts.post_type = 'elementor_snippet' AND ((DZl3SCX_posts.post_status = 'publish')) GROUP BY DZl3SCX_posts.ID ORDER BY DZl3SCX_postmeta.meta_value+0 ASC

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-37031-11ded.MAI' (Errcode: 30 "Read-only file system")]
SHOW FULL COLUMNS FROM `DZl3SCX_options`