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 »
Bennett House Bed & Breakfast
location_on Woodstock, New Brunswick | Bed & Breakfasts
Beautifully restored Historic home (1878) with 4 guestrooms (ensuite baths, queen & king beds and many deluxe amenities), serving a gourmet breakfast. A few minutes walk to downtown shops and dining.Starting at
USD $71.52 per night
calendar_month Availability & Reservations
Surrounding Areakeyboard_double_arrow_up
Woodstock NB is a Loyalist town founded in 1786. It has many Victorian houses and is home to the Connell House (Museum). Woodstock is close to the world's longest covered bridge and Kings Landing (Historic village. The is shopping and dining with in walking distance. There are also golf courses in the area.
Accommodationskeyboard_double_arrow_up
All our guest rooms have king or queen beds, cable TV, DVD players, ensuite or private baths, air-conditioning and wireless Internet.
Map & Directionskeyboard_double_arrow_up
698 Main St., Woodstock, New Brunswick E7M 2E3
Exit #185 form the Trans Canada Hwy. Continue Deakin Dr. Turn left and drive to the next stop light and turn right. We are on the left hand side at the corner of Cross & Main St. Woodstock is located approximately six hours driving time from Quebec City, QC, Halifax, NS or Boston, Mass. We are 15 kilometres from the US border at Highway US #95.
Points of Interest
Bennett House Bed & Breakfast
698 Main St., Woodstock, New Brunswick
Rates & Availabilitykeyboard_double_arrow_up
(All rates in USD $) From/To April 11/2011-Dec. 01/2011 Low High Notes 85.00 per couple
Our standard room rates are $85.00 per couple plus taxes. A single guest is $75.00 plus tax. Extra guests are $20.00 each per night plus tax.
Our standard room rates are $85.00 per couple plus taxes. A single guest is $75.00 plus tax. Extra guests are $20.00 each per night plus tax.
*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 Telephone - Free Local CallsAvailable check_box Internet Accesscheck_box Availablecheck_box Free
Rooms/Suiteskeyboard_double_arrow_up
There are four guest rooms
Policies & Restrictionskeyboard_double_arrow_up
Our Bed & Breakfast is a smoke-free facility. We are also a Fragrance Free environment. Children 10 years of age or older are welcome but please ask first. Pets are not accepted.
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $71.52 per night
Bennett House Bed & Breakfast
698 Main St.
person_outline D. Bennett
credit_card Reservations
Listing # RA-1213365
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.10 | 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`=1213365 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`=688288 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=1213365 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`=688288 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`="Woodstock"
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`="Woodstock"
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`="Woodstock"
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`=1213365 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`=1213365 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`=1213365 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`=1213365 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`=1213365 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(46.152836))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-67.572418 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.152836))
* 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 46.152836 - (250 / 69)
AND 46.152836 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -67.572418 - (250 / (69 * COS(RADIANS(46.152836))))
AND -67.572418 + (250 / (69 * COS(RADIANS(46.152836)))) and `listings_listings`.`LISTING` not in (1019801, 1213365)
........ 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(46.152836))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-67.572418 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.152836))
* 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 46.152836 - (250 / 69)
AND 46.152836 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -67.572418 - (250 / (69 * COS(RADIANS(46.152836))))
AND -67.572418 + (250 / (69 * COS(RADIANS(46.152836)))) and `listings_listings`.`LISTING` not in (1019801, 1213365)
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(46.152836))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-67.572418 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.152836))
* 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` > 1561633693
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 46.152836 - (250 / 69)
AND 46.152836 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -67.572418 - (250 / (69 * COS(RADIANS(46.152836))))
AND -67.572418 + (250 / (69 * COS(RADIANS(46.152836)))) and `listings_listings`.`LISTING` not in (1019801, 1213365)
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(46.152836))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-67.572418 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.152836))
* 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 46.152836 - (250 / 69)
AND 46.152836 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -67.572418 - (250 / (69 * COS(RADIANS(46.152836))))
AND -67.572418 + (250 / (69 * COS(RADIANS(46.152836)))) and `listings_listings`.`LISTING` not in (1019801, 1213365)
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, 1213365, 1213354, 1212807, 1213325, 1285283, 1204391, 1204417, 1226600, 1204410, 1212783, 1204431)
........ 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, 1213365, 1213354, 1212807, 1213325, 1285283, 1204391, 1204417, 1226600, 1204410, 1212783, 1204431)
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, 1213365, 1213354, 1212807, 1213325, 1285283, 1204391, 1204417, 1226600, 1204410, 1212783, 1204431, 1213328, 1244657, 1213350, 1213086, 1245060, 1213077, 1213071, 1213742, 1213084, 1213288)
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`=1213365 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`=1213365 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`=1213365 ........ 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`=1213365 AND `DELETED`=0 order by `RECNO` ........ 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`=1213365 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`=1213365 and `amenities1`.`ACTIVE` and !`amenities1`.`REQUIRED` ORDER BY `amenities1`.`TYPE` DESC, `amenities1`.`GROUP`, `amenities1`.`SUBGROUP`, `amenities1`.`AMENITY`, `amenities1`.`VALUE` Time: 0.10 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.
