Query: DESCRIBE `listings`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `storeys`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `listclasses`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `pricecodes`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `saletypes`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `suburbs`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `areas`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `subareas`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `agents`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `accesstypes`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `list_rentals`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `rphotos`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `testimonials`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `photos`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `import_listings`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `suburbaliases`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `suburbs`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `new_suburbs`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `photos`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `areas`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `listing_statistics`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: DESCRIBE `daily_listing_statistics`
Warning: SQL Error: 1: Can't create/write to file '/tmp/#sql_45b_0.MYI' (Errcode: 13) in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: SELECT `Listclass`.`, `Listclass`.`id` FROM `listclasses` AS `Listclass` WHERE `Listclass`.`id` = 7 LIMIT 1
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`id` FROM `listclasses` AS `Listclass` WHERE `Listclass`.`id in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: SELECT `Area`.`, `Area`.`id` FROM `areas` AS `Area` WHERE `Area`.`id` = 64 LIMIT 1
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`id` FROM `areas` AS `Area` WHERE `Area`.`id` = 64 LIMIT 1 in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: SELECT `Area`.` FROM `areas` AS `Area` WHERE 1 = 1
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` AS `Area` WHERE 1 = 1' at line 1 in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Query: SELECT `Listing`.`, `Listing`.`id`, `Storey`.`, `Listclass`.`, `Pricecode`.`, `Saletype`.`, `Suburb`.`, `Agent`.`, `Coagent`.` FROM `listings` AS `Listing` LEFT JOIN `storeys` AS `Storey` ON (`Listing`.`storey_id` = `Storey`.`id`) LEFT JOIN `listclasses` AS `Listclass` ON (`Listing`.`listclass_id` = `Listclass`.`id`) LEFT JOIN `pricecodes` AS `Pricecode` ON (`Listing`.`pricecode_id` = `Pricecode`.`id`) LEFT JOIN `saletypes` AS `Saletype` ON (`Listing`.`saletype_id` = `Saletype`.`id`) LEFT JOIN `suburbs` AS `Suburb` ON (`Listing`.`suburb_id` = `Suburb`.`id`) LEFT JOIN `agents` AS `Agent` ON (`Listing`.`agent_id` = `Agent`.`id`) LEFT JOIN `agents` AS `Coagent` ON (`Listing`.`coagent_id` = `Coagent`.`id`) WHERE ((listclass_id =7) ) AND (area_id = 64) AND ((pricecurrent >= 400000) OR (pricemax >= 400000)) AND (((pricecurrent > "0") AND (pricecurrent <= 500000)) OR ((pricemin > "0") AND (pricemin <=500000))) ORDER BY `pricesort` DESC LIMIT 20
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`id`, `Storey`.`, `Listclass`.`, `Pricecode`.`, `Saletype`.`, in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463

Diane Astle Listings in more than $400000 and less than $500000

Area

Any Area Ashburton District Christchurch City Selwyn District Waimakariri District

Price

From: No lower limit $200k $300k $400k To: $500 No upper limit

Listing Type

Any type Business Professional House Industrial To Buy Lifestyle Other Residential Section Townhouse Unit

Subscribe to this search. (What's this?)      Save this as a favourite search.

Warning: Invalid argument supplied for foreach() in /home/dastle/public_html/app/views/listings/sel.thtml on line 150

No Listings Found

Sort by:   Price ascending  Price descending  Suburb ascending  Suburb descending

---

Diane Astle Realty Ltd MREINZ Licensed (REAA2008)
372 Ferry Road, Ferrymead, Christchurch City, Canterbury.
Phone: 03 389 9061, Fax: 03 389 9161
Email: admin@dianeastle.co.nz
1% + $450 + gst + Marketing
24 Carat Gold Service

Website created by Olwen Williams. http://www.olwenwilliams.com

Contact

• Email

Phone
03 389 9061
Fax
03 389 9161

• Home
• Rentals
• Rental Listings
• Auctions
• Our Fees
• What You Get
• Our Team
• Search Listings
• Listing number
• My Favourite Listings
• My Stored Searches
• What Can We Save You?
• Advertising Examples
• Download Latest Gold Collection
• Disclaimer
• Join our Team
• Quick Searches
• RSS Feeds