WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT sliders.*, IF(sliders.thumbnail != '', sliders.thumbnail, IF(sliders.type != 'group', (SELECT slides.thumbnail FROM wp_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1), '' ) ) AS thumbnail, IF(sliders.type != 'group', (SELECT count(*) FROM wp_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider), (SELECT count(*) FROM wp_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wp_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id) ) AS slides FROM wp_nextend2_smartslider3_sliders AS sliders LEFT JOIN wp_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published' ORDER BY ordering ASC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT sliders.*, IF(sliders.thumbnail != '', sliders.thumbnail, IF(sliders.type != 'group', (SELECT slides.thumbnail FROM wp_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1), '' ) ) AS thumbnail, IF(sliders.type != 'group', (SELECT count(*) FROM wp_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider), (SELECT count(*) FROM wp_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wp_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id) ) AS slides FROM wp_nextend2_smartslider3_sliders AS sliders LEFT JOIN wp_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published' ORDER BY ordering ASC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT sliders.*, IF(sliders.thumbnail != '', sliders.thumbnail, IF(sliders.type != 'group', (SELECT slides.thumbnail FROM wp_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1), '' ) ) AS thumbnail, IF(sliders.type != 'group', (SELECT count(*) FROM wp_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider), (SELECT count(*) FROM wp_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wp_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id) ) AS slides FROM wp_nextend2_smartslider3_sliders AS sliders LEFT JOIN wp_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published' ORDER BY ordering ASC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT sliders.*, IF(sliders.thumbnail != '', sliders.thumbnail, IF(sliders.type != 'group', (SELECT slides.thumbnail FROM wp_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1), '' ) ) AS thumbnail, IF(sliders.type != 'group', (SELECT count(*) FROM wp_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider), (SELECT count(*) FROM wp_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wp_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id) ) AS slides FROM wp_nextend2_smartslider3_sliders AS sliders LEFT JOIN wp_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published' ORDER BY ordering ASC

Properties - Greater Vancouver Luxury Homes

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (2) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dib_css_selector' ) AND wp_posts.post_type = 'divi_bars' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'dib_enableurltrigger' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'divi_bars' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'divibars_automatictrigger' ) AND wp_posts.post_type = 'divi_bars' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_css_selector' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_css_selector' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'dmp_force_render' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'dmp_force_render' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_customizeclosebtn' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_customizeclosebtn' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_enable_arrow' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_enable_arrow' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

Property Description

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_customizeclosebtn' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_customizeclosebtn' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_enable_arrow' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'dmp_enable_arrow' ) AND wp_posts.post_type = 'divi_mega_pro' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

4631 SF | 4 bedrooms with 2 bonus areas upstairs | 5 full bathsThis custom home sits on 5 flat usable acres. The builder spared no expense with this build. The exterior features a private electronic gate, expansive landscaping plan with stunning entry water feature. The entire front yard landscaping is irrigated with sprinklers and drip lines. As you enter the home you are greeted with a spacious great room with gorgeous beams, and a 12′ ceiling height. The office has custom built-ins and a hidden room. The kitchen is a cooks dream with high-end appliances, expansive counter top space, double pot fillers, and a large walk in pantry, and two separate dinning areas. The main level features 3 en suites including the primary suite, the primary suite has a pass through door connected to the utility room, great for easy accessibility. Outdoor area off the great room is 516 SF of covered area. It comes with a full built in kitchen, ceiling heaters, and under lit gas fireplace. The 2nd level has two bonus rooms. One of the bonus rooms has a full bathroom. The landing area has beautiful builtin shelves, and a full wet bar with fridge. This 5 acres provides plenty of room for a shop, barn, or pool. *Seller to install pool for additional fee* .Located less than 2.5 miles from the I5 exit! Don’t miss out on this opportunity.

Features
: Zoned, Other, Forcedair95plus
: Centralair
: Gas, Propane
: Composition
: 3
Attached
: Sprinkler, Yard, Coveredpatio
: Dishwasher, Gasappliances, Island, Microwave, Pantry, Quartz, Stainlesssteelappliance, Rangehood, Freestandingrefrigerator, Freestandingrange, Potfiller
: Slab
: Trees, Level
: Septictank
: Driveway, Rvaccessparking
: Well
: R-5
: Engineeredhardwood, Laundry, Concretefloor
: Tankless, Electricity
: Onelevel, Utilityroomonmain
: Vinylframes
Address Map
22420 NE 50TH AVE, BattleGround
US
Washington
Clark
BattleGround
_61
98604
98604
Yes
50TH
22420
AVE
NE
East on 502/ NE 219th, North on 50th Ave, house is
0
W123° 22' 44.8''
N45° 47' 2.9''
Neighborhood
Daybreak
Daybreak
Prairie
Additional Information
28/12/2023
$0
$0
217382000
2022
$0
$0
$0
$0
$1,678
$0
$0
$0
#27 OF SEC 36 T4NR1EWM 10A FOR ASSESSOR USE ONLY S
$0
Cash,Conventional
Electricity,Propane
BoardBattenSiding,Brick
2
3
28/12/2023
31/05/2024
03/04/2024 18:16:54
28/12/2023 19:47:14
28/12/2023 19:47:14
Broker Information
Parker Brennan Real Estate
4PBR01
Dustin Ho
HODUSTIN

22420 NE 50TH AVE BattleGround

22420 NE 50TH AVE, BattleGround

4 Bedrooms
5.1 Bathrooms
4,631 Sqft
Visits : 151 in 122 days
$2,790,000
Listing ID #23435685
Basic Details
Property Type : Residential
Listing Type : For Sale
Listing ID : 23435685
MLS ID : 23435685
Price : $2,790,000
List Date : 28/12/2023
View : Territorial,treeswoods
Bedrooms : 4
Bathrooms : 5.1
Full Bathrooms : 5
Partial Bathrooms : 1
Square Footage : 4,631 Sqft
Year Built : 2023
Lot Size Acres : 5 Acre
Status : Active
MLS Status : Active
Days On Market : 118
Style : Farmhouse, Stories2
PropertySubType : Singlefamilyresidence
Agent info
Contact Agent

 

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'post_css_selector' ) AND wp_posts.post_type = 'divi_overlay' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'post_enableurltrigger' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'divi_overlay' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'do_forcerender' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'divi_overlay' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'overlay_automatictrigger' ) AND wp_posts.post_type = 'divi_overlay' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Disk full (/tmp/#sql_5aa0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'post_do_customizeclosebtn' ) AND wp_posts.post_type = 'divi_overlay' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_posts.post_date DESC