Property for sale Private Property For Sale in South Africa
  Bank Repossessed Houses - BARGAINS!  

Contact Us  |  Suburb Search  |  Property Blog
 
Property For SaleSearch Property For SaleList Property For SaleRent PropertyProperty to letHow We WorkMy Profile
 
Search for private property for sale in Greenhills. Find houses for sale in Greenhills privately.
There is various private property for sale in Greenhills. View details of houses for sale or refine your property search.
Greenhills offers great properties at good prices. Be sure to buy property that suits your housing requirements.
Greenhills: Greenhills is located in Randontein
Buying property in Greenhills - MyRoof.co.za will help you find the perfect property for sale in Greenhills.
Sell property in Greenhills. A lot of property buyers are looking for houses in Greenhills. All private property for sale.
Contact MyRoof.co.za to sell your house in Greenhills online with floor plans and wide angle photos, a first in South Africa.
Rent Property in Greenhills. Greenhills has great simplex to rent and property to rent.
Find private property to rent in Greenhills. Rent simplex in Greenhills. Private rental properties in South Africa.
Whether you are lookin for houses to rent, simplexes to rent, or flats to rent in Greenhills we can help you find the ideal property privately.
Once you have found your ideal property to rent we will assist you with all the required rental documentation like the rental lease agreement because of the private sale.
The economic climate in South Africa have seen many property buyers rent property in Greenhills. It's a great suburb with lots to offer renters.
Many people are looking for property to rent in Greenhills. If you have property to let in Greenhills you can list your rental property for free.
List your house to let, simplex to let or flat to let in Greenhills privately. Possible tenants will contact you direcly. There are no commissions or fees.
Buying private property for sale in Greenhills is a simple process. Contact the property owner direcly or make an online offer and we'll take care of the rest.
Listing private property for sale in Greenhills makes sense on MyRoof. You'll only be charged a once off listing fee for your private sale, there is no commission.
It is easy to find property to rent in Greenhills on MyRoof.co.za - we have a wide variety of townhouses to rent, simplexes to rent, houeses to rent and more.
Listing your property to let in Greenhills on MyRoof.co.za is free of charge at the moment. Tenants will contact you directly. We can supply all required documentation.
It doesn't matter if you are buying property, selling property, looking for property to rent or for property to let in Greenhills, we will have what you are looking for.
Once you have found the private property for sale you are looking for it is important to make sure that your contact details are correct so that property buyers and sellers can get hold of you.
We can alert you of new private property for sale in Greenhills or if you want to rent property in Greenhills by setting up property alerts.
There might be a private sale in Greenhills which you are interested in. Be sure to add this property to your favourites.
If you have listed property for sale in Greenhills or property to let in Greenhills you can view the details of that property.
Calculate what bond you can afford.
If you have trouble finding property for sale in Greenhills feel free to contact us on 0861MYROOF or info@myroof.co.za.
Login Now
  Email:  
  Password:  
forgot login? Login
Use the dropdown menu’s below to start your property search:
 
  Province
--------------------------------------------------------------------------------------------------------------------------
Keep me updated on these results via email:
Search

NEW: Click to view all FNB Bank Repossessed Properties: make Online Offers!

 
SEARCH RESULTS - PRIVATE PROPERTY FOR SALE
 
 
Social Bookmarking
 


Gauteng > Gauteng - West: Greenhills


Showing 1 to 81 of 81 in this cluster of suburbs
Order According to:    
 
     R2,000,000             In Progress: R 1,351,000 - Offers welcome
View Details

Randfontein, KANNIEDOOD STREET, 5 Range...

3 bedroom, 1 bathroom, 0 m2 House
MR025725 Bond: R19,968 /month x 20 years
    View Details          
 
     R1,600,000  Highest Declined Offer: R 1,000,000 - Still Accepting
View Details

Randfontein, 60 Springbok Street

4 bedroom, 3 bathroom, 113 m2 House
MR53271 Bond: R15,974 /month x 20 years
    View Details          
 
     R1,265,000  Highest Pending Offer: R 950,000 - Still Accepting
View Details

Greenhills, 13 Boerperd Street

3 bedroom, 2 bathroom, House
MR040454 Bond: R12,630 /month x 20 years
    View Details          
 
     R1,200,000  Highest Received Offer: R 750,000 - more info
View Details

Randfontein, 12 SUSANNA STREET

3 bedroom, 1 bathroom, Farms & Smallhold...
MR028482 Bond: R11,981 /month x 20 years
    View Details          
 
     R1,100,000  Highest Pending Offer: R 800,000 - Still Accepting
View Details

Randfontein, 112 Buiten Street, Randgate

3 bedroom, 2 bathroom, 270 m2 House
MR27329 Bond: R10,982 /month x 20 years
    View Details          
 
     R970,000  Highest Received Offer: R 735,000 - more info
View Details

Randfontein, 8 FLAMINK STREET

3 bedroom, 1 bathroom, House
MR035509 Bond: R9,684 /month x 20 years
    View Details          
 
     R950,000             In Progress: R 800,000 - Offers welcome
View Details

Randfontein, 26 Jan Fiskaal, Helikon Par...

3 bedroom, 2 bathroom, 232 m2 House
MR52364 Bond: R9,485 /month x 20 years
    View Details          
 
     R925,000             Accepted R 650,000 Deal Failed - New Offers
View Details

Randfontein, 100 PELZVALE AH

4 bedroom, 2 bathroom, 220 m2 Farms & Sm...
MR025702 Bond: R9,235 /month x 20 years
    View Details          
 
     R850,000             In Progress: R 718,000 - Offers welcome
View Details

Randfontein, 24 KLEIKOP STREET, ERF 24 V...

6 bedroom, 3 bathroom, House
MR051582 Bond: R8,486 /month x 20 years
    View Details          
 
     R810,000             In Progress: R 580,000 - Offers welcome
View Details

Randfontein, 16 Lark Crescent

3 bedroom, 2 bathroom, House
MR052973 Bond: R8,087 /month x 20 years
    View Details          
 
     R800,000  Highest Received Offer: R 560,000 - more info
View Details

Randfontein, 60 Geldenhuys

3 bedroom, 2 bathroom, House
MR045463 Bond: R7,987 /month x 20 years
    View Details          
 
     R785,000             In Progress: R 600,000 - Offers welcome
View Details

Randfontein, ERF 257

3 bedroom, 2 bathroom, House
MR048600 Bond: R7,837 /month x 20 years
    View Details          
 
     R700,000  Highest Declined Offer: R 200,000 - Still Accepting
View Details

Randfontein, Greenhills, No 20 Makarios

2 bedroom, 1 bathroom, 58 m2 Simplex
MR23363 Bond: R6,989 /month x 20 years
    View Details          
 
     R700,000  Highest Declined Offer: R 320,000 - Still Accepting
View Details

Randfontein, Greenhillside, 23 Makarios

2 bedroom, 1 bathroom, 58 m2 Simplex
MR50368 Bond: R6,989 /month x 20 years
    View Details          
 
     R700,000             In Progress: R 399,000 - Offers welcome
View Details

Randfontein, 15 FRANS OEDER STREET

3 bedroom, 2 bathroom, 120 m2 House
MR035714 Bond: R6,989 /month x 20 years
    View Details          
 
     R700,000  Highest Received Offer: R 550,000 - more info
View Details

Randfontein, ERF 69

3 bedroom, 2 bathroom, House
MR037563 Bond: R6,989 /month x 20 years
    View Details          
 
     R680,000             In Progress: R 420,000 - Offers welcome
View Details

Randfontein, 30 MILKWOOD STREET, UNIT 1 ...

2 bedroom, 2 bathroom, 0 m2 Sec Title
MR025726 Bond: R6,789 /month x 20 years
    View Details          
 
     R670,000  Highest Received Offer: R 600,000 - more info
View Details

Greenhills, 23 CLYDESDALE SINGEL, ERF ER...

3 bedroom, 2 bathroom, House
MR060988 Bond: R6,689 /month x 20 years
    View Details          
 
     R650,000  Highest Declined Offer: R 250,000 - Still Accepting
View Details

Randfontein, 14 A Highway Road, Glen Ach...

Land
MR04318 Bond: R6,489 /month x 20 years
    View Details          
 
     R635,000             Accepted R 550,000 Deal Failed - New Offers
View Details

Randfontein, 17 FLAMINK STREET, ERF ERF-...

3 bedroom, 2 bathroom, 220 m2 House
MR038905 Bond: R6,340 /month x 20 years
    View Details          
 
     R570,000             In Progress: R 350,000 - Offers welcome
View Details

Randfontein, 3 WILLEM ROAD, ERF ERF-1706...

2 bedroom, 1 bathroom, House
MR050233 Bond: R5,691 /month x 20 years
    View Details          
 
     R550,000  Highest Pending Offer: R 400,000 - Still Accepting
View Details

Randfontein, 111 De Villiers Road, Hills...

Land
MR04319 Bond: R5,491 /month x 20 years
    View Details          
 
     R550,000  Highest Declined Offer: R 340,000 - Still Accepting
View Details

Randfontein, ERF ERF 644 RANDFONTEIN ...

2 bedroom, 2 bathroom, Simplex
MR04514 Bond: R5,491 /month x 20 years
    View Details          
 
     R535,000             Accepted R 500,000 Deal Failed - New Offers
View Details

Randfontein, VLEIKOP AH VLEIKOP AH, ERF ...

4 bedroom, 2 bathroom, 230 m2 House
MR029547 Bond: R5,341 /month x 20 years
    View Details          
 
     R530,000  Highest Declined Offer: R 300,000 - Still Accepting
View Details

Randfontein, 167 Village Street, 10 De H...

2 bedroom, 1 bathroom, 59 m2 Flat/Apartm...
MR02481 Bond: R5,291 /month x 20 years
    View Details          
 
     R520,000             Highest Pending Offer: - No offer
View Details

Randfontein, no3 de bof, BARBET CLOSE

2 bedroom, 2 bathroom, 150 m2 Cluster
MR059271 Bond: R5,192 /month x 20 years
    View Details          
 
     R520,000  Highest Declined Offer: R 300,000 - Still Accepting
View Details

Randfontein, 2 ROSEWOOD

2 bedroom, 1 bathroom, Sec Title
MR060140 Bond: R5,192 /month x 20 years
    View Details          
 
     R480,000  Highest Pending Offer: R 400,000 - Still Accepting
View Details

Randfontein, 6 Die Bof, 4 Barbet Close

2 bedroom, 2 bathroom, 92 m2 Cluster
MR20509 Bond: R4,792 /month x 20 years
    View Details          
 
     R470,000             In Progress: R 375,000 - Offers welcome
View Details

Randfontein, 3 The Green Street, 7 The G...

2 bedroom, 2 bathroom, 86 m2 Simplex
MR42287 Bond: R4,692 /month x 20 years
    View Details          
 
     R460,000             Highest Pending Offer: - No offer
View Details

Randfontein, SANITARY LANE, 4 SPARROWCO...

2 bedroom, 1 bathroom, Sec Title
MR04496 Bond: R4,593 /month x 20 years
    View Details          
 
     R459,000  Highest Declined Offer: R 250,000 - Still Accepting
View Details

Randfontein, Wiillem Straat, Section 10...

2 bedroom, 1 bathroom, Flat/Apartment
MR37472 Bond: R4,583 /month x 20 years
    View Details          
 
     R450,000  Highest Declined Offer: R 310,000 - Still Accepting
View Details

Randfontein, cnr of populier en swan, 18...

2 bedroom, 1 bathroom, 79 m2 Flat/Apartm...
MR54294 Bond: R4,493 /month x 20 years
    View Details          
 
     R450,000             In Progress: R 330,000 - Offers welcome
View Details

Greenhills, ERF 1, 11 volare

3 bedroom, 2 bathroom, Sec Title
MR038943 Bond: R4,493 /month x 20 years
    View Details          
 
     R450,000  Highest Pending Offer: R 120,000 - Still Accepting
View Details

Randfontein, 12 JOHNSTONE STREET, ERF SE...

2 bedroom, 1 bathroom, Sec Title
MR056349 Bond: R4,493 /month x 20 years
    View Details          
 
     R420,000             Accepted R 220,000 Deal Failed - New Offers
View Details

Greenhills, Cnr Katherine and Pierneef ...

2 bedroom, 1 bathroom, 58 m2 House
MR31458 Bond: R4,193 /month x 20 years
    View Details          
 
     R420,000  Highest Declined Offer: R 250,000 - Still Accepting
View Details

Greenhills, Cnr Pine & Robina str, 32 Su...

2 bedroom, 1 bathroom, 55 m2 Flat/Apartm...
MR072919 Bond: R4,193 /month x 20 years
    View Details          
 
     R404,000  Highest Declined Offer: R 150,000 - Still Accepting
View Details

Greenhills, ERF SECTION 5 SS GREENHIL...

2 bedroom, 1 bathroom, Sec Title
MR064107 Bond: R4,033 /month x 20 years
    View Details          
 
     R400,000             Accepted R 395,000 Deal Failed - New Offers
View Details

Randfontein, C/O Rubina and Pine Street,...

2 bedroom, 1 bathroom, 60 m2 Simplex
MR04314 Bond: R3,994 /month x 20 years
    View Details          
 
     R400,000             Accepted R 320,000 Deal Failed - New Offers
View Details

Randfontein, 12 Oos Terrace ERF 12

0 bedroom, 0 bathroom, Land
MR022521 Bond: R3,994 /month x 20 years
    View Details          
 
     R400,000             Accepted R 300,000 Deal Failed - New Offers
View Details

Greenhills, 55 greenhills, 5 jirah

2 bedroom, 1 bathroom, Sec Title
MR045863 Bond: R3,994 /month x 20 years
    View Details          
 
     R400,000             Accepted R 320,000 Deal Failed - New Offers
View Details

Randfontein, johnston ERF 692, ss fl...

2 bedroom, 2 bathroom, Sec Title
MR055162 Bond: R3,994 /month x 20 years
    View Details          
 
     R399,000             Accepted R 350,000 Deal Failed - New Offers
View Details

Randfontein, Christiaan Street, 53 Heli...

2 bedroom, 1 bathroom, 60 m2 House
MR81452 Bond: R3,984 /month x 20 years
    View Details          
 
     R390,000  Highest Received Offer: R 260,000 - more info
View Details

Greenhills, Corner Katherine & Pierneef...

2 bedroom, 1 bathroom, 55 m2 Sec Title
MR026660 Bond: R3,894 /month x 20 years
    View Details          
 
     R380,000             Accepted R 300,000 Deal Failed - New Offers
View Details

Randfontein, WILLEM ROAD, ERF 1707-GREE...

2 bedroom, 1 bathroom, Sec Title
MR037991 Bond: R3,794 /month x 20 years
    View Details          
 
     R380,000             Highest Pending Offer: - No offer
View Details

Randfontein, 12 FRITZ KRAMPE AVE, ERF ER...

2 bedroom, 1 bathroom, Sec Title
MR038877 Bond: R3,794 /month x 20 years
    View Details          
 
     R360,000  Highest Pending Offer: R 300,000 - Still Accepting
View Details

Randfontein, 2 Willem Street, 38 Green H...

2 bedroom, 1 bathroom, 58 m2 Flat/Apartm...
MR05295 Bond: R3,594 /month x 20 years
    View Details          
 
     R360,000  Highest Received Offer: R 210,000 - more info
View Details

Greenhills, Cnr Katherine and Pierneef ...

2 bedroom, 1 bathroom, 58 m2 House
MR28469 Bond: R3,594 /month x 20 years
    View Details          
 
     R360,000             Accepted R 270,000 Deal Failed - New Offers
View Details

Randfontein, CNR KATHERINE & PIERNEEF ...

2 bedroom, 1 bathroom, Sec Title
MR22498 Bond: R3,594 /month x 20 years
    View Details          
 
     R355,000             In Progress: R 170,000 - Offers welcome
View Details

Randfontein, KATHERINE STREET, UNIT 15 ...

2 bedroom, 1 bathroom, 0 m2 Sec Title
MR025516 Bond: R3,544 /month x 20 years
    View Details          
 
     R350,000             Accepted R 300,000 Deal Failed - New Offers
View Details

Randfontein, 59 KIGHFISHER AVENUE, ERF E...

2 bedroom, 2 bathroom, Sec Title
MR050504 Bond: R3,494 /month x 20 years
    View Details          
 
     R350,000  Highest Received Offer: R 345,000 - more info
View Details

Randfontein, 244 5TH ROAD, ERF HOLDING 2...

2 bedroom, 2 bathroom, House
MR055715 Bond: R3,494 /month x 20 years
    View Details          
 
     R350,000  Highest Declined Offer: R 105,000 - Still Accepting
View Details

Greenhills, Jirah Pienaar Street, ERF E...

2 bedroom, 1 bathroom, Sec Title
MR062255 Bond: R3,494 /month x 20 years
    View Details          
 
     R335,000             Accepted R 290,000 Deal Failed - New Offers
View Details

Greenhills, willem str 2 GREENHILLS G...

2 bedroom, 1 bathroom, Sec Title
MR060131 Bond: R3,345 /month x 20 years
    View Details          
 
     R320,000             Accepted R 240,000 Deal Failed - New Offers
View Details

Greenhills, Fritz Kamp Avenue, Greenhil...

2 bedroom, 1 bathroom, 41 m2 House
MR66449 Bond: R3,195 /month x 20 years
    View Details          
 
     R320,000             Accepted R 260,000 Deal Failed - New Offers
View Details

Greenhills, Cnr Katherine & Pierneef St...

2 bedroom, 1 bathroom, 57 m2 Flat/Apartm...
MR23510 Bond: R3,195 /month x 20 years
    View Details          
 
     R315,000             Accepted R 280,000 Deal Failed - New Offers
View Details

Greenhills, CNR KATHERINE & PIERNEEF S...

2 bedroom, 1 bathroom, Sec Title
MR056072 Bond: R3,145 /month x 20 years
    View Details          
 
     R300,000             Highest Pending Offer: - No offer
View Details

Greenhills, 12 FRITZ KRAMPE STREET, E...

1 bedroom, 1 bathroom, Simplex
MR023149 Bond: R2,995 /month x 20 years
    View Details          
 
     R300,000             In Progress: R 180,000 - Offers welcome
View Details

Randfontein, 1707 WILLEM ROAD, UNIT 53 ...

2 bedroom, 1 bathroom, 0 m2 Sec Title
MR025515 Bond: R2,995 /month x 20 years
    View Details          
 
     R300,000             Accepted R 250,000 Deal Failed - New Offers
View Details

Randfontein, GEORGE ROAD, UNIT 10 SS-SA...

2 bedroom, 1 bathroom, 0 m2 Sec Title
MR025852 Bond: R2,995 /month x 20 years
    View Details          
 
     R300,000  Highest Received Offer: R 220,000 - more info
View Details

Randfontein, 63 STEGMANN STREET, ERF ERF...

2 bedroom, 1 bathroom, House
MR049730 Bond: R2,995 /month x 20 years
    View Details          
 
     R299,000             In Progress: R 230,000 - Offers welcome
View Details

Greenhills, Cnr Katherine and Pierneef ...

2 bedroom, 1 bathroom, 58 m2 House
MR61445 Bond: R2,985 /month x 20 years
    View Details          
 
     R266,000             Accepted R 250,000 Deal Failed - New Offers
View Details

Randfontein, 25 MAIN REEF ROAD, BOSTON V...

2 bedroom, 1 bathroom, Sec Title
MR028691 Bond: R2,656 /month x 20 years
    View Details          
 
     R249,000             Accepted R 183,000 Deal Failed - New Offers
View Details

Randfontein, 836 Seventh Sreet ERF 836...

3 bedroom, 1 bathroom, Flat/Apartment
MR022699 Bond: R2,486 /month x 20 years
    View Details          
 
     R205,000             In Progress: R 420,000 - Offers welcome
View Details

Randfontein, 13 AVALONIA AGRICULTURAL HO...

2 bedroom, 2 bathroom, 233 m2 Cluster
MR028411 Bond: R2,047 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 175,000 - Still Accepting
View Details

Randfontein, Stasie Street, 101 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR47337 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 160,000 - Still Accepting
View Details

Randfontein, Stasie Street, 212 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR47338 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 150,000 - Still Accepting
View Details

Randfontein, Stasie Street, 211 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR47339 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 175,000 - Still Accepting
View Details

Randfontein, Stasie Street, 210 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR48330 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 175,000 - Still Accepting
View Details

Randfontein, Stasie Street, 209 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR48332 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 150,000 - Still Accepting
View Details

Randfontein, Stasie Street, 208 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR48334 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 175,000 - Still Accepting
View Details

Randfontein, Stasie Street, 207 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR48336 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 150,000 - Still Accepting
View Details

Randfontein, Stasie Street, 206 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR48338 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 150,000 - Still Accepting
View Details

Randfontein, Stasie Street, 205 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR48339 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Declined Offer: R 100,000 - Still Accepting
View Details

Randfontein, Stasie Street, 204 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR49331 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 150,000 - Still Accepting
View Details

Randfontein, Stasie Street, 203 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR49333 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000             Highest Pending Offer: - No offer
View Details

Randfontein, Stasie Street, 202 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR49335 Bond: R1,747 /month x 20 years
    View Details          
 
     R175,000  Highest Pending Offer: R 145,000 - Still Accepting
View Details

Randfontein, Stasie Street, 201 Randfont...

1 bedroom, 1 bathroom, 31 m2 Flat/Apartm...
MR49337 Bond: R1,747 /month x 20 years
    View Details          
 
     R100,000  Highest Pending Offer: R 205,000 - Still Accepting
View Details

Randfontein, 5 La Farm Rietfontein, Old ...

Land
MR27403 Bond: R998 /month x 20 years
    View Details          
 
     R20,000             In Progress: R 20,000 - Offers welcome
View Details

Randfontein, 12 VAN DER BERG STREET

1 bedroom, 1 bathroom, Sec Title
MR035725 Bond: R200 /month x 20 years
    View Details          
 
     R500,000             Highest Pending Offer: - No offer
View Details

Randfontein, N14 ERF ERF 5 AVALONIA A/...

0 bedroom, 0 bathroom, Land
MR073603 Bond: R4,992 /month x 20 years
    View Details          
 
     R435,000             Accepted R 400,000 Deal Failed - New Offers
View Details

Randfontein, 223 ruby street

3 bedroom, 1 bathroom, House
MR070444 Bond: R4,343 /month x 20 years
    View Details          
Result Page :     1     
Show me results per page
  Neighbouring Suburbs
  Other Suburbs in this Area
 

Property for sale
Private Property For Sale  Property For Sale   |   © MyRoof 2012   |   Privacy Policy   |    Terms & Conditions    |    Contact Us


exec dbo.[Get_SearchResultsNEW] @province_id='0',@region_id='0', @suburb_id='2219',@fromPrice=0,@toPrice=30000000,@listing_type_id=0, @bedrooms=0, @bathrooms=0, @client_id=0, @property_type_id='0',@lounges=0, @pool=2, @erf_size='0',@floor_area='0', @garages=-1, @chkUpdAlerts='0',@chkUpdSMS='0',@alert_id=-1, @UpdateAlerts='Y', @SellerTypeID=0,@for_sale=1,@to_let=0