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)#11940 (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)#13162 (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

142 Main Street

Traytown, Newfoundland & Labrador - $26,000

Ocean view property looking out at the Harbour. Large parcel of land located in scenic Traytown. Great location to build your dream home or your summer getaway. Access to town sewer. Not far from Terra Nova National Park, golfing and more. (id:2887)

310 A Main Street

Carmanville, Newfoundland & Labrador - $20,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