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

    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. 242 Mayfair Avenue, Mayfair, Hastings
Estimate

242 Mayfair Avenue, Mayfair, Hastings

HomesEstimate: null - null
  • -
  • -
  • 2 Parks

Property details

Ownership type (Council record)
Freehold
Floor Area (Council record)
156m² more or less
Land area (Council record)
849m² more or less
Garage parking (Council record)
2 Garage parking
Off-street parking (Council record)
2 Off-street parking
Has deck (Council record)
Yes
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

Not yet available

What is the HomesEstimate?

RentEstimate

Updated: 02 Aug 2026

$410 - $720 /week

Rental yield

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

  1. 01 August 2025
    Capital Value

    $710,000

  2. 01 August 2022
    Capital Value

    $750,000

  3. 01 August 2019
    Capital Value

    $530,000

  4. 01 August 2016
    Capital Value

    $385,000

  5. 06 April 2016
    Sold

    $N/A

    S33
  6. 23 July 2015
    Sold

    $350,000

    S11
  7. 01 August 2013
    Capital Value

    $320,000

  8. 18 March 1997
    Sold

    $148,000

    S11
  9. 07 June 1996
    Sold

    $128,000

    S11
  10. 01 January 1950
    Decade built

    1950

Local Schools

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

    1110 Willowpark Road North

    457 m

    Contributing (Primary), State, 213 enrolled


  • IN ZONE St John's College (Hastings)

    410 Jervois Street

    699 m

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


  • IN ZONE Taikura Rudolf Steiner School

    505 Nelson Street

    1.3 km

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


  • IN ZONE Mahora School

    710 Frederick Street

    1.3 km

    Contributing (Primary), State, 353 enrolled


  • IN ZONE Lindisfarne College

    600 Pakowhai Road

    2.2 km

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


  • IN ZONE Hastings Girls' High School – Ngā Rau Huia O Ākina

    508 Pakowhai Road

    2.3 km

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


  • IN ZONE Hastings Intermediate

    621 Hastings Street South

    2.5 km

    Intermediate (Intermediate), State, 378 enrolled


  • IN ZONE Hastings Christian School

    1009 Copeland Road

    3 km

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


  • IN ZONE Iona College

    42 Lucknow Road

    5.3 km

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


  • IN ZONE Woodford House

    3 Iona Road

    5.9 km

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


  • IN ZONE St Joseph's Maori Girls' College

    25 Osier Road

    11.9 km

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


  • UNZONED Te Kōhanga Reo O Te Amorangi Hāpai O Rongokako

    116 Duchess Crescent

    452 m

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


  • UNZONED Mayfair Kindergarten

    1210 Cunningham Crescent

    777 m

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


  • UNZONED Te Kōhanga Reo O Te Reo Aroha

    103 Alexandra Cres

    871 m

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


  • UNZONED Te Kōhanga Reo O Waipatu

    Waipatu Marae 75 Karamu Road

    1.2 km

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


  • UNZONED Mahora Kindergarten

    818 Rangiora Street

    1.3 km

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


  • UNZONED St Mary's Catholic School (Hastings)

    901 Frederick Street

    1.5 km

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


  • OUT OF ZONE Karamū High School

    Windsor Avenue

    1.5 km

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


  • UNZONED St Joseph's School (Hastings)

    404 Eastbourne Street East

    1.8 km

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


  • UNZONED Tkkm O Te Wananga Whare Tapere O Takitimu

    106 Bennett Road

    1.8 km

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


  • UNZONED St Matthew's Primary School (Hastings)

    200 King Street South

    1.9 km

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


  • OUT OF ZONE Parkvale School

    1217 Howard Street

    2 km

    Contributing (Primary), State, 481 enrolled


  • UNZONED Hastings Boys' High School

    800 South Karamu Road

    2.8 km

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


  • OUT OF ZONE Heretaunga Intermediate

    260 Orchard Road

    3.2 km

    Intermediate (Intermediate), State, 285 enrolled


  • UNZONED Te Aratika Academy

    314 State Highway 51

    3.4 km

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


  • UNZONED Hukarere Girls' College

    31 Napier Road

    4.1 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

Sold
225 Grove Road, Mayfair, Hastings
Sold: 05 Aug 2026
225 Grove Road, Mayfair, Hastings
  • 3
  • 1
SOLD: $550,000
Sold
114 Harlech Street, Mayfair, Hastings
Sold: 11 Jun 2026
114 Harlech Street, Mayfair, Hastings
  • 3
  • 1
SOLD: $680,000
Sold
809 Maitland Crescent, Mayfair, Hastings
Sold: 08 Jun 2026
809 Maitland Crescent, Mayfair, Hastings
  • 3
  • 1
SOLD: $660,000
Sold
917 Collinge Road, Mayfair, Hastings
Sold: 03 Jun 2026
917 Collinge Road, Mayfair, Hastings
  • 4
  • 2
SOLD: $695,000
Sold
100B Mayfair Avenue, Mayfair, Hastings
Sold: 29 May 2026
100B Mayfair Avenue, Mayfair, Hastings
  • 2
  • 1
SOLD: $470,000
Sold
1308 Jellicoe Street, Mayfair, Hastings
Sold: 28 May 2026
1308 Jellicoe Street, Mayfair, Hastings
  • 3
  • 1
SOLD: $60,000
Sold
1009 Sussex Street, Mayfair, Hastings
Sold: 14 May 2026
1009 Sussex Street, Mayfair, Hastings
  • 2
  • 1
SOLD: $455,000
Sold
1114 Jellicoe Street, Mayfair, Hastings
Sold: 11 May 2026
1114 Jellicoe Street, Mayfair, Hastings
  • 3
  • 1
SOLD: $560,000
Sold
1217 Willowpark Road North, Mayfair, Hastings
Sold: 08 May 2026
1217 Willowpark Road North, Mayfair, Hastings
  • 5
  • 2
SOLD: $570,000
Sold
102 Frederick Street East, Mayfair, Hastings
Sold: 05 May 2026
102 Frederick Street East, Mayfair, Hastings
  • 3
  • 1
SOLD: $447,000

Properties for sale around Mayfair

View all

916-974 Heretaunga St W, Saint Leonards, Hastings

Deadline sale by 30 Nov
No image
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
  • Property news & guides
  • Sold Properties
  • Open Homes
  • 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
  • 3rd Party Licenses
  • Seller information
  • Help center community
  • Desktop site
  • Help
  • Contact Us
  • Terms & conditions
  • About Us
  • News
  • Careers
  • Advertise
  • Privacy policy
  • 3rd Party Licenses
  • 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
  • 3rd Party Licenses
  • Contact Us
Log in
Sign up
© 2026 Trade Me Limited