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 »
Romantic Getaway in Napa
location_on Napa, California | Bed & Breakfasts
With whirlpool tubs and gas fireplaces in every room, you can count on us to help set the romance. Lovely, handcrafted breakfast in the morning. No televisions to get in the way of your intimacy.Starting at
USD $175 per night
calendar_month Availability & Reservations
Surrounding Areakeyboard_double_arrow_up
It's Napa Valley! Wineries, Restaurants, Romance. Don't miss it!
Accommodationskeyboard_double_arrow_up
Rooms are made for romance and couples, or singles who don't mind sharing a single Queen or King bed. We discourage children under the age of 12 as it can get in the way of intimacy and romance for others. The historic mansion sits in the historic district of downtown, a 5 minute walk away. Behind the historic mansion is a separate building with 5 larger suites.
Map & Directionskeyboard_double_arrow_up
1938 1st Street, Napa, California 94559
Points of Interest
The Inn on First Bed and Breakfast
1938 First Street, Napa, California
Rates & Availabilitykeyboard_double_arrow_up
(All rates in USD $) From/To Low High Notes Memorial Day to October 31 Summer/High Season November 1 to Thru Prior to Memorial Day Winter/Low Season
From $175 to $300 in Winter, and $250 to $500 in Summer.
From $175 to $300 in Winter, and $250 to $500 in Summer.
*Please
contact advertiser for rates & availability for your travel dates.
Amenitieskeyboard_double_arrow_up
Breakfast included every morning.
Room Amenities check_box Air Conditioningcheck_box Hairdryercheck_box High Speed Internetcheck_box Refrigeratorcheck_box Telephonecheck_box Telephone - Free Local CallsAvailable check_box Availablecheck_box FreeGeneral
Rooms/Suiteskeyboard_double_arrow_up
5 Mansion Rooms, 5 Garden Suites. All with private baths, gas fireplaces, and whirlpool tubs for two. 8 rooms with single King beds, 2 rooms with single Queen beds.
Services Offeredkeyboard_double_arrow_up
In-room massages available.
Policies & Restrictionskeyboard_double_arrow_up
No smoking property.
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $175 per night
J Gunther and J Cherry
Since 2007 Jim and Jamie have redefined the American Bed and Breakfast experience. With a focus on a contemporary experience, they have redecorated this 1905 historic mansion with more a more modern approach, yet with touches that hint back to its history. Eclectic modernism. Jamie is the goto gu...
View Full Profile Romantic Getaway in Napa
1938 1st Street
person_outline J Gunther and J Cherry
The Inn On First
1938 1st St
Napa, California 94559
United States
credit_card Reservations
Listing # RA-1206841
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.11 | 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`=1206841 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`=665296 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=1206841 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`=665296 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`="United States"
and `STATE`="California"
and `REGION`="Napa"
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`="United States"
and `STATE`="California"
and `REGION`="Napa"
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`="United States"
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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
and `REGION`="Napa"
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`="United States" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `STATE` ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_states.htm:119)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="C"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Washington, D.C."
LIMIT 1 ........ 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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
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`="United States"
and `STATE`="California"
and `GROUP_ID`=12
and `TYPE1`="Nature & Wildlife"
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`="United States"
and `STATE`="California"
and `GROUP_ID`=5
and `TYPE1`="Personal Growth & Educational"
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`="United States"
and `STATE`="California"
and `GROUP_ID`=13
and `TYPE1`="Rentals"
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`="United States"
and `STATE`="California"
and `GROUP_ID`=10
and `TYPE1`="Tours"
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`="United States"
and `STATE`="California"
and `GROUP_ID`=21
and `TYPE1`="Travel Guides"
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`="United States"
and `STATE`="California"
and `GROUP_ID`=8
and `TYPE1`="Travel Services"
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`=1206841 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`=1206841 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`=1206841 and `ADDRESS`!='' order by `MAP_ID` ........ 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`=1206841 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`=1206841 and `SHOWINFO`=1 order by `LAST_PAID_TIME` desc ........ 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(38.298023))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-122.295013 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(38.298023))
* 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`="United States"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LATITUDE`
BETWEEN 38.298023 - (250 / 69)
AND 38.298023 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -122.295013 - (250 / (69 * COS(RADIANS(38.298023))))
AND -122.295013 + (250 / (69 * COS(RADIANS(38.298023)))) and `listings_listings`.`LISTING` not in (1019801, 1206841)
........ 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(38.298023))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-122.295013 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(38.298023))
* 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`="United States"
and `listings_listings`.`PSTATE`="California"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 38.298023 - (250 / 69)
AND 38.298023 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -122.295013 - (250 / (69 * COS(RADIANS(38.298023))))
AND -122.295013 + (250 / (69 * COS(RADIANS(38.298023)))) and `listings_listings`.`LISTING` not in (1019801, 1206841)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:295)) debug : (0.01) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(38.298023))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-122.295013 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(38.298023))
* 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`="United States"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LAST_MGR_TIME` > 1561631750
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 38.298023 - (250 / 69)
AND 38.298023 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -122.295013 - (250 / (69 * COS(RADIANS(38.298023))))
AND -122.295013 + (250 / (69 * COS(RADIANS(38.298023)))) and `listings_listings`.`LISTING` not in (1019801, 1206841)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:321)) debug : (0.01) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(38.298023))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-122.295013 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(38.298023))
* 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`="United States"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`LATITUDE`
BETWEEN 38.298023 - (250 / 69)
AND 38.298023 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -122.295013 - (250 / (69 * COS(RADIANS(38.298023))))
AND -122.295013 + (250 / (69 * COS(RADIANS(38.298023)))) and `listings_listings`.`LISTING` not in (1019801, 1206841)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings.htm:194 (from: listing_nearby_options.htm:69)) debug : (0.02) : 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`="United States"
and `listings_listings`.`PSTATE`="California"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1206841, 1237715, 1206838, 1265907, 1022241, 1023778, 1022287, 1023502, 1224691, 1225266, 1021621)
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.01) : 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`="United States"
and `listings_listings`.`PSTATE`="California"
and `listings_listings`.`LISTING` not in (1019801, 1206841, 1237715, 1206838, 1265907, 1022241, 1023778, 1022287, 1023502, 1224691, 1225266, 1021621)
ORDER BY `INDEXKEY`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.01) : 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`="United States"
and `listings_listings`.`PSTATE`="California"
and `listings_listings`.`LISTING` not in (1019801, 1206841, 1237715, 1206838, 1265907, 1022241, 1023778, 1022287, 1023502, 1224691, 1225266, 1021621, 1025962, 1207003, 1277460, 1206888, 1206860, 1019926, 1206863, 1023899, 1020465, 1023123)
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`=1206841 limit 1 ........ 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`=1206841 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`=1206841 ........ 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`=1206841 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`=1206841 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`=1206841 and `amenities1`.`ACTIVE` and !`amenities1`.`REQUIRED` ORDER BY `amenities1`.`TYPE` DESC, `amenities1`.`GROUP`, `amenities1`.`SUBGROUP`, `amenities1`.`AMENITY`, `amenities1`.`VALUE` Time: 0.11 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.
