Text Size: + -

Find Senior Care

Location:
Category:
Amenity/Service:
Results
Advertiser's Picture

Taylor Residences

Jacksonville, FL

Taylor Residences is an Active Retirement Community with services ranging from Independent Living, Assisted Living, Rehabilitation, Skilled Nursing and Memory Care. Taylor provides quality housing to seniors with a moderate income. Each level of care is based on the individual needs of every Senior.

Our Mission Statement:
“The Mission of Taylor Residences is to provide seniors age 62 and older with affordable housing in a community that values independence, privacy and dignity. We encourage residents to live up to their physical, social and spiritual potential through quality housing and services that include independent living, assisted living and skilled nursing.”


Amenities/Services: Limited Transportation,On-Site Special Events,Transportation to Physicians,Medication Management,In-Room Emergency Alert System,Private Apartments/ Rooms,Semi-Private Apartments/ Rooms,One Bedroom Apartments,Two Bedroom Apartments,Dining,On-Site Laundry,One Story Building,Studio/ Efficiency Apartments,Complimentary Consultation/ Assessment,Salon,Water Views,Veteran's Benefits,Assistance for the Disabled,Pets Allowed,Hospice Support

Advertiser's Picture

Camellia at Deerwood

Jacksonville, FL

Camellia at Deerwood is a vibrant and active community that encourages seniors to engage in a calendar of life enrichment programs. We are dedicated to our residents and their families to meet their needs as they change on a daily basis. All-Inclusive Dining whenever you choose.

Come see for yourself. We'd love to show you around, introduce you to some future neighbors and help you take the next step!

Amenities/Services: Outdoor Pool,Private Apartments/ Rooms,One Bedroom Apartments,Two Bedroom Apartments,Dining,Studio/ Efficiency Apartments

Advertiser's Picture

Inspirations At The Town Center

Jacksonville, FL

Live your best life!

Inspirations At The Townncenter offers resort-style independent living with luxurious amenities and a calendar full of daily programs. Located just 15 minutes from downtown Jacksonville, 15 minutes from the beach, and five minutes from TownCenter shopping, this community is tucked away - yet close to everything!

Celebrate Life!
This resort-style community is located on 12 acres with walking trails, pickle ball courts, and a sparkling zero-entry pool with bar and bisto access. We even have a dog park for our four-legged friends!

Additional amenities include:
- an on-site spa with professional services including massage, manicures and pedicures
- community living room, library and theatre for large events
- WiFi and internet access


Foodie Delights
Enjoy chef-prepared meals in formal or informal settings, wine bar and bistro.


FOR A LIMITED TIME...
Take Advantage of our Compass Founders Club Benefits - for our first 25 residents.

2-Year Rate Lock
Lock in your rate for two years. Package includes up to $1,500 for moving reimbursements.


The Chef's Table
Founders will taste-test meals by the Chef and determine the core menu for our community.


Strategy Sessions with the Director of Resident Engagement. Participate in the selection of special guest presenters, including artists, community leaders, and experts.

$250 Restaurant Compass Points
Your choice at any restaurant/bar venue. Redeemable in first year.

Spa
$250 complimentary Compass Points to use at the spa.

A "Sneak Peek" Party When Models are Open Priority selection of your luxury. Compass Founders Club Members have the first pick of floor plans

Your Own Private Party
Invite your family and friends (up to 10 people) for private social celebrations.

Bonus Guest Meal Passes
Four additional guest meal passes to share with family and friends when they visit your new home. Monthly brunch for up

Beauty/Barber Salon
$150 complimentary Compass Points to use at the Beauty/Barber Salon.

Compass Founders Club Tote Bag
Receive a tote bag and gift of wine and wine opener.

Call 904-515-4970 today to find out more!

Amenities/Services: Outdoor Pool,Off-Site Trips,Off-Site Outings,On-Site Special Events,Transportation to Physicians,In-Room Emergency Alert System,Private Apartments/ Rooms,One Bedroom Apartments,Two Bedroom Apartments,Dining,Laundry in Unit,Elevators,Multi-Story,Salon,Wooded Views,Pets Allowed

  • OurSeniorsGuide.com, Inc
  • 14286 Beach Blvd-19, Suite 335
  • Jacksonville, Florida 32250
Page requested: /find-senior-care/?locations_id=1&services_id=28
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address: 3.238.248.200
Request Time: 0.10740399360657 seconds
Errors
Console
Query Log
E_NOTICE: Undefined index: advertiser on line 11 in file /home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/header.php
Stack Trace
#0 require_once("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/header.php") /home/ourseniorsguide/public_html/wp-includes/template.php 770
#1 load_template("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/header.php", bool(true) , Array...
Array
(
)
)
/home/ourseniorsguide/public_html/wp-includes/template.php 716
#2 locate_template(Array...
Array
(
    [0] => header.php
)
, bool(true) , bool(true) , Array...
Array
(
)
)
/home/ourseniorsguide/public_html/wp-includes/general-template.php 48
#3 get_header() /home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-find-senior-care.php 6
#4 include("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-find-senior-care.php") /home/ourseniorsguide/public_html/wp-includes/template-loader.php 106
#5 require_once("/home/ourseniorsguide/public_html/wp-includes/template-loader.php") /home/ourseniorsguide/public_html/wp-blog-header.php 19
#6 require("/home/ourseniorsguide/public_html/wp-blog-header.php") /home/ourseniorsguide/public_html/index.php 17

pdo:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
	
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo Stub:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
	
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo Stub:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo:

SELECT
	DISTINCT 
	    
            locations.state AS state,
            locations.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	locations
	
LEFT JOIN
	tabmin_pages ON locations.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo Stub:

SELECT
	DISTINCT 
	    
            locations.state AS state,
            locations.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	locations
	
LEFT JOIN
	tabmin_pages ON locations.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo:

SELECT
	DISTINCT SQL_CALC_FOUND_ROWS
	    
            advertisers.statuses_id as statuses_id,
            advertisers.id as advertisers_id,
            tabmin_pages.name AS advertiser_pages_name,
            tabmin_pages.page_title AS advertiser_pages_page_title,
            tabmin_pages.page_subtitle AS advertiser_pages_page_subtitle,
            tabmin_pages.meta_description AS advertiser_pages_meta_description,
            tabmin_pages.description AS advertiser_pages_description,
            tabmin_pages.pictures_id AS advertiser_pages_pictures_id,
            main_pictures.caption AS advertiser_pages_pictures_caption,
            advertiser_pages.ad_pictures_id AS advertiser_pages_ad_pictures_id,
            ad_pictures.caption AS advertiser_pages_ad_pictures_caption,
            advertiser_pages.dir_pictures_id AS advertiser_pages_dir_pictures_id,
            advertiser_pages.id AS advertiser_pages_id,
            advertiser_pages.phone AS phone,
            advertiser_pages.address AS address,
            advertiser_pages.website AS website,
            advertiser_pages.facebook AS facebook,
            advertiser_pages.license_number AS license_number,
            advertiser_pages.wheel_chair_access AS wheel_chair_access,
            advertiser_pages.equal_house AS equal_house,
            advertiser_pages.video AS video,
            tabmin_pages.slug AS advertiser_pages_slug,
            locations.id AS locations_id,
            locations.state AS locations_state,
            location_page.name AS locations_name,
            advertiser_types.id AS advertiser_types_id,
            advertiser_types.name AS advertiser_types_name,
            advertiser_types.search_results_order AS advertiser_types_search_results_order,
            advertiser_types.company_name AS advertiser_types_company_name,
            advertiser_types.phone_number AS advertiser_types_phone_number,
            advertiser_types.map_link AS advertiser_types_map_link,
            advertiser_types.payment_options AS advertiser_types_payment_options,
            advertiser_types.website_link AS advertiser_types_website_link,
            advertiser_types.amenities AS advertiser_types_amenities,
            advertiser_types.request_more_info AS advertiser_types_request_more_info,
            advertiser_types.text_description AS advertiser_types_text_description,
            advertiser_types.services AS advertiser_types_services,
            advertiser_types.multiple_pictures AS advertiser_types_multiple_pictures,
            advertiser_types.video AS advertiser_types_video,
            advertiser_types.home_page_ad AS advertiser_types_home_page_ad,
            advertiser_types.show_listing_picture AS advertiser_types_show_listing_picture,
            advertiser_types.show_listing_services AS advertiser_types_show_listing_services,
            advertiser_types.show_listing_description AS advertiser_types_show_listing_description,
            advertiser_types.listing_full_width AS advertiser_types_listing_full_width,
        
	users.id,
	email,
	first_name,
	last_name,
	UNIX_TIMESTAMP(last_login) AS last_login,

	roles.id AS roles_id,
	roles.hidden AS roles_hidden,
	roles.developer AS roles_developer,
	roles.role AS roles_role

FROM
	users
	    
            LEFT JOIN advertisers ON advertisers.users_id = users.id
            LEFT JOIN advertiser_pages ON advertisers.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN locations ON advertiser_pages.locations_id = locations.id
            LEFT JOIN tabmin_pages AS location_page ON locations.tabmin_pages_id = location_page.id
            LEFT JOIN tabmin_pages ON advertiser_pages.tabmin_pages_id = tabmin_pages.id
            LEFT JOIN pictures AS main_pictures ON tabmin_pages.pictures_id = main_pictures.id
            LEFT JOIN pictures AS ad_pictures ON advertiser_pages.ad_pictures_id = ad_pictures.id
            LEFT JOIN advertiser_types ON advertisers.advertiser_types_id = advertiser_types.id
            LEFT JOIN advertiser_pages_have_services ON advertiser_pages_have_services.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN advertiser_pages_have_categories ON advertiser_pages_have_categories.advertiser_pages_id = advertiser_pages.id
        
LEFT JOIN
	roles ON users.roles_id=roles.id
WHERE
	(advertiser_pages.locations_id = 1 AND advertiser_pages_have_services.services_id = 28 AND advertisers.statuses_id IN (2,3)) AND roles_id=3
ORDER BY
	advertiser_types.search_results_order DESC, RAND()
LIMIT
	0,50


pdo Stub:

SELECT
	DISTINCT SQL_CALC_FOUND_ROWS
	    
            advertisers.statuses_id as statuses_id,
            advertisers.id as advertisers_id,
            tabmin_pages.name AS advertiser_pages_name,
            tabmin_pages.page_title AS advertiser_pages_page_title,
            tabmin_pages.page_subtitle AS advertiser_pages_page_subtitle,
            tabmin_pages.meta_description AS advertiser_pages_meta_description,
            tabmin_pages.description AS advertiser_pages_description,
            tabmin_pages.pictures_id AS advertiser_pages_pictures_id,
            main_pictures.caption AS advertiser_pages_pictures_caption,
            advertiser_pages.ad_pictures_id AS advertiser_pages_ad_pictures_id,
            ad_pictures.caption AS advertiser_pages_ad_pictures_caption,
            advertiser_pages.dir_pictures_id AS advertiser_pages_dir_pictures_id,
            advertiser_pages.id AS advertiser_pages_id,
            advertiser_pages.phone AS phone,
            advertiser_pages.address AS address,
            advertiser_pages.website AS website,
            advertiser_pages.facebook AS facebook,
            advertiser_pages.license_number AS license_number,
            advertiser_pages.wheel_chair_access AS wheel_chair_access,
            advertiser_pages.equal_house AS equal_house,
            advertiser_pages.video AS video,
            tabmin_pages.slug AS advertiser_pages_slug,
            locations.id AS locations_id,
            locations.state AS locations_state,
            location_page.name AS locations_name,
            advertiser_types.id AS advertiser_types_id,
            advertiser_types.name AS advertiser_types_name,
            advertiser_types.search_results_order AS advertiser_types_search_results_order,
            advertiser_types.company_name AS advertiser_types_company_name,
            advertiser_types.phone_number AS advertiser_types_phone_number,
            advertiser_types.map_link AS advertiser_types_map_link,
            advertiser_types.payment_options AS advertiser_types_payment_options,
            advertiser_types.website_link AS advertiser_types_website_link,
            advertiser_types.amenities AS advertiser_types_amenities,
            advertiser_types.request_more_info AS advertiser_types_request_more_info,
            advertiser_types.text_description AS advertiser_types_text_description,
            advertiser_types.services AS advertiser_types_services,
            advertiser_types.multiple_pictures AS advertiser_types_multiple_pictures,
            advertiser_types.video AS advertiser_types_video,
            advertiser_types.home_page_ad AS advertiser_types_home_page_ad,
            advertiser_types.show_listing_picture AS advertiser_types_show_listing_picture,
            advertiser_types.show_listing_services AS advertiser_types_show_listing_services,
            advertiser_types.show_listing_description AS advertiser_types_show_listing_description,
            advertiser_types.listing_full_width AS advertiser_types_listing_full_width,
        
	users.id,
	email,
	first_name,
	last_name,
	UNIX_TIMESTAMP(last_login) AS last_login,

	roles.id AS roles_id,
	roles.hidden AS roles_hidden,
	roles.developer AS roles_developer,
	roles.role AS roles_role

FROM
	users
	    
            LEFT JOIN advertisers ON advertisers.users_id = users.id
            LEFT JOIN advertiser_pages ON advertisers.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN locations ON advertiser_pages.locations_id = locations.id
            LEFT JOIN tabmin_pages AS location_page ON locations.tabmin_pages_id = location_page.id
            LEFT JOIN tabmin_pages ON advertiser_pages.tabmin_pages_id = tabmin_pages.id
            LEFT JOIN pictures AS main_pictures ON tabmin_pages.pictures_id = main_pictures.id
            LEFT JOIN pictures AS ad_pictures ON advertiser_pages.ad_pictures_id = ad_pictures.id
            LEFT JOIN advertiser_types ON advertisers.advertiser_types_id = advertiser_types.id
            LEFT JOIN advertiser_pages_have_services ON advertiser_pages_have_services.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN advertiser_pages_have_categories ON advertiser_pages_have_categories.advertiser_pages_id = advertiser_pages.id
        
LEFT JOIN
	roles ON users.roles_id=roles.id
WHERE
	(advertiser_pages.locations_id = :locations_id AND advertiser_pages_have_services.services_id = :services_id AND advertisers.statuses_id IN (:statuses_id0,:statuses_id1)) AND roles_id=3
ORDER BY
	advertiser_types.search_results_order DESC, RAND()
LIMIT
	0,50


pdo:

SELECT
	FOUND_ROWS()


pdo:

INSERT INTO statistics
            (
                advertisers_id,
                stat_type
            )
            VALUES
            
            (
                366,
                "impression"
            ),
            (
                47,
                "impression"
            ),
        (
            396,
             "impression"
        )


pdo Stub:

INSERT INTO statistics
            (
                advertisers_id,
                stat_type
            )
            VALUES
            
            (
                366,
                "impression"
            ),
            (
                47,
                "impression"
            ),
        (
            396,
             "impression"
        )


pdo:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
LEFT JOIN
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 490


pdo Stub:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
LEFT JOIN
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


pdo:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
LEFT JOIN
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 72


pdo Stub:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
LEFT JOIN
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


pdo:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
LEFT JOIN
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 560


pdo Stub:

SELECT
	DISTINCT 
	    
            services.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	services
LEFT JOIN
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


pdo:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo Stub:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo Stub:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id