Looking for the hottest travel deals? Join the RealAdventures community and get a free travel newsletter full of ideas, hot deals and more.
See latest edition .
Sign-Up Today »
Explore the Canadian Maritimes
location_on St. Martins, New Brunswick | Bed & Breakfasts
This heritage property (circa 1857) in the historic fishing village of St. Martins offers 16 uniquely furnished guest rooms, a licensed restaurant & dining room as well as a Gift Shop.
Explore the nearby St. Martins sea caves & Fundy Trail ParkwayStarting at
USD $107.39 per night
calendar_month Availability & Reservations
Surrounding Areakeyboard_double_arrow_up
Situated in the heart of the magnificent Bay of Fundy, this heritage inn (circa 1857) boasts a commanding view of the Atlantic Ocean in the historic fishing village of St. Martins, New Brunswick.
Map & Directionskeyboard_double_arrow_up
303 Main Street, St. Martins, New Brunswick E5R 1C1
Just 30 minutes drive from the Saint John, New Brunswick airport.
Points of Interest
St. Martins Country Inn / Vaughans Restaurant
303 Main Street, St. Martins, New Brunswick
Fundy Trail Parkway
229 Main St, St. Martins, NB E5R 1B7, Canada
Nearby Attractions and Serviceskeyboard_double_arrow_up
Distance Description 1.5km St. Martins Sea Caves 15km Fundy Trail Parkway 22km Hearst Lodge, Fundy Trail Parkway 32km Saint John, NB Airport 145km Moncton, NB Airport
Rates & Availabilitykeyboard_double_arrow_up
(All rates in USD $) From/To Low High Notes Carriage House Bayview (King) 115 (single or double occupancy) Gardenview (Queen) 107 (single or double occupancy) Premier Gardenview (Queen) 131 (single or double occupancy) Premier Bayview (Queen) 131 (single or double occupancy) Carriage House Bayview (2 Queens) 115 (double occupancy)
Room rates range from $135 CAD plus applicable taxes. Rates include full breakfast. Special packages for families, romantic getaways, adventure and seniors are available as well as packages which include meals and accommodation.
Room rates range from $135 CAD plus applicable taxes. Rates include full breakfast. Special packages for families, romantic getaways, adventure and seniors are available as well as packages which include meals and accommodation.
*Please
contact advertiser for rates & availability for your travel dates.
Amenitieskeyboard_double_arrow_up
Room Amenities check_box Air Conditioningcheck_box Cable/Satellite TVcheck_box Hairdryercheck_box High Speed Internetcheck_box Refrigeratorcheck_box Room Servicecheck_box Telephonecheck_box TelevisionAvailable check_box Barcheck_box Conference Roomscheck_box Internet Accesscheck_box FreeGeneral check_box Reservations Required
Rooms/Suiteskeyboard_double_arrow_up
The St. Martins Country Inn offers 16 uniquely furnished guest rooms with a combination of antiques and contemporary amenities. All rooms have Queen or King beds with private bath, flat screen televisions, free wireless internet, mini-refrigerator and coffeemaker. Some rooms have two Queen Beds. Bay view and Garden view rooms are available.
Policies & Restrictionskeyboard_double_arrow_up
No smoking
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $107.39 per night
Explore the Canadian Maritimes
303 Main Street
person_outline Lynette Davis, General Manager
credit_card Reservations
Listing # RA-1285283
Also of Interest Near
Similar Nearby Listings (See All ) keyboard_double_arrow_up
Featured Adventures Nearby (See All ) keyboard_double_arrow_up
Featured Accommodations Nearby (See All ) keyboard_double_arrow_up
Add Your Travel Services and Accommodations
Add a multi-page listing promoting your accommodations, tours or travel services to customers on our network of travel sites. Your listing page includes an interactive map, availability calendar, reviews, photo-gallery and more.
Create Your Listing
Time: 0.07 | Consuming 0.00 kb ........ common_miva_database.htm:52 (from: listing.htm:9 (from: (none):-1)) debug : Opening table common_stats ........ common_miva_database.htm:52 (from: listing.htm:9 (from: (none):-1)) debug : Opening table common_visitor_pages ........ common_miva_database.htm:52 (from: setup.htm:80 (from: listing.htm:9)) debug : Opening table accounts ........ common_miva_database.htm:52 (from: setup.htm:83 (from: listing.htm:9)) debug : Opening table common_visitors ........ common_miva_database.htm:52 (from: listing.htm:18 (from: (none):-1)) debug : Opening table listings_listings ........ common_miva_database.htm:186 (from: listing_setup.htm:30 (from: listing.htm:18)) debug : (0.00) : SELECT * FROM `listings_listings` WHERE `LISTING`=1285283 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:39 (from: listing.htm:18)) debug : Opening table accounts1 ........ common_miva_database.htm:186 (from: common_listing_advertiser_account.htm:23 (from: listing_setup.htm:39)) debug : (0.00) : SELECT * FROM `accounts` WHERE `EMAIL_NO`=383434 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table listings_info ........ common_miva_database.htm:186 (from: common_listing_tables.htm:7 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `listings_info` WHERE LISTING=1285283 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table type ........ common_miva_database.htm:186 (from: common_listing_tables.htm:23 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `type` WHERE `TYPE`="Accommodations: Bed & Breakfasts" limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table group ........ common_miva_database.htm:186 (from: common_listing_tables.htm:34 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `group` WHERE `GROUP_ID`=2 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:57 (from: listing.htm:18)) debug : Opening table accounts1 ........ common_miva_database.htm:186 (from: listing_table_variables.htm:79 (from: listing_setup.htm:57)) debug : (0.00) : SELECT * FROM `accounts1` WHERE `EMAIL_NO`=383434 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:69 (from: listing.htm:18)) debug : Opening table websites ........ common_miva_database.htm:186 (from: common_urls.htm:272 (from: listing_setup.htm:69)) debug : (0.00) : SELECT * FROM `websites` WHERE `WEBSITE_CODE`="RA" limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:74 (from: listing.htm:18)) debug : Opening table geograph ........ common_miva_database.htm:52 (from: navbar.htm:151 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:151)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="H"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`="St. Martins"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:154)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="H"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`="St. Martins"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:158)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Z"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:161)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Y"
and `TYPE`="Accommodations"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:165)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="X"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:39)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Z"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:45)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="X"
and `TYPE`="Accommodations: Bed & Breakfasts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:90)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="A"
and `CONTINENT`="North America"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:106)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:121)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="C"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:138)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="D"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`="St. Martins"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:19)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:39)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:59)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Mexico"
LIMIT 1 ........ common_miva_database.htm:186 (from: navbar_select_destination_continents.htm:57 (from: navbar_select_destination.htm:17)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="A" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `CONTINENT` ........ common_miva_database.htm:186 (from: navbar_select_destination_states.htm:73 (from: navbar_select_destination.htm:21)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="C" and `CONTINENT`="North America" and `COUNTRY`="Canada" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `STATE` ........ common_miva_database.htm:186 (from: navbar_select_destination_countries.htm:86 (from: navbar_select_destination.htm:25)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="B" and `CONTINENT`="North America" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `COUNTRY` ........ common_miva_database.htm:52 (from: navbar.htm:219 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:186 (from: navbar_select_top_destinations.htm:184 (from: navbar.htm:219)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="D"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `REGION`!=""
and `DELETED`=0
and `LISTINGS_SHOW`
ORDER BY `LISTINGS_SHOW` desc
LIMIT 20
........ common_miva_database.htm:52 (from: navbar.htm:222 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:52 (from: navbar.htm:222 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:186 (from: navbar_select_categories.htm:130 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="G"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `LISTINGS_SHOW`
and `DELETED`=0
ORDER BY `TYPE1`, `TYPE2`
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=2
and `TYPE1`="Accommodations"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=3
and `TYPE1`="Adventure Travel"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=4
and `TYPE1`="Cruises"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=7
and `TYPE1`="Fishing & Hunting"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
and `STATE`="New Brunswick"
and `GROUP_ID`=12
and `TYPE1`="Nature & Wildlife"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:52 (from: listing_setup.htm:82 (from: listing.htm:18)) debug : Opening table listings_images ........ common_miva_database.htm:186 (from: listing_image_url.htm:63 (from: listing_setup.htm:82)) debug : (0.00) : SELECT * FROM `listings_images` WHERE `LISTING`=1285283 and `DELETED`=0 ORDER BY `ORDER_NO`, `IMAGE_NO` LIMIT 999 ........ common_miva_database.htm:52 (from: listing.htm:18 (from: (none):-1)) debug : Opening table listings_availability ........ common_miva_database.htm:186 (from: listing_setup.htm:92 (from: listing.htm:18)) debug : (0.00) : SELECT COUNT(*) as `TOTAL` FROM `listings_availability` WHERE `LISTING`=1285283 and `STATUS`!="available" and `DATE`>= "2022-06-26" ........ common_miva_database.htm:52 (from: listing_setup.htm:124 (from: listing.htm:18)) debug : Opening table listings_map ........ common_miva_database.htm:186 (from: listing_map_json.htm:104 (from: listing_setup.htm:124)) debug : (0.00) : SELECT * FROM `listings_map` WHERE `LISTING`=1285283 and `ADDRESS`!='' order by `MAP_ID` ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_map_json.htm:149)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:186 (from: listing_map_pins.htm:17 (from: listing_setup.htm:125)) debug : (0.00) : SELECT * FROM `listings_map` WHERE `LISTING`=1285283 AND `DELETED`=0 ........ common_miva_database.htm:52 (from: listing_setup.htm:127 (from: listing.htm:18)) debug : Opening table listings_deals ........ common_miva_database.htm:186 (from: listing_hot_deals.htm:6 (from: listing_setup.htm:127)) debug : (0.00) : SELECT * FROM `listings_deals` WHERE `LISTING`=1285283 and `SHOWINFO`=1 order by `LAST_PAID_TIME` desc ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_hot_deals.htm:81)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:186 (from: summary_listings.htm:167 (from: listing_nearby_options.htm:49)) debug : (0.00) : SELECT count(*) as `TOTAL`, 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:268)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:295)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LAST_MGR_TIME` > 1561637799
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:321)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.356262))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-65.538559 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.356262))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Bed & Breakfasts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`LATITUDE`
BETWEEN 45.356262 - (250 / 69)
AND 45.356262 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -65.538559 - (250 / (69 * COS(RADIANS(45.356262))))
AND -65.538559 + (250 / (69 * COS(RADIANS(45.356262)))) and `listings_listings`.`LISTING` not in (1019801, 1285283)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings.htm:194 (from: listing_nearby_options.htm:69)) debug : (0.00) : SELECT count(*) as `TOTAL` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1285283, 1212807, 1213325, 1204431, 1226600, 1204410, 1204417, 1025783, 1204391, 1213349, 1213288)
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.00) : SELECT * FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`LISTING` not in (1019801, 1285283, 1212807, 1213325, 1204431, 1226600, 1204410, 1204417, 1025783, 1204391, 1213349, 1213288)
ORDER BY `INDEXKEY`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.00) : SELECT * FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`!=2
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="Canada"
and `listings_listings`.`PSTATE`="New Brunswick"
and `listings_listings`.`LISTING` not in (1019801, 1285283, 1212807, 1213325, 1204431, 1226600, 1204410, 1204417, 1025783, 1204391, 1213349, 1213288, 1213328, 1213365, 1244657, 1213350, 1212783, 1213086, 1245060, 1213077, 1213071, 1213742)
ORDER BY `INDEXKEY`
limit 0
, 10 ........ common_miva_database.htm:52 (from: listing_setup.htm:135 (from: listing.htm:18)) debug : Opening table listings_listings ........ common_miva_database.htm:186 (from: listing_nearby_options.htm:134 (from: listing_setup.htm:135)) debug : (0.00) : SELECT * FROM `listings_listings` WHERE `LISTING`=1285283 limit 1 ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_starting_at.htm:16)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_setup.htm:170)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:52 (from: listing_snippet.htm:75 (from: listing_template_full_home.htm:10)) debug : Opening table listings_amenities2 ........ common_miva_database.htm:186 (from: listing_key_amenities.htm:8 (from: listing_snippet.htm:75)) debug : (0.00) : SELECT * FROM `listings_amenities2` inner join `amenities1` using (`AMEN_ID`) WHERE `LISTING`=1285283 and `REQUIRED` ORDER BY `GROUP`,`AMENITY`,`VALUE` ........ common_miva_database.htm:52 (from: listing_template_full_home.htm:32 (from: listing_template.htm:93)) debug : Opening table listings_nearby ........ common_miva_database.htm:186 (from: listing_nearby.htm:9 (from: listing_template_full_home.htm:32)) debug : (0.00) : SELECT * FROM `listings_nearby` WHERE `LISTING`=1285283 ........ common_miva_database.htm:52 (from: listing_template_full_home.htm:40 (from: listing_template.htm:93)) debug : Opening table listings_ratecard ........ common_miva_database.htm:186 (from: listing_rates.htm:36 (from: listing_template_full_home.htm:40)) debug : (0.00) : SELECT * FROM `listings_ratecard` WHERE `LISTING`=1285283 AND `DELETED`=0 order by `RECNO` ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:52 (from: common_currency_rates.htm:124 (from: listing_rates.htm:61)) debug : Opening table common_currencies ........ common_miva_database.htm:186 (from: common_currency_rates.htm:24 (from: common_currency_rates.htm:124)) debug : (0.00) : SELECT * FROM `common_currencies` WHERE `CURRENCY`="CAD" AND `DELETED`=0 ........ common_miva_database.htm:186 (from: listing_calendar.htm:56 (from: listing_template_full_home.htm:42)) debug : (0.00) : SELECT * FROM `listings_availability` WHERE `LISTING`=1285283 and `DATE`>="2022-06" ........ common_miva_database.htm:52 (from: listing_template_full_home.htm:45 (from: listing_template.htm:93)) debug : Opening table listings_amenities2 ........ common_miva_database.htm:186 (from: listing_amenities.htm:15 (from: listing_template_full_home.htm:45)) debug : (0.00) : SELECT * FROM `listings_amenities2` left join `amenities1` using (`AMEN_ID`) WHERE `LISTING`=1285283 and `amenities1`.`ACTIVE` and !`amenities1`.`REQUIRED` ORDER BY `amenities1`.`TYPE` DESC, `amenities1`.`GROUP`, `amenities1`.`SUBGROUP`, `amenities1`.`AMENITY`, `amenities1`.`VALUE` Time: 0.07 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.
