Database error

SELECT h.`name`, h.`short_name`, h.`notes`, h.`post_time`, h.`description`, h.`rentalinfo`, h.`price_descriptions`, h.`add_review_text`, h.`link_to_youtube`, h.`holiday`, h.`is_holiday_owner`, h.`calendar_is_active`, h.`is_active`, h.`is_verified`, h.`display_contact_form`, h.`show_sayulita_fest_calendar`, h.`display_link`, h.`vt1`, h.`vt2`, h.`vt3`, h.`vt4`, h.`vt5`, h.`feature1`, h.`feature2`, h.`feature3`, h.`feature4`, h.`feature5`, h.`feature6`, h.`locations`, h.`grupo_pro_sayulita`, h.`past_due`, h.`invoice_file`, h.`owner_id`, h.`seo_id`, h.`last_send_date_digest`, h.`disable_notification_booked_dates`, h.`disclaimer_of_update`, h.`disclaimer_of_update_last_update`, h.`min_guest`, h.`max_guest`, h.`min_bedroom`, h.`max_bedroom`, h.`min_bathroom`, h.`max_bathroom`, h.`min_bed`, h.`max_bed`, h.`id`, if( sum( if( cbr.`on_top` = 1, 1, 0 ) ) > 0, 1, 0) as `on_top`, r_stat.reviews_count, r_stat.rating_avg, r_stat.reviews_enabled, 1 as featured, (select `h_t_h_b`.`price` from home_to_home_bedrooms `h_t_h_b` where `h_t_h_b`.`home_id` = h.`id` and `h_t_h_b`.`home_bedroom_id` = 4) as `min_price`, (select `h_t_h_b`.`max_price` from home_to_home_bedrooms `h_t_h_b` where `h_t_h_b`.`home_id` = h.`id` and `h_t_h_b`.`home_bedroom_id` = 4) as `max_price`, (select `h_t_h_b`.`holiday_price` from home_to_home_bedrooms `h_t_h_b` where `h_t_h_b`.`home_id` = h.`id` and `h_t_h_b`.`home_bedroom_id` = 4) as `holiday_price` FROM `homes` h LEFT JOIN `home_to_home_bedrooms` cbr ON cbr.`home_id` = h.`id` LEFT JOIN `home_bedrooms` br ON br.`id` = cbr.`home_bedroom_id` LEFT JOIN ( SELECT r.object_id, count(r.id) as reviews_count, avg(r.mark) as rating_avg, 1 as reviews_enabled FROM `review` r LEFT JOIN review_enable r_e ON r_e.object_id = r.object_id AND r_e.object_table = 'home' WHERE r.object_table = 'home' AND r.state = 1 AND (r_e.enabled <> 0 OR r_e.enabled is NULL) GROUP BY r.object_id ORDER BY r.`id` ) r_stat ON r_stat.object_id = h.id LEFT JOIN `home_to_home_categories` h_t_h_c ON h_t_h_c.`home_id`= h.`id` LEFT JOIN `home_to_home_bedrooms` h_t_h_b ON h_t_h_b.`home_id`= h.`id` WHERE br.`bedroom_count` >= 4plus AND h.`id` IN( 2976, 3015, 2757, 3030, 2345, 2566 ) AND h.is_active = 1 GROUP BY h.`id`, h.id ORDER BY max_price desc, h.`name` asc LIMIT 6


Unknown column '4plus' in 'where clause'

Database error

SELECT h.`name`, h.`short_name`, h.`notes`, h.`post_time`, h.`description`, h.`rentalinfo`, h.`price_descriptions`, h.`add_review_text`, h.`link_to_youtube`, h.`holiday`, h.`is_holiday_owner`, h.`calendar_is_active`, h.`is_active`, h.`is_verified`, h.`display_contact_form`, h.`show_sayulita_fest_calendar`, h.`display_link`, h.`vt1`, h.`vt2`, h.`vt3`, h.`vt4`, h.`vt5`, h.`feature1`, h.`feature2`, h.`feature3`, h.`feature4`, h.`feature5`, h.`feature6`, h.`locations`, h.`grupo_pro_sayulita`, h.`past_due`, h.`invoice_file`, h.`owner_id`, h.`seo_id`, h.`last_send_date_digest`, h.`disable_notification_booked_dates`, h.`disclaimer_of_update`, h.`disclaimer_of_update_last_update`, h.`min_guest`, h.`max_guest`, h.`min_bedroom`, h.`max_bedroom`, h.`min_bathroom`, h.`max_bathroom`, h.`min_bed`, h.`max_bed`, h.`id`, if( sum( if( cbr.`on_top` = 1, 1, 0 ) ) > 0, 1, 0) as `on_top`, r_stat.reviews_count, r_stat.rating_avg, r_stat.reviews_enabled, if(h.disclaimer_of_update = 0, c_n_b_u.need_be_updated, 0) as need_be_updated, (select `h_t_h_b`.`price` from home_to_home_bedrooms `h_t_h_b` where `h_t_h_b`.`home_id` = h.`id` and `h_t_h_b`.`home_bedroom_id` = 4) as `min_price`, (select `h_t_h_b`.`max_price` from home_to_home_bedrooms `h_t_h_b` where `h_t_h_b`.`home_id` = h.`id` and `h_t_h_b`.`home_bedroom_id` = 4) as `max_price`, (select `h_t_h_b`.`holiday_price` from home_to_home_bedrooms `h_t_h_b` where `h_t_h_b`.`home_id` = h.`id` and `h_t_h_b`.`home_bedroom_id` = 4) as `holiday_price` FROM `homes` h LEFT JOIN `home_to_home_bedrooms` cbr ON cbr.`home_id` = h.`id` LEFT JOIN `home_bedrooms` br ON br.`id` = cbr.`home_bedroom_id` LEFT JOIN ( SELECT r.object_id, count(r.id) as reviews_count, avg(r.mark) as rating_avg, 1 as reviews_enabled FROM `review` r LEFT JOIN review_enable r_e ON r_e.object_id = r.object_id AND r_e.object_table = 'home' WHERE r.object_table = 'home' AND r.state = 1 AND (r_e.enabled <> 0 OR r_e.enabled is NULL) GROUP BY r.object_id ORDER BY r.`id` ) r_stat ON r_stat.object_id = h.id LEFT JOIN ( SELECT c_n_b_u_i.home_id, MAX(c_n_b_u_i.need_be_updated) as need_be_updated FROM ( SELECT h_c_2.home_id, DATEDIFF(NOW(), h_c_2.last_update) as ddiff, COUNT(c_2.home_calendar_id) as cnt, 1 AS need_be_updated FROM home_calendars h_c_2 LEFT JOIN calendar c_2 ON c_2.home_calendar_id=h_c_2.id AND c_2.cdate > DATE(NOW()) GROUP BY h_c_2.home_id,h_c_2.id HAVING ddiff >= 45 OR cnt < 10 ) c_n_b_u_i GROUP BY c_n_b_u_i.home_id ) c_n_b_u ON c_n_b_u.home_id = h.id LEFT JOIN `home_to_home_categories` h_t_h_c ON h_t_h_c.`home_id`= h.`id` LEFT JOIN `home_to_home_bedrooms` h_t_h_b ON h_t_h_b.`home_id`= h.`id` WHERE br.`bedroom_count` >= 4plus AND h.`id` IN( 3109,3173,3159,2906,3193,2368,2727,3145,2457,2565,3140,2592,2945,2816,2807,2683,2565,3123,2877,2485,3216,2390,2415,2683,2565,2613,2968,3090,3034,2373,3201,2485,2429,2645,3216,2594,2933,3116,2754,2663,3151,3127,3046,3111,2392,2891,2727,2412,2986,2613,3190,2359,2355,2565,2976,3119,3005,2967,2945,3136,2877,2887,3036,2968,2885,2485,2646,2396,2659,3015,3056,2841,3216,2548,2757,2408,2932,2390,2432,2933,2477,2615,2501,3030,2705,3076,3191,2345,2409,2962,2956,3017,2566,2745,2441,2688,2594,2343,2459,3046,2392,2754,3182,3180,3166,2935,2491,3113,3038,2360,2801,2492,2430,2676,3160 ) AND h.is_active = 1 GROUP BY h.`id`, h.id ORDER BY max_price desc, h.`name` asc


Unknown column '4plus' in 'where clause'

Sayulita vacation rentals-4 bedrooms
Muchas Gracias!
This is a brand new edition of SayulitaLife.com and we really appreciate you helping us discover any errors OR any suggestions you may have.
Email (optional):
Error report OR recommendation (or both):
Number VerificationLoad Captcha Verification
×
Business owner
Accommodation Owner
If for any reason you are not able to retrieve your password via the link above, you may reach Sayulita Life from the Contact Us page.
×
If for any reason you are not able to retrieve your password via the link above, you may reach Sayulita Life from the Contact Us page.
×
Please create an account
You will then be able to save and view your Favorites listings
Email Address:
Password:
By creating an account you are accepting our Terms and Conditions and Privacy Policy.
 
Connect using your Facebook login
We don't post anything without our permission.
×
Sign in to Sayulitalife.com

Email Address:

Password:
 
FORGOT YOUR PASSWORD?
Connect using your Facebook login
We don't post anything without your permission.
×
Forgot Password
Don't worry! Just fill in your email and we'll help you reset your password.

Email Address:
×
$0
$600+
1
2
3
4
5
6
7
8+
16
High Season
Low Season
Seasonal pricing is set by the individual homeowners. Typically High Season is Nov-May and Low Season is June-Oct
View some of our Staff Favorites here
Pajaro de Fuego Luxury Condos
North
2 and 3 bedroom Luxury Condos at Pajaro de Fuego
Casa Tambores
Other
2 bedroom 2 bath jungle hideaway
Villa Chachalacas at Pajaro de Fuego
North
2 BR, 2 BA luxury villa at Pajaro de Fuego
Villa Canario at Pajaro de Fuego
North
3-bedroom luxury penthouse with private pool & ocean view
Casa Dulce
South
2 bedroom 2 bath home with views of jungle, mountains
Casa Sierra
Central, North
3 BR, 3 BA Waterfall swimming pool!

4+ Bedroom Accommodations in Sayulita Mexico

Sayulita beachfront vacation rental homes and oceanfront villas. This Sayulita beachfront list of rentals can be sorted by Price, # of Recommendations, or Rental Name.

Showing 0 matching listings
Sort:
bottom_bannerbottom_bannerbottom_banner