fitness products,glucose monitors,baby scales,medical scales,polar heart rate monitors,omron blood pressure monitors,body fat scales,cholesterol tests,peak flow meters,medela breast pumps,pedometers,fat calipers,body composition analyzers Baby strollers , car seats , bouncers, toys , free shipping, low prices,ceap toys, cheap strollers
TAKE 5% OFF TODAY ONLY - NOT VALID ON SELECTED BRANDS
Heathchecksystems on facebook Follow Us On Twitter
Maxi-Cosi CC244FGD Pria 3-in-1 Convertible Car Seat - Blackened Pearl - Open Box - Open Box Maxi-Cosi Car Seats
Authorized Dealer
Introducing the Pria 3-in-1 Convertible car seat, baby's first and only car seat. Surround your child in comfort and safety from the first ride home.3-In-1 seating system with the Pria 3-in-1, you can take comfort in knowing that you'll have a safe, comfortable car seat for your child, from birth to 10 years old. more ...
  Price Drop Alert  
Maxi-Cosi CC244FGD Pria 3-in-1 Convertible Car Seat - Blackened Pearl - Open Box
Open Box
Note: This product is an Open Box Product and is a like new condition. These products are unused, from a display from a store or Packaging may be missing or opened. .

Other Maxi-Cosi Pria 3-in-1 Convertible Car Seats

Maxi-Cosi CC244FGG Pria 3-in-1 Convertible Car Seat - Arctic Mist - Open Box
CC244FGG
Pria 3-in-1 Convertible Car Seat - Arctic Mist - Open Box
- Open Box
Price $279.99
buy now
In Stock
View Product Info
Maxi-Cosi CC244FGH Pria 3-in-1 Convertible Car Seat - Moonshine Violet
CC244FGH
Pria 3-in-1 Convertible Car Seat - Moonshine Violet

Price $319.99
Discontinued
View Product Info
Maxi-Cosi Pria 3-in-1 Convertible Car Seat - Moonshine Violet with Baby on Board Sign
ESTBNDNDOWN
Pria 3-in-1 Convertible Car Seat - Moonshine Violet with Baby on Board Sign

Price $319.99
Discontinued
View Product Info
Maxi-Cosi CC244FGD Pria 3-in-1 Convertible Car Seat - Blackened Pearl - Open Box
FREE Ground Shipping
(48 US States Only)

Price: $279.00


Available to Ship


View Features

Maxi-Cosi
SKU: CC244FGD
UPC: 884392627003

Features


Introducing the Pria 3-in-1 Convertible car seat, babys first and only car seat. Surround your child in comfort and safety from the first ride home.3-In-1 seating system with the Pria 3-in-1, you can take comfort in knowing that youll have a safe, comfortable car seat for your child, from birth to 10 years old. Children can ride rear-facing, from 4-40 pounds; forward-facing to 65 pounds; and up to 100 pounds in Booster Mode. It may be the only car seat youll ever need. Converting to each new stage is simple and intuitive, so you can quickly make car seat adjustments. It allows for a wide range of adaptability with its 3-position recline, 5 headrest heights, along with a quick fit shoulder harness.Superior safety features with confidence knowing that the Pria 3-in-1 is backed by over 30 years of European engineering and exceeds all federal standards, including FMVSS 213. Gcell side impact protection is built into the headrest to cushion the impact, and protect your child around the head where its needed most. The quick fit shoulder harness automatically raises the harness and headrest height to fit your growing child. Children grow at different rates so its important to have the flexibility to customize your car seat to ensure that you keep safety where you need it, when you need it. Supreme comfort Featuring soft-to-touch cushions and premium fabrics and padding throughout, the Pria 3-in-1 provides the most comfort for your child during the journey. The car seat features self-wicking fabrics to keep your little one dry and comfortable in those hot summer months, while warm and cozy The rest of the year. The covers are easy to remove, machine washable and dryer safe.
Weight: 23.00 lb

* within the 48 continental US States


 
For Phone Orders, call toll-free 888-337-4684 (Monday - Friday 9 am - 6 pm E.S.T)
All other inquiries, please phone 718-339-6212
FAX 718-336-5570

Body Fat Measurement | Pro Body Fat Monitors | Heart Rate Monitors | Bariatric Scales | Blood Pressure Monitors | Breast Pumps | Digital Thermometers | Nebulizers & Peak Flow Meters | Fitness Products | Baby Video Monitors | Baby Strollers | Bathroom Scales | Weight Loss | | Diabetes Testing / Glucose MetersInfant/Baby Care | Medical/Physician's Scales | Medical Strength Testing Equipment | Cooking/Diet Scales | Portable Personal Massagers | Jogging Strollers | Bicycle Trailers | Stopwatches & Scoreboards| GreatGift Ideas |


Follow Us On
Follow Us On
Become a fan
facebook
Home | My Account | Products | Fitness Tips | Contact Us | View Shopping Cart | HealthCheck Systems | Heart rate monitors | Body fat scales and body fat monitors | Products for baby and new parents | Blood pressure monitors | Products for fitness and health | Professional products | Cholesterol Monitors / Glucose Testing Devices / Blood testing devices | Gifts

Copyright ©1997 -2024 HealthCheck Systems, All rights reserved

Home MyAccount Contact Us Shopping Cart Home Page


Debugging Information
ColdFusion Server Enterprise 10,0,23,302580
Template /product/index.cfm
Time Stamp 25-Apr-24 01:57 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.189.254.4
Host Name 10.189.254.4


Execution Time

Total Time Avg Time Count Template
93 ms 93 ms 1 top level E:\inetpub\Websites\healthchecksystems.com\product\index.cfm
63 ms 32 ms 2 E:/inetpub/Websites/healthchecksystems.com/includes/inc_site_settings.cfm
63 ms 63 ms 1 E:/inetpub/Websites/healthchecksystems.com/includes/top.cfm
15 ms 15 ms 1 E:/inetpub/Websites/global/product/dsp_product.cfm
15 ms 15 ms 1 E:/inetpub/Websites/global/product/dsp_product_1.cfm
15 ms 15 ms 1 E:/inetpub/Websites/global/product/inc_product_cart_button.cfm
15 ms 15 ms 1 E:/inetpub/Websites/global/qry/qry_product.cfm
0 ms 0 ms 1 E:/inetpub/Websites/global/Product_pages/inc_product_acc.cfm
0 ms 0 ms 2 E:/inetpub/Websites/global/includes/ACT_BLOCK.cfm
0 ms 0 ms 1 E:/inetpub/Websites/global/product/inc_product_kit_con.cfm
0 ms 0 ms 1 E:/inetpub/Websites/global/product/inc_product_middle.cfm
0 ms 0 ms 1 E:/inetpub/Websites/healthchecksystems.com/includes/bottom.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
93 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

BLOCK (Datasource=STORE2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\includes\ACT_BLOCK.cfm @ 13:57:22.022
	SELECT IP FROM block_ip 
	WHERE IP = '3.145.143.239'
	limit 1
Product (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
	
	SELECT     product.product_id, product.product_name,product.is_active, product.date_created,product.old_id,product.cloud_map , man.man_id, man.man_name, man.MAN_TITLE ,man.auth_dealer,Product_detail.weight, Product_detail.dim_weight, 
                      Product_detail.X, Product_detail.Y, Product_detail.Z, Product_detail.MAP, Product_detail.use_map, Product_detail.qty_in_stock, Product_detail.eta, 
                      Product_detail.days_till_ship, product_detail.ARcust_code ,Product_detail.UPC, Product_detail.SKU, Product_detail.use_ALOC ,Product_detail.Has_image, Product_detail.Product_note, Product_detail.sale_price,Product_detail.Offer_Tradein,
					  Product_detail.Pre_Sale_QTY,Product_detail.POP_Discount,Product_detail.POP_Discount_backUP,Product_detail.List_Price,Product_detail.man_Warranty,product.is_active,
					
					  (SELECT ONHAND FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ONHAND,
					  (select product_name from product p where product_id=Product_detail.Free_product) as Free_product_name,
					  (select product_kit_name from product p where product_id=Product_detail.Free_product) as Free_kit_name,
					  Product_detail.Free_product as Free_product_id,Product_detail.Block_Search,
                      Product_detail.Demo_URL, Product_detail.PDF_URL, Product_detail.Product_note_start, Product_detail.Product_note_end, Product_detail.fk_Warranty_id,
                      Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only,Product_detail.show_please_call, Product_detail.Block_cart ,stock_type.stock_type_id, stock_type.stock_type_name, 
                      stock_type.stock_type_color, stock_type.stock_type_name_internal, product_condition.product_condition_id, 
                      product_condition.product_condition_name, Product_rebate.Product_rebate_id, Product_rebate.rebate_url, Product_rebate.rebate_text, 
                      Product_rebate.rebate_amount, Product_rebate.from_date, Product_rebate.to_date, Product_description.features, Product_description.spec,  Product_description.spec_Mobile, 
					  Product_description.bulletpoint1,Product_description.bulletpoint2,Product_description.bulletpoint3,Product_description.bulletpoint4,Product_description.bulletpoint5,
                      Product_description.caption, Product_to_cat_sub.fk_Cat_sub_id, Product_detail.alt_item, Product_description.meta_title, 
                      Product_description.meta_Description, Product_description.meta_Keywords, Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_Category.Cat_Category_id, 
                      Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name,
                          (SELECT     shipping_type.shipmentDesc
                            FROM          product_shipping INNER JOIN
                                                   shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id
                            WHERE      (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND 
                                                   (product_shipping.fk_product_id = product.product_id)
                            ORDER BY shipping_type.shipping_type_id DESC limit 1 ) AS shipping, product_store.Price, product_store.fk_store_id, 
                      '' as SG_URL ,
					  (SELECT fk_product_id
						FROM feature_value inner join product_to_feature on feature_value.feature_value_id = product_to_feature.fk_feature_value_id
						WHERE feature_value_id = 6 and fk_product_id=product.product_id LIMIT 1) as made_in_usa ,
							(SELECT HTML_page from man_store WHERE FK_MAN_ID=man.MAN_ID and fk_store_id =product_store.fk_store_id) AS HTML_page ,
							
							(SELECT ALOC FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ALOC,
							 page_rank.rank
					
FROM
                      product INNER JOIN
                      Product_detail ON Product_detail.fk_product_id = product.product_id INNER JOIN
                      Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN
                      product_condition ON Product_detail.fk_product_condition_id = product_condition.product_condition_id INNER JOIN
                      stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id inner join product_store
					  ON product_store.fk_product_id = product.product_id  LEFT OUTER JOIN
                      Cat_sub LEFT OUTER JOIN
                      Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id LEFT OUTER JOIN
                      Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id LEFT OUTER JOIN
                      Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id ON 
                      product.product_id = Product_to_cat_sub.fk_product_id LEFT OUTER JOIN
                      Product_rebate ON product.product_id = Product_rebate.fk_product_id LEFT OUTER JOIN
                      man ON product.fk_man_id = man.man_id 
					    left outer join  page_rank on product.product_id =  page_rank.fk_product_id  
					  
		WHERE     (product_store.fk_store_id = 1) AND 
					 
					product.product_id = 57597 
					and Product_detail.Block_cart <> 3
					 and  product_detail.fk_stock_type_id not in (12)
					AND  (product.is_active = 1) AND
	   (product_store.is_active = 1)
	
	 
	 
group_mini (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
	SELECT     fk_product_group_id
                            FROM          product_group_to_product_id AS product_group_to_product_id_1
                            WHERE      (fk_product_id = 57597)
	
group (Datasource=store2008, Time=0ms, Records=4) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
SELECT     Product_group.Product_group_id, Product_group.Group_name,Product_detail.sku, Product_detail.Has_image, Product_detail.Block_cart,product.product_name, product.product_kit_name,product.Model_name, 
                      product.is_active, product.product_id, product_store.Price,man.man_name,stock_type.stock_type_id, stock_type.stock_type_name, 
                      stock_type.stock_type_color,product_detail.ARcust_code,Product_detail.fk_product_condition_id as product_condition_id
FROM         product_group_to_product_id INNER JOIN
                      Product_group ON product_group_to_product_id.fk_product_group_id = Product_group.Product_group_id INNER JOIN
                      product ON product_group_to_product_id.fk_product_id = product.product_id INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id INNER JOIN
                      product_store ON Product_detail.fk_product_id = product_store.fk_product_id inner join
					  man ON product.fk_man_id = man.man_id INNER JOIN
                      stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id
WHERE (product.is_active = 1) AND
	   (product_store.is_active = 1) AND 
		product_store.fk_store_id=1 AND
	  	product_store.Price > 0 and 
		 Product_detail.Block_cart <> 3 and
		 Product_group.Product_group_id = 5358 and
		  Product_detail.Block_Search = 0 
		  
			 
		


ORDER BY stock_type.order_by,product_store.Price, product_group_to_product_id.order_by
acc (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
SELECT     product_to_acc.fk_product_id, product.product_id  ,product.product_name, product.product_kit_name,product.old_id,product_store.Price, Product_description.caption,product_detail.ARcust_code
,Product_detail.fk_stock_type_id,Product_detail.fk_product_condition_id as product_condition_id
FROM         product_store INNER JOIN
                      product ON product_store.fk_product_id = product.product_id INNER JOIN
                      product_to_acc ON product.product_id = product_to_acc.fk_acc_id INNER JOIN
                      Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id
WHERE     (product_to_acc.fk_product_id = 57597) AND 
		 (product_store.fk_store_id = 1) and (product.is_active = 1) and product_store.Price <> 0
		 and Product_detail.fk_stock_type_id in (1,2,6,7,8,10,11)
		 
ORDER BY product_to_acc.order_by
alt_image (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
SELECT     product_alt_image_id, fk_product_id, image_header
FROM         product_alt_image
where is_active =1 and fk_product_id = 57597 
kit_component_s (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
SELECT product_kit_component.fk_component_id ,product_kit_component.order_by ,product_kit_component.qty ,product.product_name , product_kit_name
FROM product_kit_component inner join product on
	product_kit_component.fk_component_id = product.product_id
Where fk_product_id = 57597 
acc (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
SELECT     product_to_acc.fk_product_id, product.product_id  ,product.product_name,product.product_kit_name, product.old_id,product_store.Price, 
			Product_description.caption,Product_description.features,product_detail.ARcust_code,Product_detail.fk_stock_type_id,Product_detail.fk_product_condition_id as product_condition_id
FROM         product_store INNER JOIN
                      product ON product_store.fk_product_id = product.product_id INNER JOIN
                      product_to_acc ON product.product_id = product_to_acc.fk_acc_id INNER JOIN
                      Product_description ON product.product_id = Product_description.fk_product_id INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id
WHERE     (product_to_acc.fk_product_id = 57597) AND 
		 (product_store.fk_store_id = 1) and (product.is_active = 1) and product_store.Price <> 0
		 
ORDER BY product_to_acc.order_by
page (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
					SELECT HTML_Page 
					FROM product_store
					WHERE fk_product_id = 57597 and fk_store_id=18
					
select_scale_spec (Datasource=products, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
		 select scale_spec_id, fk_product_id,Capacity,Capacity_Unit,Readability,Readability_Unit,Legal_Capacity,Legal_Capacity_Unit,Legal_Readability,Leagl_Readability_Unit,Pan_Size,Pan_Size_Unit,Pan_Size_Round,Cannabis
		 from scale_spec
		 where fk_product_id = 57597
		 order by Capacity_Unit,Capacity
		 
warranty (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
		SELECT warranty_group.fk_product_id as PRODUCT_ID, product.product_name, product.old_id, product_store.Price, Product_description.caption
		
		FROM warranty_group inner join warranty on warranty.warranty_id = warranty_group.fk_Warranty_id inner join product
		 on product.product_id = warranty_group.fk_product_id inner join  product_store 
		on product_store.fk_product_id = product.product_id INNER JOIN
         Product_description ON product.product_id = Product_description.fk_product_id
		 
		 where warranty_group.fk_Warranty_id=0 and from_price <= 279 and to_price >= 279
		and (product_store.fk_store_id = 1) and (product.is_active = 1) and product_store.Price <> 0
		order by warranty_group.from_price, product.product_name
		
product_review (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
		select * , AVG(RATING) as rating_sum
		from product_review 
		where fk_product_id = 57597 and APROVED = 1
		group by the_date
		order by the_date desc
		
product_list_gr (Datasource=store, Time=0ms, Records=31) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
	select product_group_to_product_id_2.fk_product_id 
from product_group_to_product_id inner join product_group_to_product_id product_group_to_product_id_2 on
    product_group_to_product_id.fk_product_group_id = product_group_to_product_id_2.fk_product_group_id
WHERE product_group_to_product_id.fk_product_id = 57597 
product_list_all (Datasource=store, Time=0ms, Records=32) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
	select product_group_to_product_id_2.fk_product_id 
from product_group_to_product_id inner join product_group_to_product_id product_group_to_product_id_2 on
    product_group_to_product_id.fk_product_group_id = product_group_to_product_id_2.fk_product_group_id
WHERE product_group_to_product_id.fk_product_id = 57597
	union
	
	
	SELECT fk_component_id as fk_product_id FROM product_kit_component where fk_product_id in(55716,55717,55718,55720,55721,55722,55723,55724,55725,55726,55727,55728,57464,57465,57549,57597,58458,58459,58460,58461,58462,58463,58464,58465,58466,58467,58468,58469,58470,58471,59025)
	union
	SELECT fk_product_id FROM product_kit_component where fk_component_id in(55716,55717,55718,55720,55721,55722,55723,55724,55725,55726,55727,55728,57464,57465,57549,57597,58458,58459,58460,58461,58462,58463,58464,58465,58466,58467,58468,58469,58470,58471,59025)
	
product_faq (Datasource=store, Time=0ms, Records=0) in E:\inetpub\Websites\global\qry\qry_product.cfm @ 13:57:22.022
		SELECT ticket_id, thedate_time, type
		FROM ticket
		Where fk_product_id in(55716,55717,55718,55720,55721,55722,55723,55724,55725,55726,55727,55728,57464,57465,57549,57597,58458,58459,58460,58461,58462,58463,58464,58465,58466,58467,58468,58469,58470,58471,59025,32125) AND APROVED = 1 and type <> 'News'
		order by type,ticket_id	
		limit 1
		


Scope Variables

Application Variables:
applicationname=store_1
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\Websites\healthchecksystems.com\product\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www1.healthchecksystems.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=www1.healthchecksystems.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\Websites\healthchecksystems.com\product\index.cfm
QUERY_STRING=product_id=57597
REMOTE_ADDR=10.189.254.4
REMOTE_HOST=10.189.254.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/product/index.cfm
SERVER_NAME=www1.healthchecksystems.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.0
WEB_SERVER_API=
Client Variables:
cfid=17754510
cftoken=60e32ddbb2e575cc-E00C752D-C0B7-6EDA-A819D3061DA9290B
hitcount=2
lastvisit={ts '2024-04-25 13:57:22'}
remote_addr=3.145.143.239
timecreated={ts '2024-04-25 13:57:22'}
urltoken=CFID=17754510&CFTOKEN=60e32ddbb2e575cc-E00C752D-C0B7-6EDA-A819D3061DA9290B&jsessionid=18A787DB684F70E0B4B13E0B4AF7F03A.cfusion
Cookie Variables:
CFID=17754510
CFTOKEN=60e32ddbb2e575cc-E00C752D-C0B7-6EDA-A819D3061DA9290B
Form Fields:
S_PRODUCT=
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
sessionid=18A787DB684F70E0B4B13E0B4AF7F03A.cfusion
urltoken=CFID=17754510&CFTOKEN=60e32ddbb2e575cc-E00C752D-C0B7-6EDA-A819D3061DA9290B&jsessionid=18A787DB684F70E0B4B13E0B4AF7F03A.cfusion
URL Parameters:
product_id=57597
Debug Rendering Time: 47 ms