Dream House(DVD)

$24.90  Inc GST

Release Date: 9 Feb 2012
Director: Jim Sheridan
Rating: PG 13 Brief Coarse Language & Some Violence
Language: English
English, Simplified and Traditional Chinese subtitles
Format: DVD 9
Picture Format: PAL
Artist Name:
Daniel Craig, Rachel Weisz, Naomi Watts
Sound:5.1ch Dolby Digital and DTS for English audio
Aspect Ratio: 1.7:11
Duration: 91 mins
Special Feature: Trailer, Making Of: Building A Dream House. Making Of: Burning Down The House, Interview Of Casts


Successful publisher Will Atenton (Daniel Craig) quit a high power job in Manhattan to relocate his wife, Libby (Rachel Weisz), and two girls to a quaint New England town. But as they settle into their new life, they discover their perfect home was the murder scene of a mother and her children. And the entire city believes it was at the hands of the husband who survived.

When Will investigates, hes not sure if hes starting to see ghosts or if the tragic story is just hitting too close to home. His only clue comes from a mysterious neighbor, Ann (Naomi Watts), who knew those who were shot. And as Will and Ann piece together the haunting puzzle, they must find out who murdered the family in Wills dream house before he returns to kill again.



Add to Cart:

  • Model: SF3081
  • Shipping Weight: 120grams

This product was added to our catalog on Wednesday 08 February, 2012.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'simplyfu_db2.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '271' and opa.orders_id = opb.orders_id and opb.products_id != '271' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]