WP_Term Object
(
    [term_id] => 1897
    [name] => Madrid
    [slug] => madrid
    [term_group] => 0
    [term_taxonomy_id] => 1897
    [taxonomy] => course-locations
    [description] => 
    [parent] => 1817
    [count] => 4
    [filter] => raw
)

SELECT *
	FROM zoho_course_dates
	WHERE 1  AND ( (training_centre_id = "1947940070")) 
	AND (
	start_date >= 1695585187
	OR
	start_date = 0
	)

Array
(
    [0] => stdClass Object
        (
            [id] => 24
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1696204800
            [end_date] => 1698710400
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [1] => stdClass Object
        (
            [id] => 25
            [course_id] => 905282000000871131
            [course_name] => CELTA Mixed Mode (Part-Time)
            [start_date] => 1696204800
            [end_date] => 1702857600
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 11-12 week course.
<br>Flexible timetable. Teacher training practice in the centre on Saturdays 10:00 - 14:30. Rest of the course is done online.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Mixed Mode
            [sub_format] => Part Time
            [published] => 1
        )

    [2] => stdClass Object
        (
            [id] => 26
            [course_id] => 905282000000933075
            [course_name] => CELTA Face-to-Face (Part-Time)
            [start_date] => 1696204800
            [end_date] => 1703030400
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 12-week course. <br>Monday, Wednesday and Friday from 09:30 - 13:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Part Time
            [published] => 1
        )

    [3] => stdClass Object
        (
            [id] => 84
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1698883200
            [end_date] => 1701302400
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [4] => stdClass Object
        (
            [id] => 150
            [course_id] => 905282000000933091
            [course_name] => CELTA Mixed Mode (Part-Time)
            [start_date] => 1704240000
            [end_date] => 1711065600
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 11-12 week course. Flexible timetable. <br>Teacher training practice in the centre on Saturdays 10:00 - 14:30. Rest of the course is done online.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Mixed Mode
            [sub_format] => Part Time
            [published] => 1
        )

    [5] => stdClass Object
        (
            [id] => 168
            [course_id] => 905282000000871123
            [course_name] => CELTA Face-to-Face (Part-Time)
            [start_date] => 1705017600
            [end_date] => 1711065600
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 12-week course. 
<br>Monday, Wednesday and Friday from 09:30 - 13:30.
4-5 week course. 
<br>Monday to Friday, 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Part Time
            [published] => 1
        )

    [6] => stdClass Object
        (
            [id] => 188
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1706745600
            [end_date] => 1709164800
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [7] => stdClass Object
        (
            [id] => 251
            [course_id] => 905282000000933091
            [course_name] => CELTA Mixed Mode (Part-Time)
            [start_date] => 1711929600
            [end_date] => 1718928000
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 11-12 week course. Flexible timetable. <br>Teacher training practice in the centre on Saturdays 10:00 - 14:30. Rest of the course is done online.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Mixed Mode
            [sub_format] => Part Time
            [published] => 1
        )

    [8] => stdClass Object
        (
            [id] => 252
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1711929600
            [end_date] => 1714348800
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [9] => stdClass Object
        (
            [id] => 259
            [course_id] => 905282000000871123
            [course_name] => CELTA Face-to-Face (Part-Time)
            [start_date] => 1712275200
            [end_date] => 1718928000
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 12-week course. 
<br>Monday, Wednesday and Friday from 09:30 - 13:30.
4-5 week course. 
<br>Monday to Friday, 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Part Time
            [published] => 1
        )

    [10] => stdClass Object
        (
            [id] => 282
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1714694400
            [end_date] => 1717113600
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [11] => stdClass Object
        (
            [id] => 307
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1717372800
            [end_date] => 1719532800
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [12] => stdClass Object
        (
            [id] => 332
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1719792000
            [end_date] => 1722384000
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [13] => stdClass Object
        (
            [id] => 361
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1722470400
            [end_date] => 1724976000
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [14] => stdClass Object
        (
            [id] => 386
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1725235200
            [end_date] => 1727654400
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [15] => stdClass Object
        (
            [id] => 414
            [course_id] => 905282000000933091
            [course_name] => CELTA Mixed Mode (Part-Time)
            [start_date] => 1727740800
            [end_date] => 1734480000
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 11-12 week course. Flexible timetable. <br>Teacher training practice in the centre on Saturdays 10:00 - 14:30. Rest of the course is done online.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Mixed Mode
            [sub_format] => Part Time
            [published] => 1
        )

    [16] => stdClass Object
        (
            [id] => 415
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1727740800
            [end_date] => 1730246400
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

    [17] => stdClass Object
        (
            [id] => 420
            [course_id] => 905282000000871123
            [course_name] => CELTA Face-to-Face (Part-Time)
            [start_date] => 1728000000
            [end_date] => 1734480000
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 12-week course. 
<br>Monday, Wednesday and Friday from 09:30 - 13:30.
4-5 week course. 
<br>Monday to Friday, 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Part Time
            [published] => 1
        )

    [18] => stdClass Object
        (
            [id] => 437
            [course_id] => 905282000000933127
            [course_name] => CELTA Face-to-Face (Full-Time)
            [start_date] => 1730678400
            [end_date] => 1732838400
            [price] => 1550
            [currency] => EUR (€)
            [offer] => 0
            [offer_price] => 0
            [details] => 
            [terms] => 4-5 week course.<br>Monday to Friday from 09:30 - 17:30.
<br>All course fees included.
            [provider] => Madrid, Spain
            [provider_full_address] => Alonso Mart&iacute;nez Zurbano 8, Madrid, 28010, Spain
            [provider_address_line_1] => Alonso Mart&iacute;nez Zurbano 8
            [provider_address_line_2] => 
            [provider_district_city] => Madrid
            [provider_state_province] => 
            [provider_postal_code] => 28010
            [provider_country] => Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_timezone] => 1.00
            [provider_native_currency] => EUR (&euro;)
            [training_centre_id] => 1947940070
            [training_centre_image] => https://www.studycelta.com/wp-content/uploads/2021/09/tefl-celta-courses-madrid-spain.jpg
            [type] => CELTA
            [types] => CELTA
            [format] => Face to Face
            [sub_format] => Full time
            [published] => 1
        )

)

Madrid TEFL Courses

Rating: 5.0/5
Courses: CELTA
CELTA Formats: Face to Face, Mixed
University of Cambridge accredited
Phone: +34 932 202 206

CELTA Madrid About Madrid

Quick Links

CELTA Course Dates & Fees via Madrid, Spain

Upcoming courses via Madrid, Spain ordered by date

Course Details	Price
02-Oct-2023 - 31-Oct-2023 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
02-Oct-2023 - 18-Dec-2023 CELTA Mixed Mode (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
02-Oct-2023 - 20-Dec-2023 CELTA Face-to-Face (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
02-Nov-2023 - 30-Nov-2023 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
03-Jan-2024 - 22-Mar-2024 CELTA Mixed Mode (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
12-Jan-2024 - 22-Mar-2024 CELTA Face-to-Face (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Feb-2024 - 29-Feb-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Apr-2024 - 21-Jun-2024 CELTA Mixed Mode (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Apr-2024 - 29-Apr-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
05-Apr-2024 - 21-Jun-2024 CELTA Face-to-Face (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
03-May-2024 - 31-May-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
03-Jun-2024 - 28-Jun-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Jul-2024 - 31-Jul-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Aug-2024 - 30-Aug-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
02-Sep-2024 - 30-Sep-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Oct-2024 - 18-Dec-2024 CELTA Mixed Mode (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
01-Oct-2024 - 30-Oct-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information
04-Oct-2024 - 18-Dec-2024 CELTA Face-to-Face (Part-Time) Madrid, Spain	1550.00 EUR (€)	More Information
04-Nov-2024 - 29-Nov-2024 CELTA Face-to-Face (Full-Time) Madrid, Spain	1550.00 EUR (€)	More Information

View More Dates

Training Centre in Madrid, Spain

Array
(
    [0] => WP_Term Object
        (
            [term_id] => 1897
            [name] => Madrid
            [slug] => madrid
            [term_group] => 0
            [term_taxonomy_id] => 1897
            [taxonomy] => course-locations
            [description] => 
            [parent] => 1817
            [count] => 4
            [filter] => raw
        )

)

Madrid, Spain

5.0(5)

Located near Alonso Martinez metro stop
Research library, and well-equipped facilities for trainees
Cafeteria
Centrally located accommodation
Job seeking advice and support

The teacher training centre in Madrid has been about for over 30 years and has trained more than 320,000 students. There is easy access to public transport (the nearest metro stop is Alonso Martinez). Students have access to central locations, modern designs, open 14 hours a day and on Saturday morning, with 82 soundproofed classrooms, air-conditioned and equipped with the latest audiovisual media.

CELTA Courses

Accommodation in Madrid

The teacher training centre in Madrid can offer accommodation in shared apartments for the trainees during the duration of their CELTA (and DELTA) courses in Madrid. Applicants discuss their accommodation needs during their interview with the course tutor, part of the free application process.

Alternatively, trainees can organise their own accommodation, using websites such as www.airbnb.com and www.booking.com.

Madrid and its Surroundings

Madrid, the capital city of Spain is one of the most exciting and cosmopolitan cities in the world. The city is well-known for being one of the liveliest in Europe. The Spanish Language (Castilian) has its roots in Madrid and the region, and its inhabitants are known for speaking some of the purest 'Spanish' Spanish. Madrid also hosts several of the most important collections of art in the world, in museums such as Prado or Reina Sofia.

Living in Madrid means being connected to the vibrant and glamour of the largest metropolis in the South of Europe, surrounded by a wealth of historical, cultural and artistic treasures. You have all of this and more under a constant deep blue sky!

The cost of living in Madrid, Spain is cheaper than many other European capital cities. For example, the metro and bus system (if you need to use it) is very cheap (around €12 for a 10 journey ticket), as is eating out, particularly if you choose a 'Menu del Día' - a set meal in a reasonable restaurant near the school - you can enjoy this from around €10-15.

For more information about the vibrant city of Madrid, visit: www.madridtourist.info

WP_Term Object
(
    [term_id] => 1897
    [name] => Madrid
    [slug] => madrid
    [term_group] => 0
    [term_taxonomy_id] => 1897
    [taxonomy] => course-locations
    [description] => 
    [parent] => 1817
    [count] => 4
    [filter] => raw
)

Array
(
    [0] => WP_Post Object
        (
            [ID] => 1947940070
            [post_author] => 3
            [post_date] => 2021-05-20 16:46:16
            [post_date_gmt] => 2021-05-20 15:46:16
            [post_content] => 
            [post_title] => Madrid, Spain
            [post_excerpt] => Located near Alonso Martinez metro stop
Research library, and well-equipped facilities for trainees
Cafeteria
Centrally located accommodation
Job seeking advice and support

The teacher training centre in Madrid has been about for over 30 years and has trained more than 320,000 students. There is easy access to public transport (the nearest metro stop is Alonso Martinez). Students have access to central locations, modern designs, open 14 hours a day and on Saturday morning, with 82 soundproofed classrooms, air-conditioned and equipped with the latest audiovisual media.
            [post_status] => publish
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => madrid-spain
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2022-02-09 15:10:48
            [post_modified_gmt] => 2022-02-09 15:10:48
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://studycelta.com/?post_type=provider&p=1947940070
            [menu_order] => 0
            [post_type] => provider
            [post_mime_type] => 
            [comment_count] => 0
            [filter] => raw
        )

)

SELECT *
				FROM zoho_providers
				WHERE 1 AND training_centre_id = 1947940070

Array
(
    [0] => stdClass Object
        (
            [id] => 60
            [provider_id] => 905282000000845045
            [provider_name] => Madrid, Spain
            [full_address] => Alonso Martínez Zurbano 8, Madrid, 28010, Spain
            [training_centre_id] => 1947940070
            [address_line_1] => Alonso Martínez Zurbano 8
            [address_line_2] => 
            [district_city] => Madrid
            [state_province] => 
            [postal_code] => 28010
            [country] => Spain
            [longitude] => -3.77156277545181
            [latitude] => 40.5248319
            [timezone] => 1.00
            [native_currency] => EUR (€)
            [contacts] => [{"display_value":"Claire - Tipping - ttraining@ihmadrid.com||Other","ID":"905282000000845057"},{"display_value":"Steven - McGuire - smcguire@ihmadrid.com||Main","ID":"905282000000845061"},{"display_value":"Steven - McGuire - smcguire@ihmadrid.com||Accounts","ID":"905282000001048095"}]
            [alt_longitude] => -3.6958651
            [alt_latitude] => 40.4275406
        )

)

Course Reviews in Madrid, Spain

"Wonderful experience!"

Claudia Carlota Bolaños Lopez

United States

Madrid, Spain

CELTA - Face to Face

"The tutors were very supportive"

Rhiannon Freya Holly Pattison

United Kingdom

Madrid, Spain

CELTA - Face to Face

"We enjoyed a great atmosphere during the course"

Ana Maria Silva Losada

Spain

Madrid, Spain

CELTA - Mixed

Read All Madrid Reviews

Madrid TEFL Courses

Quick Links

CELTA Course Dates & Fees via Madrid, Spain

Upcoming courses via Madrid, Spain ordered by date

Training Centre in Madrid, Spain

Madrid, Spain

Accommodation in Madrid

Madrid and its Surroundings

Course Reviews in Madrid, Spain

5 steps to find the right course for you

Why do I need to choose a location for an online CELTA?

Why do I need to choose a location for an online DELTA?

Processing...