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)#10238 (50) {
  ["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)#11212 (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"
  }
}

Beatons Realty Limited | Listings | Page 2

Donna Beaton's Listings

506-508 JR Smallwood Boulevard

Gambo, Newfoundland & Labrador - $59,000

Just over 1.5 acres of uncleared land that spans from JR Smallwood Blvd right to the waters of Freshwater Bay! Build your home close to the main road and have a massive backyard oasis or build a retreat with an ocean view! (id:2887)

View 506-508 JR Smallwood Boulevard

0 Southside Road

Boyd's Cove, Newfoundland & Labrador - $39,000

Over 2 acres of treed land. (id:2887)

View 0 Southside Road

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)

View 142 Main Street

27A Burts Road

Musgrave Harbour, Newfoundland & Labrador - $25,000

Owner anxious to sell! (id:2887)

View 27A Burts Road

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…

View 310 A Main Street

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

Gander Real Estate Guides

Download our free guides for tips on buying and selling homes in Gander.

Browse Guides

Blog

A Green Light on Yellow Posted March 23, 2015

A Thought for Spring: Existing vs.... Posted June 1, 2014

Gander: A Community Guide Posted April 4, 2014