Listed: Thu, 19 Apr

Brent's really old house

314 Cranford St, Mairehau, Christchurch City, Canterbury

Asking price $300,000

4 Beds
1 Bath

Attribute	Value
Property type	House
Parking	1 car garaging
Property ID#	AAT916
Agency reference	HIL2292
Apply Online	http://www.tmsandbox.co.nz/Browse/Jobs/ApplyOnline.aspx?mode=apply_online&referenceId=6653220&sellerId=0

Here's what I did to test Trade Me exports on my DEV machine:

Activate Trade Me exports: update ho_export set IsActive = 1 where ExportName = 'Trade Me' Activate the Listing Export process: update ho_processinfo set isactive = 1, UpdateDateTime = SYSUTCDATETIME(), NextRunDateTime = SYSUTCDATETIME() where processname = 'Listing Export' Get export configuration from staging: select * from ho_export e join ho_attributedata ad on ad.AttributeDataID = e.SettingsAttributeDataID where ExportName like '%trade me%' Update local db with these values:

Open home times

No times scheduled

Local Schools

IN ZONE Paparoa Street School
120 Paparoa Street
800 m
Contributing (Primary), State, 347 enrolled
IN ZONE Mairehau Primary School
43 Mahars Road
984 m
Full Primary (Primary & Intermediate), State, 354 enrolled
IN ZONE Christchurch Adventist School
15 Grants Road
1.4 km
Composite (Year 1-13) (Primary, Intermediate & Secondary), State : Integrated, 266 enrolled

IN ZONE Mairehau High School
Hills Road
1.6 km
Secondary (Year 9-13) (Secondary), State, 442 enrolled
IN ZONE He Tīwai Mātauranga Heaton Normal Intermediate
125 Heaton Street
1.8 km
Intermediate (Intermediate), State, 531 enrolled
IN ZONE St Bede's College
210 Main North Road
1.9 km
Secondary (Year 9-13) (Secondary), State : Integrated, 813 enrolled
IN ZONE Marian College
2 Lydia Street
1.9 km
Secondary (Year 9-13) (Secondary), State : Integrated, 417 enrolled
IN ZONE Papanui High School
30 Langdons Road
2 km
Secondary (Year 9-13) (Secondary), State, 1524 enrolled
IN ZONE Emmanuel Christian School
322A Sawyers Arms Road
4 km
Composite (Year 1-10) (Primary, Intermediate & Secondary), State : Integrated, 274 enrolled
IN ZONE Te Puna Wai O Waipapa - Hagley College
510 Hagley Avenue
4.4 km
Secondary (Year 9-13) (Secondary), State, 2120 enrolled
IN ZONE Middleton Grange School
30 Acacia Avenue
6 km
Composite (Year 1-13) (Primary, Intermediate & Secondary), State : Integrated, 1376 enrolled
UNZONED St Francis Of Assisi Catholic School
370 Innes Road
838 m
Full Primary (Primary & Intermediate), State : Integrated, 445 enrolled
OUT OF ZONE St Albans Catholic School (Christchurch)
49 Rutland Street
994 m
Contributing (Primary), State : Integrated, 101 enrolled
OUT OF ZONE St Albans School
17 Sheppard Place
1.2 km
Contributing (Primary), State, 560 enrolled
OUT OF ZONE Papanui Primary School
40 Winters Road
1.4 km
Contributing (Primary), State, 217 enrolled
UNZONED St Andrew's College (Christchurch)
347 Papanui Road
1.4 km
Composite (Year 1-13) (Primary, Intermediate & Secondary), Private : Fully Registered, 1603 enrolled
OUT OF ZONE St Joseph's School (Papanui)
4 Vagues Road
1.6 km
Full Primary (Primary & Intermediate), State : Integrated, 419 enrolled
UNZONED Selwyn House School
122 Merivale Lane
2.1 km
Full Primary (Primary & Intermediate), Private : Fully Registered, 292 enrolled
UNZONED St Margaret's College
12 Winchester Street
2.4 km
Composite (Year 1-13) (Primary, Intermediate & Secondary), Private : Fully Registered, 847 enrolled
UNZONED Rangi Ruru Girls' School
59 Hewitts Road
2.5 km
Secondary (Year 7-13) (Intermediate & Secondary), Private : Fully Registered, 701 enrolled
OUT OF ZONE Christchurch Girls' High School -Te Kura O Hine Waiora
10 Matai Street
3.2 km
Secondary (Year 9-13) (Secondary), State, 1306 enrolled
UNZONED Christ's College
33 Rolleston Avenue
3.5 km
Secondary (Year 9-13) (Secondary), Private : Fully Registered, 730 enrolled

While we've done our best to correctly list schools in this location, school zone information may not be exact, so please double check with the school.