Skip to site navigation Skip to main content
Trade Me
  • Watchlist
  • Favourites
  • Start a listing
  • Sign up Log in
  • For sale
  • For rent
  • Sold
  • New homes
  • Commercial
  • List a property
  • For sale
  • For rent
  • Sold
  • New homes
  • Flatmates
  • Commercial
  • Rural
  • Businesses
  • Retirement villages
Request an Appraisal Find an Agent News & Selling guides Seller's hub
List a property
    My Homes
    Buyers guides
    Renters guides
    Research sold properties
    International property

    homes logo

    Property tools and information to help you research the market.

main content
  1. Home
  2. Property
  3. Sold
  4. Hastings
  5. Mayfair
  6. 117 Warwick Road, Mayfair, Hastings
Estimate

117 Warwick Road, Mayfair, Hastings

HomesEstimate: $655K - $730K
  • 3 Beds
  • 1 Bath
  • 1 Park

Property details

Freehold
105m² more or less
3 Bedrooms
1 Bathroom
1 Garage parking
1 Off-street parking
Track home card illustration

Stay updated on this property!

Receive updates on value estimates and be the first to know if it goes on sale.

Property estimateCapital valueTrends

HomesEstimate

Updated: 16 Apr 2026

$655K - $730K

What is the HomesEstimate?

RentEstimate

Updated: 02 Apr 2026

$370 - $560 /week

Rental yield

3.5%

What is rental yield?

These are computer-generated price estimates.
To understand your home’s value, get an appraisal from a local agent.

Sale history timeline

20 May 2026
Capital Value

$670,000

01 August 2025
Capital Value

$670,000

01 August 2022
Capital Value

$730,000

01 August 2019
Capital Value

$475,000

01 August 2016
Capital Value

$325,000

01 August 2013
Capital Value

$250,000

25 June 2001
Sold

$134,000

S11
07 March 1996
Sold

$139,000

S11
15 April 1993
Sold

$132,000

S11
20 January 1989
Sold

$65,500

S11
01 January 1950
Decade built

1950

Local Schools

All (26) Primary (9) Intermediate (12) Secondary (13)
  • IN ZONE

    1110 Willowpark Road North

    878 m

    Contributing (Primary), State, 213 enrolled


  • IN ZONE

    710 Frederick Street

    1 km

    Contributing (Primary), State, 353 enrolled


  • IN ZONE

    410 Jervois Street

    1.1 km

    Secondary (Year 9-13) (Secondary), State : Integrated, 424 enrolled


  • IN ZONE

    505 Nelson Street

    1.3 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), State : Integrated, 295 enrolled


  • IN ZONE

    600 Pakowhai Road

    1.9 km

    Secondary (Year 7-13) (Intermediate & Secondary), State : Integrated, 561 enrolled


  • IN ZONE

    508 Pakowhai Road

    2 km

    Secondary (Year 9-13) (Secondary), State, 583 enrolled


  • IN ZONE

    621 Hastings Street South

    2.7 km

    Intermediate (Intermediate), State, 378 enrolled


  • IN ZONE

    1009 Copeland Road

    3.3 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), State : Integrated, 327 enrolled


  • IN ZONE

    42 Lucknow Road

    5.7 km

    Secondary (Year 7-13) (Intermediate & Secondary), State : Integrated, 332 enrolled


  • IN ZONE

    3 Iona Road

    6.3 km

    Secondary (Year 7-13) (Intermediate & Secondary), State : Integrated, 387 enrolled


  • IN ZONE

    25 Osier Road

    11.5 km

    Secondary (Year 7-13) (Intermediate & Secondary), State : Integrated, 169 enrolled


  • UNZONED

    116 Duchess Crescent

    678 m

    Te Kōhanga Reo (Early Childhood), Community based, 26 enrolled


  • UNZONED

    818 Rangiora Street

    1 km

    Free Kindergarten (Early Childhood), Community based, 49 enrolled


  • UNZONED

    103 Alexandra Cres

    1 km

    Te Kōhanga Reo (Early Childhood), Community based, 26 enrolled


  • UNZONED

    901 Frederick Street

    1.2 km

    Full Primary (Primary & Intermediate), State : Integrated, 279 enrolled


  • UNZONED

    1210 Cunningham Crescent

    1.2 km

    Free Kindergarten (Early Childhood), Community based, 32 enrolled


  • UNZONED

    Waipatu Marae 75 Karamu Road

    1.3 km

    Te Kōhanga Reo (Early Childhood), Community based, 19 enrolled


  • UNZONED

    106 Bennett Road

    1.6 km

    Composite (Year 1-13) (Primary, Intermediate & Secondary), State, 270 enrolled


  • OUT OF ZONE

    Windsor Avenue

    2 km

    Secondary (Year 9-13) (Secondary), State, 892 enrolled


  • UNZONED

    200 King Street South

    2 km

    Full Primary (Primary & Intermediate), State : Integrated, 156 enrolled


  • UNZONED

    404 Eastbourne Street East

    2.1 km

    Full Primary (Primary & Intermediate), State : Integrated, 282 enrolled


  • OUT OF ZONE

    200 Frimley Road

    2.1 km

    Contributing (Primary), State, 502 enrolled


  • UNZONED

    800 South Karamu Road

    3 km

    Secondary (Year 9-13) (Secondary), State, 802 enrolled


  • OUT OF ZONE

    260 Orchard Road

    3 km

    Intermediate (Intermediate), State, 285 enrolled


  • UNZONED

    314 State Highway 51

    3.3 km

    Secondary (Year 9-13) (Secondary), State, 62 enrolled


  • UNZONED

    31 Napier Road

    4.5 km

    Secondary (Year 9-13) (Secondary), State : Integrated, 61 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.

Nearby Sold Properties

View all
Sold
1033A Hood Street, Mayfair, Hastings
Sold: 16 Mar 2026
1033A Hood Street, Mayfair, Hastings
  • 3
  • 1
SOLD: $565,000
Sold
807 Anson Street, Mayfair, Hastings
Sold: 03 Mar 2026
807 Anson Street, Mayfair, Hastings
  • 3
  • 1
SOLD: $550,000
Sold
108A Warwick Road, Mayfair, Hastings
Sold: 24 Feb 2026
108A Warwick Road, Mayfair, Hastings
  • 2
  • 1
SOLD: $560,000
Sold
807A Jervois Street, Mayfair, Hastings
Sold: 20 Feb 2026
807A Jervois Street, Mayfair, Hastings
  • 4
  • 1
SOLD: $255,000
Sold
9/212 Grove RD, Mayfair, Havelock North
Sold: 13 Feb 2026
9/212 Grove RD, Mayfair, Havelock North
  • 2
  • 1
SOLD: $600,000
Sold
202A Grove Road, Mayfair, Hastings
Sold: 11 Feb 2026
202A Grove Road, Mayfair, Hastings
  • 2
  • 1
SOLD: $428,500
Sold
1105 Cunningham Crescent, Mayfair, Hastings
Sold: 10 Feb 2026
1105 Cunningham Crescent, Mayfair, Hastings
  • 3
  • 1
SOLD: $540,000
Sold
103 Warwick Road, Mayfair, Hastings
Sold: 05 Feb 2026
103 Warwick Road, Mayfair, Hastings
  • 4
  • 2
SOLD: $760,000
Sold
700 Grove Road, Mayfair, Hastings
Sold: 05 Feb 2026
700 Grove Road, Mayfair, Hastings
  • 4
  • 1
SOLD: $650,000
Sold
1306 Jellicoe Street, Mayfair, Hastings
Sold: 28 Jan 2026
1306 Jellicoe Street, Mayfair, Hastings
  • 4
  • 1
SOLD: $535,000
Thinking of selling?Determine your property's value with an appraisal
We are upgrading some of our systems
Learn more
  • Trade Me
  • Start a listing
  • Watchlist
  • Favourites
  • Log in
    Sign up
  • Marketplace
  • Latest deals
  • Stores
  • Closing soon
  • $1 reserve
  • Home & Living
  • Property
  • International property
  • Property news & guides
  • Sold Properties
  • OneHub for agents
  • Find a Real Estate Agent
  • Motors
  • Cars for sale
  • Motorbikes for sale
  • Buying & selling advice
  • Dealer news & info
  • Sell my car
  • Jobs
  • Browse job categories
  • Careers advice
  • JobSmart
  • Advertisers advice
  • Salary guide
  • Services
  • Trades
  • Domestic services
  • Events & entertainment
  • Health & wellbeing
  • List my services
  • Community
  • Help
  • Announcements
  • Trust & safety
  • Seller information
  • Help center community
  • Desktop site
  • Help
  • Contact Us
  • Terms & conditions
  • About Us
  • News
  • Careers
  • Advertise
  • Privacy policy
  • Trade Me Insurance
  • homes.co.nz
  • MotorWeb
  • CarExpert
  • Holiday Houses
  • FindSomeone
© 2026 Trade Me Limited
  • Desktop site
  • About Us
  • Careers
  • News
  • Advertise
  • Privacy policy
  • Terms & conditions
  • Contact Us
Log in
Sign up
© 2026 Trade Me Limited