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 Aston Bay. Find houses for sale in Aston Bay privately.
There is various private property for sale in Aston Bay. View details of houses for sale or refine your property search.
Aston Bay offers great properties at good prices. Be sure to buy property that suits your housing requirements.
Aston Bay: Aston Bay is next to Jeffreys Bay and Paradise Beach and close to beautiful St. Francis Bay. The prestigious Marina Martinique development is in Aston Bay.
Buying property in Aston Bay - MyRoof.co.za will help you find the perfect property for sale in Aston Bay.
Sell property in Aston Bay. A lot of property buyers are looking for houses in Aston Bay. All private property for sale.
Contact MyRoof.co.za to sell your house in Aston Bay online with floor plans and wide angle photos, a first in South Africa.
Rent Property in Aston Bay. Aston Bay has great simplex to rent and property to rent.
Find private property to rent in Aston Bay. Rent simplex in Aston Bay. Private rental properties in South Africa.
Whether you are lookin for houses to rent, simplexes to rent, or flats to rent in Aston Bay 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 Aston Bay. It's a great suburb with lots to offer renters.
Many people are looking for property to rent in Aston Bay. If you have property to let in Aston Bay you can list your rental property for free.
List your house to let, simplex to let or flat to let in Aston Bay privately. Possible tenants will contact you direcly. There are no commissions or fees.
Buying private property for sale in Aston Bay 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 Aston Bay 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 Aston Bay 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 Aston Bay 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 Aston Bay, 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 Aston Bay or if you want to rent property in Aston Bay by setting up property alerts.
There might be a private sale in Aston Bay which you are interested in. Be sure to add this property to your favourites.
If you have listed property for sale in Aston Bay or property to let in Aston Bay you can view the details of that property.
Calculate what bond you can afford.
If you have trouble finding property for sale in Aston Bay 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
 


Eastern Cape > ECape: Aston Bay


Showing 1 to 79 of 79 in this cluster of suburbs
Order According to:    
 
     R2,450,000  Highest Declined Offer: R 350,000 - Still Accepting
View Details

Aston Bay, ERF 1449

4 bedroom, 3 bathroom, House
MR051769 Bond: R24,460 /month x 20 years
    View Details          
 
     R2,100,000  Highest Declined Offer: R 850,000 - Still Accepting
View Details

Jeffrey's Bay, seebries avenue, ERF 71,...

3 bedroom, 2 bathroom, Sec Title
MR051772 Bond: R20,966 /month x 20 years
    View Details          
 
     R2,100,000  Highest Declined Offer: R 1,400,000 - Still Accepting
View Details

Jeffrey's Bay, 5 RED CURRENT, ERF ERF 25...

4 bedroom, 3 bathroom, House
MR064522 Bond: R20,966 /month x 20 years
    View Details          
 
     R1,700,000             In Progress: R 1,350,000 - Offers welcome
View Details

Jeffrey's Bay, 57 WONDERBOOM, ERF 1715

6 bedroom, 4 bathroom, House
MR049489 Bond: R16,972 /month x 20 years
    View Details          
 
     R1,650,000  Highest Received Offer: R 1,350,000 - more info
View Details

Jeffrey's Bay, 6 HARMONY CRESENT, ERF 10...

4 bedroom, 5 bathroom, House
MR037271 Bond: R16,473 /month x 20 years
    View Details          
 
     R1,500,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 14 boegoe, ERF 5163

4 bedroom, 4 bathroom, House
MR069564 Bond: R14,976 /month x 20 years
    View Details          
 
     R1,450,000  Highest Declined Offer: R 1,000,000 - Still Accepting
View Details

Jeffrey's Bay, 4 De Reyger street, 9 De...

3 bedroom, 2 bathroom, 121 m2 Flat/Apart...
MR75347 Bond: R14,477 /month x 20 years
    View Details          
 
     R1,355,000  Highest Declined Offer: R 550,000 - Still Accepting
View Details

Jeffrey's Bay, 4 DE REYGER, ERF SECTION ...

2 bedroom, 1 bathroom, Sec Title
MR051679 Bond: R13,528 /month x 20 years
    View Details          
 
     R1,300,000             Accepted R 950,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 20 ST FRANCIS STREET

3 bedroom, 2 bathroom, 206 m2 House
MR025548 Bond: R12,979 /month x 20 years
    View Details          
 
     R1,300,000  Highest Declined Offer: R 1,400,000 - Still Accepting
View Details

Jeffrey's Bay, 23 DIAZ STREET, ERF SECT ...

3 bedroom, 2 bathroom, Simplex
MR050227 Bond: R12,979 /month x 20 years
    View Details          
 
     R1,200,000             Accepted R 900,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 26 Blackwood ERF 4040,N...

5 bedroom, 3 bathroom, House
MR059454 Bond: R11,981 /month x 20 years
    View Details          
 
     R1,100,000  Highest Received Offer: R 900,000 - more info
View Details

Jeffrey's Bay, 26 BROOM STREET, ERF 4752...

3 bedroom, 2 bathroom, House
MR053769 Bond: R10,982 /month x 20 years
    View Details          
 
     R1,050,000  Highest Declined Offer: R 555,000 - Still Accepting
View Details

Jeffrey's Bay, 84 Da Gamma Road ERF Se...

2 bedroom, 2 bathroom, 99 m2 House
MR67468 Bond: R10,483 /month x 20 years
    View Details          
 
     R1,050,000  Highest Declined Offer: R 450,000 - Still Accepting
View Details

Jeffrey's Bay, 12 DA GAMA STREET, 50 NEP...

2 bedroom, 1 bathroom, 80 m2 Flat/Apartm...
MR022553 Bond: R10,483 /month x 20 years
    View Details          
 
     R1,050,000             Accepted R 670,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, DA GAMA ROAD, UNIT 3 THE...

2 bedroom, 1 bathroom, Sec Title
MR028388 Bond: R10,483 /month x 20 years
    View Details          
 
     R1,000,000             In Progress: R 700,000 - Offers welcome
View Details

Jeffrey's Bay, 3 Gelderland Street

4 bedroom, 2 bathroom, House
MR65450 Bond: R9,984 /month x 20 years
    View Details          
 
     R980,000  Highest Received Offer: R 691,000 - more info
View Details

Aston Bay, 24 Oswald Street ERF:1220

3 bedroom, 2 bathroom, House
MR99450 Bond: R9,784 /month x 20 years
    View Details          
 
     R950,000             In Progress: R 660,000 - Offers welcome
View Details

Jeffrey's Bay, 1 DA GAMA ROAD, ERF 217, ...

3 bedroom, 2 bathroom, Sec Title
MR038320 Bond: R9,485 /month x 20 years
    View Details          
 
     R950,000             In Progress: R 790,000 - Offers welcome
View Details

Jeffrey's Bay, 14 flame crescent ERF 2...

3 bedroom, 3 bathroom, 100 m2 Sec Title
MR059182 Bond: R9,485 /month x 20 years
    View Details          
 
     R900,000  Highest Received Offer: R 575,000 - more info
View Details

Jeffrey's Bay, 27 G GEELHOUT STREET

3 bedroom, 4 bathroom, 205 m2 House
MR028463 Bond: R8,985 /month x 20 years
    View Details          
 
     R850,000             In Progress: R 800,000 - Offers welcome
View Details

Jeffrey's Bay, 180 AD KEET ROAD, 1 SEEBR...

3 bedroom, 2 bathroom, Sec Title
MR051355 Bond: R8,486 /month x 20 years
    View Details          
 
     R850,000  Highest Received Offer: R 750,000 - more info
View Details

Aston Bay, 74 Bottlebrush Street ERF:349...

3 bedroom, 2 bathroom, 260 m2 House
MR65453 Bond: R8,486 /month x 20 years
    View Details          
 
     R800,000  Highest Declined Offer: R 550,000 - Still Accepting
View Details

Aston Bay, Marina martinique, 29 marina ...

2 bedroom, 1 bathroom, 59 m2 Flat/Apartm...
MR91465 Bond: R7,987 /month x 20 years
    View Details          
 
     R790,000  Highest Declined Offer: R 350,000 - Still Accepting
View Details

Aston Bay, marina martinique, 13B Marina...

2 bedroom, 1 bathroom, 67 m2 Flat/Apartm...
MR91466 Bond: R7,887 /month x 20 years
    View Details          
 
     R750,000  Highest Received Offer: R 430,000 - more info
View Details

Jeffrey's Bay, 21 FLAMBOYANT CRESCENT

4 bedroom, 3 bathroom, 114 m2 House
MR033447 Bond: R7,488 /month x 20 years
    View Details          
 
     R720,000  Highest Declined Offer: R 1,200,000 - Still Accepting
View Details

Jeffrey's Bay, 84 Da Gama Street 4 Vil...

3 bedroom, 2 bathroom, 90 m2 Flat/Apartm...
MR026110 Bond: R7,188 /month x 20 years
    View Details          
 
     R700,000  Highest Received Offer: R 525,000 - more info
View Details

Jeffrey's Bay, 49 NEPTUNE'S TERRACE, ERF...

2 bedroom, 1 bathroom, Sec Title
MR049677 Bond: R6,989 /month x 20 years
    View Details          
 
     R700,000  Highest Received Offer: R 700,000 - more info
View Details

Jeffrey's Bay, 180 AD KEET ROAD, 2 SEEB...

2 bedroom, 2 bathroom, Sec Title
MR052831 Bond: R6,989 /month x 20 years
    View Details          
 
     R700,000             In Progress: R 550,000 - Offers welcome
View Details

Jeffrey's Bay, 23 Koraal Street

4 bedroom, 3 bathroom, House
MR052984 Bond: R6,989 /month x 20 years
    View Details          
 
     R650,000  Highest Received Offer: R 420,000 - more info
View Details

Jeffrey's Bay, 3 Jacaranda Hof, UNIT 12 ...

3 bedroom, 2 bathroom, Sec Title
MR052894 Bond: R6,489 /month x 20 years
    View Details          
 
     R600,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 340 Oswald Street

Land
MR02477 Bond: R5,990 /month x 20 years
    View Details          
 
     R600,000  Highest Received Offer: R 460,000 - more info
View Details

Jeffrey's Bay, Holly Crescent, UNIT 8 S...

3 bedroom, 2 bathroom, 86 m2 Sec Title
MR052790 Bond: R5,990 /month x 20 years
    View Details          
 
     R600,000             In Progress: R 501,000 - Offers welcome
View Details

Jeffrey's Bay, Holy Crescent, ERF 6792,...

3 bedroom, 2 bathroom, 86 m2 Sec Title
MR056607 Bond: R5,990 /month x 20 years
    View Details          
 
     R575,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 35 blue waters developmen...

0 bedroom, 0 bathroom, Land
MR059512 Bond: R5,741 /month x 20 years
    View Details          
 
     R550,000             In Progress: R 360,000 - Offers welcome
View Details

Jeffrey's Bay, 10 LA GRATITUDE

3 bedroom, 2 bathroom, 126 m2 House
MR035713 Bond: R5,491 /month x 20 years
    View Details          
 
     R525,000  Highest Declined Offer: R 365,000 - Still Accepting
View Details

Jeffrey's Bay, 34 Barbet Crescent, Aston...

2 bedroom, 1 bathroom, 90 m2 House
MR039498 Bond: R5,241 /month x 20 years
    View Details          
 
     R500,000  Highest Received Offer: R 370,000 - more info
View Details

Jeffrey's Bay, 12 Da Gama, ERF 7879 Jeff...

1 bedroom, 1 bathroom, 74 m2 Flat/Apartm...
MR76464 Bond: R4,992 /month x 20 years
    View Details          
 
     R500,000             Accepted R 425,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 2 JACAN DRIVE, 4 LITTLE I...

2 bedroom, 1 bathroom, Simplex
MR036328 Bond: R4,992 /month x 20 years
    View Details          
 
     R500,000  Highest Received Offer: R 310,000 - more info
View Details

Jeffrey's Bay, 15 NAUTILUS ROAD,, UNIT ...

2 bedroom, 1 bathroom, 81 m2 Sec Title
MR050164 Bond: R4,992 /month x 20 years
    View Details          
 
     R495,000  Highest Declined Offer: R 380,000 - Still Accepting
View Details

Jeffrey's Bay, 43 NAUTILUS STREET, ERF S...

2 bedroom, 1 bathroom, Sec Title
MR055748 Bond: R4,942 /month x 20 years
    View Details          
 
     R400,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 82 JOHAN MULLER BOULEVARD...

0 bedroom, 0 bathroom, Land
MR062555 Bond: R3,994 /month x 20 years
    View Details          
 
     R400,000  Highest Declined Offer: R 170,000 - Still Accepting
View Details

Aston Bay, Glenny Buchner Drive,Riversi...

0 bedroom, 0 bathroom, Land
MR042130 Bond: R3,994 /month x 20 years
    View Details          
 
     R365,000  Highest Declined Offer: R 140,000 - Still Accepting
View Details

Jeffrey's Bay, 14 PRIDE OF INDIA, ERF ER...

0 bedroom, 0 bathroom, Land
MR062290 Bond: R3,644 /month x 20 years
    View Details          
 
     R350,000  Highest Received Offer: R 185,000 - more info
View Details

Jeffrey's Bay, 891 Aston bay, Marina Mar...

0 bedroom, 0 bathroom, Land
MR43459 Bond: R3,494 /month x 20 years
    View Details          
 
     R300,000             In Progress: R 233,500 - Offers welcome
View Details

Aston Bay, 1392 EVERGLADES CLOSE

0 bedroom, 0 bathroom, 0 m2 Land
MR025407 Bond: R2,995 /month x 20 years
    View Details          
 
     R300,000             Accepted R 160,000 Deal Failed - New Offers
View Details

Aston Bay, Erf 908 ISLAND PALM DRIVE

0 bedroom, 0 bathroom, 0 m2 Land
MR025408 Bond: R2,995 /month x 20 years
    View Details          
 
     R280,000             Accepted R 152,500 Deal Failed - New Offers
View Details

Jeffrey's Bay, 226 baracude, ERF 763

0 bedroom, 0 bathroom, Land
MR038220 Bond: R2,795 /month x 20 years
    View Details          
 
     R250,000             Accepted R 50,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 8268 FENNEL CLOSE, THE SA...

0 bedroom, 0 bathroom, 0 m2 Land
MR025547 Bond: R2,496 /month x 20 years
    View Details          
 
     R250,000  Highest Received Offer: R 140,000 - more info
View Details

Jeffrey's Bay, 38 NAUTILUS STREET

0 bedroom, 0 bathroom, 0 m2 Land
MR025550 Bond: R2,496 /month x 20 years
    View Details          
 
     R240,000             Accepted R 240,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 1197 Glenny Bucnerry Driv...

0 bedroom, 0 bathroom, Land
MR55450 Bond: R2,396 /month x 20 years
    View Details          
 
     R220,000             Accepted R 150,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 8378 Mistletoe Street, T...

0 bedroom, 0 bathroom, Land
MR14490 Bond: R2,196 /month x 20 years
    View Details          
 
     R220,000             Accepted R 165,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 265 The Fountains, ERF Er...

0 bedroom, 0 bathroom, Land
MR23501 Bond: R2,196 /month x 20 years
    View Details          
 
     R220,000             In Progress: R 250,000 - Offers welcome
View Details

Jeffrey's Bay, BLUE WATERS ESTATE

0 bedroom, 0 bathroom, Land
MR32530 Bond: R2,196 /month x 20 years
    View Details          
 
     R220,000             Accepted R 140,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 462 rasberry avenue, ERF ...

0 bedroom, 0 bathroom, Land
MR059600 Bond: R2,196 /month x 20 years
    View Details          
 
     R200,000  Highest Received Offer: R 70,000 - more info
View Details

Jeffrey's Bay, 143 CUMIN CLOSE, fountai...

0 bedroom, 0 bathroom, 0 m2 Land
MR025500 Bond: R1,997 /month x 20 years
    View Details          
 
     R200,000  Highest Pending Offer: R 120,000 - Still Accepting
View Details

Jeffrey's Bay, ERF 8154 clover crescent ...

0 bedroom, 0 bathroom, Land
MR059652 Bond: R1,997 /month x 20 years
    View Details          
 
     R180,000  Highest Received Offer: R 180,000 - more info
View Details

Jeffrey's Bay, 100 Salie Street, Wavecre...

0 bedroom, 0 bathroom, Land
MR75531 Bond: R1,797 /month x 20 years
    View Details          
 
     R180,000             In Progress: R 60,000 - Offers welcome
View Details

Jeffrey's Bay, 11 BUCKTHORN CLOSE

0 bedroom, 0 bathroom, 0 m2 Land
MR025552 Bond: R1,797 /month x 20 years
    View Details          
 
     R180,000             Accepted R 150,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 15 PARADISE ESTATE, ER...

0 bedroom, 0 bathroom, Land
MR061084 Bond: R1,797 /month x 20 years
    View Details          
 
     R160,000  Highest Received Offer: R 126,000 - more info
View Details

Jeffrey's Bay, CUMIN ROAD

0 bedroom, 0 bathroom, 0 m2 Land
MR025551 Bond: R1,597 /month x 20 years
    View Details          
 
     R150,000             Accepted R 140,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, Bilberry Close-fountain ...

0 bedroom, 0 bathroom, Land
MR22508 Bond: R1,498 /month x 20 years
    View Details          
 
     R150,000             Accepted R 135,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, Bilberry Close-fountain ...

0 bedroom, 0 bathroom, Land
MR22509 Bond: R1,498 /month x 20 years
    View Details          
 
     R1,700,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 5 5 ORIBI STREET JEFFERYS...

3 bedroom, 2 bathroom, House
MR058678 Bond: R16,972 /month x 20 years
    View Details          
 
     R1,500,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 28 RED CURRANT STREET

0 bedroom, 0 bathroom, Land
MR041920 Bond: R14,976 /month x 20 years
    View Details          
 
     R1,300,000  Highest Declined Offer: R 750,000 - Still Accepting
View Details

Jeffrey's Bay, 4 LINDEN ROAD, ERF 4885

5 bedroom, 3 bathroom, House
MR073028 Bond: R12,979 /month x 20 years
    View Details          
 
     R1,200,000  Highest Declined Offer: R 610,000 - Still Accepting
View Details

Jeffrey's Bay, 1 DA GAMA, 20 SS THE DUNE

2 bedroom, 1 bathroom, Sec Title
MR040098 Bond: R11,981 /month x 20 years
    View Details          
 
     R870,000  Highest Declined Offer: R 691,000 - Still Accepting
View Details

Jeffrey's Bay, 3 LORRAINE STREET, ERF E...

3 bedroom, 2 bathroom, House
MR064903 Bond: R8,686 /month x 20 years
    View Details          
 
     R850,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, GROEN STREET, UNIT 4, DO...

3 bedroom, 2 bathroom, Sec Title
MR051990 Bond: R8,486 /month x 20 years
    View Details          
 
     R850,000             In Progress: R 580,000 - Offers welcome
View Details

Jeffrey's Bay, 55 DA GAMA ROAD, ERF RE-E...

2 bedroom, 1 bathroom, Sec Title
MR063485 Bond: R8,486 /month x 20 years
    View Details          
 
     R750,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, UNIT 16 SEETEEN STR, ERF ...

2 bedroom, 1 bathroom, Sec Title
MR073084 Bond: R7,488 /month x 20 years
    View Details          
 
     R750,000  Highest Declined Offer: R 500,000 - Still Accepting
View Details

Aston Bay, ERF SECTION 13 SS MARTINIQ...

2 bedroom, 2 bathroom, Sec Title
MR068002 Bond: R7,488 /month x 20 years
    View Details          
 
     R740,000  Highest Pending Offer: R 580,000 - Still Accepting
View Details

Jeffrey's Bay, ERF SECT 1 BROOMSTRAAT...

2 bedroom, 1 bathroom, Sec Title
MR069891 Bond: R7,388 /month x 20 years
    View Details          
 
     R730,000             In Progress: R 640,000 - Offers welcome
View Details

Jeffrey's Bay, TULIP STREET, ERF SECTIO...

3 bedroom, 2 bathroom, Sec Title
MR069067 Bond: R7,288 /month x 20 years
    View Details          
 
     R720,000  Highest Declined Offer: R 518,000 - Still Accepting
View Details

Jeffrey's Bay, ERF SECTION 0012 DIE O...

3 bedroom, 2 bathroom, Sec Title
MR069889 Bond: R7,188 /month x 20 years
    View Details          
 
     R600,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 26 NAUTILUS STREET ERF ...

2 bedroom, 1 bathroom, Sec Title
MR056589 Bond: R5,990 /month x 20 years
    View Details          
 
     R280,000             Accepted R 180,000 Deal Failed - New Offers
View Details

Jeffrey's Bay, 47 KIEWIET

0 bedroom, 0 bathroom, Land
MR041944 Bond: R2,795 /month x 20 years
    View Details          
 
     R240,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, BLUE WATERS ESTATE

0 bedroom, 0 bathroom, Land
MR041947 Bond: R2,396 /month x 20 years
    View Details          
 
     R220,000             In Progress: R 200,000 - Offers welcome
View Details

Jeffrey's Bay, ERF ERF-8705-JEFFREYS ...

0 bedroom, 0 bathroom, Land
MR063484 Bond: R2,196 /month x 20 years
    View Details          
 
     R160,000             Highest Pending Offer: - No offer
View Details

Jeffrey's Bay, 569 THE FOUNTAINS

0 bedroom, 0 bathroom, Land
MR060754 Bond: R1,597 /month x 20 years
    View Details          
Result Page :     1     
Show me results per page
  Neighbouring Suburbs
 

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='2004',@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