array(2) {
  [0]=>
  array(3) {
    ["key"]=>
    string(8) "_agent_1"
    ["value"]=>
    string(7) "1572163"
    ["compare"]=>
    string(4) "LIKE"
  }
  [1]=>
  array(4) {
    ["key"]=>
    string(6) "_price"
    ["value"]=>
    array(2) {
      [0]=>
      string(1) "0"
      [1]=>
      string(9) "100000000"
    }
    ["compare"]=>
    string(7) "BETWEEN"
    ["type"]=>
    string(7) "numeric"
  }
}

object(WP_Query)#11795 (51) {
  ["query"]=>
  array(2) {
    ["paged"]=>
    string(1) "2"
    ["post_type"]=>
    string(7) "listing"
  }
  ["query_vars"]=>
  array(57) {
    ["paged"]=>
    int(2)
    ["post_type"]=>
    string(7) "listing"
    ["error"]=>
    string(0) ""
    ["m"]=>
    string(0) ""
    ["p"]=>
    int(0)
    ["post_parent"]=>
    string(0) ""
    ["subpost"]=>
    string(0) ""
    ["subpost_id"]=>
    string(0) ""
    ["attachment"]=>
    string(0) ""
    ["attachment_id"]=>
    int(0)
    ["name"]=>
    string(0) ""
    ["pagename"]=>
    string(0) ""
    ["page_id"]=>
    int(0)
    ["second"]=>
    string(0) ""
    ["minute"]=>
    string(0) ""
    ["hour"]=>
    string(0) ""
    ["day"]=>
    int(0)
    ["monthnum"]=>
    int(0)
    ["year"]=>
    int(0)
    ["w"]=>
    int(0)
    ["category_name"]=>
    string(0) ""
    ["tag"]=>
    string(0) ""
    ["cat"]=>
    string(0) ""
    ["tag_id"]=>
    string(0) ""
    ["author"]=>
    string(0) ""
    ["author_name"]=>
    string(0) ""
    ["feed"]=>
    string(0) ""
    ["tb"]=>
    string(0) ""
    ["meta_key"]=>
    string(6) "_price"
    ["meta_value"]=>
    string(0) ""
    ["preview"]=>
    string(0) ""
    ["s"]=>
    string(0) ""
    ["sentence"]=>
    string(0) ""
    ["title"]=>
    string(0) ""
    ["fields"]=>
    string(0) ""
    ["menu_order"]=>
    string(0) ""
    ["embed"]=>
    string(0) ""
    ["category__in"]=>
    array(0) {
    }
    ["category__not_in"]=>
    array(0) {
    }
    ["category__and"]=>
    array(0) {
    }
    ["post__in"]=>
    array(0) {
    }
    ["post__not_in"]=>
    array(0) {
    }
    ["post_name__in"]=>
    array(0) {
    }
    ["tag__in"]=>
    array(0) {
    }
    ["tag__not_in"]=>
    array(0) {
    }
    ["tag__and"]=>
    array(0) {
    }
    ["tag_slug__in"]=>
    array(0) {
    }
    ["tag_slug__and"]=>
    array(0) {
    }
    ["post_parent__in"]=>
    array(0) {
    }
    ["post_parent__not_in"]=>
    array(0) {
    }
    ["author__in"]=>
    array(0) {
    }
    ["author__not_in"]=>
    array(0) {
    }
    ["search_columns"]=>
    array(0) {
    }
    ["posts_per_page"]=>
    int(10)
    ["orderby"]=>
    string(14) "meta_value_num"
    ["order"]=>
    string(4) "desc"
    ["meta_query"]=>
    array(2) {
      [0]=>
      array(3) {
        ["key"]=>
        string(8) "_agent_1"
        ["value"]=>
        string(7) "1572163"
        ["compare"]=>
        string(4) "LIKE"
      }
      [1]=>
      array(4) {
        ["key"]=>
        string(6) "_price"
        ["value"]=>
        array(2) {
          [0]=>
          string(1) "0"
          [1]=>
          string(9) "100000000"
        }
        ["compare"]=>
        string(7) "BETWEEN"
        ["type"]=>
        string(7) "numeric"
      }
    }
  }
  ["tax_query"]=>
  object(WP_Tax_Query)#12997 (6) {
    ["queries"]=>
    array(0) {
    }
    ["relation"]=>
    string(3) "AND"
    ["table_aliases":protected]=>
    array(0) {
    }
    ["queried_terms"]=>
    array(0) {
    }
    ["primary_table"]=>
    NULL
    ["primary_id_column"]=>
    NULL
  }
  ["meta_query"]=>
  bool(false)
  ["date_query"]=>
  bool(false)
  ["post_count"]=>
  int(0)
  ["current_post"]=>
  int(-1)
  ["before_loop"]=>
  bool(true)
  ["in_the_loop"]=>
  bool(false)
  ["comment_count"]=>
  int(0)
  ["current_comment"]=>
  int(-1)
  ["found_posts"]=>
  int(0)
  ["max_num_pages"]=>
  int(0)
  ["max_num_comment_pages"]=>
  int(0)
  ["is_single"]=>
  bool(false)
  ["is_preview"]=>
  bool(false)
  ["is_page"]=>
  bool(false)
  ["is_archive"]=>
  bool(true)
  ["is_date"]=>
  bool(false)
  ["is_year"]=>
  bool(false)
  ["is_month"]=>
  bool(false)
  ["is_day"]=>
  bool(false)
  ["is_time"]=>
  bool(false)
  ["is_author"]=>
  bool(false)
  ["is_category"]=>
  bool(false)
  ["is_tag"]=>
  bool(false)
  ["is_tax"]=>
  bool(false)
  ["is_search"]=>
  bool(false)
  ["is_feed"]=>
  bool(false)
  ["is_comment_feed"]=>
  bool(false)
  ["is_trackback"]=>
  bool(false)
  ["is_home"]=>
  bool(false)
  ["is_privacy_policy"]=>
  bool(false)
  ["is_404"]=>
  bool(false)
  ["is_embed"]=>
  bool(false)
  ["is_paged"]=>
  bool(true)
  ["is_admin"]=>
  bool(false)
  ["is_attachment"]=>
  bool(false)
  ["is_singular"]=>
  bool(false)
  ["is_robots"]=>
  bool(false)
  ["is_favicon"]=>
  bool(false)
  ["is_posts_page"]=>
  bool(false)
  ["is_post_type_archive"]=>
  bool(true)
  ["query_vars_hash":"WP_Query":private]=>
  string(32) "ecc1e4d0fba1f04d663271151f2f35c6"
  ["query_vars_changed":"WP_Query":private]=>
  bool(false)
  ["thumbnails_cached"]=>
  bool(false)
  ["allow_query_attachment_by_filename":protected]=>
  bool(false)
  ["stopwords":"WP_Query":private]=>
  NULL
  ["compat_fields":"WP_Query":private]=>
  array(2) {
    [0]=>
    string(15) "query_vars_hash"
    [1]=>
    string(18) "query_vars_changed"
  }
  ["compat_methods":"WP_Query":private]=>
  array(2) {
    [0]=>
    string(16) "init_query_flags"
    [1]=>
    string(15) "parse_tax_query"
  }
  ["query_cache_key":"WP_Query":private]=>
  string(0) ""
}

Beatons Realty Limited | Listings | Page 2

Donna Beaton's Listings

310 A Main Street

Carmanville, Newfoundland & Labrador - $25,000

Located in the picturesque town of Carmanville, this 2-acre property offers an unobstructed, beautiful view of the ocean. With access to town water and numerous town services (fire department, road maintenance, garbage collection, snow cleaning, etc.), it is a perfect place to build your dream home or vacation home! Carmanville…

MLS®, REALTOR®, and the associated logos are trademarks of The Canadian Real Estate Association

Filter Listings

ID # Property Type City Min. Price Max. Price Bedrooms Bathrooms

Free Real Estate Consultation

With no pressure to commit and no money collected until we sell your home, why not schedule your free consultation and let our expert knowledge and resources help you realize your goal of buying or selling a home.

Learn More