WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-3e0d4-d7f5.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-3e0d4-d7f6.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-3e0d4-d7f7.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-3e0d4-d7f8.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-3e0d4-d7f9.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-3e0d4-d7fa.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-3e0d4-d7fb.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-3e0d4-d7fc.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-3e0d4-d7fd.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-3e0d4-d7fe.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-3e0d4-d7ff.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-3e0d4-d800.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-3e0d4-d806.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-3e0d4-d807.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-3e0d4-d80b.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-3e0d4-d80c.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
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-3e0d4-d80e.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 (2820)
) AND DZl3SCX_posts.post_type = 'nav_menu_item' AND ((DZl3SCX_posts.post_status = 'publish'))
GROUP BY DZl3SCX_posts.ID
ORDER BY DZl3SCX_posts.menu_order ASC
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-3e0d4-d80f.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-3e0d4-d810.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-3e0d4-d811.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-3e0d4-d812.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`
Basic Details
Description
One-Level Living in Arbutus Ridge. This 2-bedroom, 2-bathroom rancher-style half duplex offers easy living in one of Vancouver Island’s premier 55+ gated communities. Backing directly onto the golf course, this bright and well-maintained home features no-step entry and a spacious layout. French doors lead to a large south-facing patio and private fenced yard—perfect for relaxing or entertaining. The generous driveway
& double garage provide ample parking & storage. This home has been well cared for and allows for immediate enjoyment. Located just a short stroll from the Arbutus Ridge Village Centre, residents enjoy access to outstanding amenities including a clubhouse, swimming pool, tennis courts, golf, fitness facilities, RV and boat storage, and a vibrant social calendar with numerous clubs and activities. Community ocean access includes a boat launch and kayak storage, making this an exceptional lifestyle opportunity. (id:62650)
Read More
Basic Details
Property Type: Residential
Listing Type: For Rent
Listing ID: 1038350
Price: $625,000
Bedrooms: 2
Bathrooms: 2
Square Footage: 1,300 Sqft
Year Built: 1988
Status: Active
Property Attached Yn: 1
Property Sub Type: Single Family
Office Key: 53151
Features & Appliances
Features
Heating System: Baseboard heaters
Cooling System: None
Fireplaces Total: 1
Address Map
Location: CA, British Columbia, Cobble Hill, V8H0K8
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-3e0d4-d813.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-3e0d4-d814.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `DZl3SCX_mls_on_the_fly_cache`
Listing Information
List Agent Key: 2144006
List Office Key: 53151
Modification Timestamp: 2026-06-03T19:10:45Z
Originating System Name: Victoria Real Estate Board
Status Change Timestamp: 2026-06-03T19:01:05Z
Listing updated: 2026-06-14 04:07:44
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
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.
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-3e0d4-d81a.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
[Warning] session_start(): open(/home/comfreerealtyna/public_html/wp-content/sessions/sess_alnc8pmi8obob7qrte51nae634, O_RDWR) failed: No space left on device (28) in /home/comfreerealtyna/public_html/wp-content/plugins/real-estate-listing-realtyna-wpl-pro/libraries/services/wpl.php on line 27
[Warning] session_start(): Failed to read session data: files (path: /home/comfreerealtyna/public_html/wp-content/sessions) in /home/comfreerealtyna/public_html/wp-content/plugins/real-estate-listing-realtyna-wpl-pro/libraries/services/wpl.php on line 27
[Deprecated] Optional parameter $select declared before required parameter $condition is implicitly treated as a required parameter in /home/comfreerealtyna/public_html/wp-content/plugins/real-estate-listing-realtyna-wpl-pro/libraries/addon_sms.php on line 100
[User Notice] Function wpdb::prepare was called <strong>incorrectly</strong>. The query only expected one placeholder, but an array of multiple placeholders was sent. Please see <a href="https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/">Debugging in WordPress</a> for more information. (This message was added in version 4.9.0.) in /home/comfreerealtyna/public_html/wp-includes/functions.php on line 6170
WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-3f369f-3e0d4-d81b.MAI' (Errcode: 30 "Read-only file system")] SHOW FULL COLUMNS FROM `DZl3SCX_options`