$colour=0;
do {
$pptyid = $row['pptyid'];
if ($colour == 0) {
$colour = 1;
?>

|
|
| Bedrooms: 8 |
Bathrooms: 14.5 |
|
Stylish lavish setting with features beyond expectation.  |
| More > |
|
|
 |
| A world class development site with unique potential. Over 23 stunning acres with nearly 2000ft of beachfront. |
| More > New listing! |
|
|

|
|
| Bedrooms: 9 |
Bathrooms: 12 |
|
One of the finest estate homes in the Caribbean.  |
| More > |
|
|

|
Luxury Beach front home. New Listing.  |
| More > |
|
|
 |
|
| Bedrooms: 5 |
Bathrooms: 5.5 |
|
|
|
 |
| Land is cleared with approved, initial planning approval and blasting permit for lake |
| More > New listing! |
|
|

|
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
|
|
} else { ?>
 |
| La Dolce Vita - Villa Toscana |
| US$ 3,200,000 |
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
| No expense has been spared in producing a truly luxurious canal front home. |
| More > |
|
|
 |
| La Dolce Vita - Villa Palermo |
| US$ 2,950,000 |
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
| No expense has been spared in producing a truly luxurious canal front home. |
| More > |
|
|
 |
| La Dolce Vita - Villa Sorrento |
| US$ 2,850,000 |
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
| No expense has been spared in producing a truly luxurious canal front home. |
| More > |
|
|
 |
| La Dolce Vita - Villa Venetia |
| US$ 2,650,000 |
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
| No expense has been spared in producing a truly luxurious canal front home. |
| More > |
|
|

New Listing |
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
Stunning private home on Seven Mile Beach  |
|
|
 |
| Orchid Drive Peninsula |
| REDUCED US$ 2,595,000 |
|
| Bedrooms: 4 |
Bathrooms: 4.5 |
|
|
|
New Listing!
|
| 1440 Rum Point Drive - Rum Point |
| US$ 2,499,995 |
|
| Bedrooms: 5 |
Bathrooms: 5.5 |
|
| Privacy and seclusion at its best! |
| More > |
|
|
 |
| La Dolce Vita - Villa Florentine |
| US$ 2,450,000 |
|
| Bedrooms: 3 |
Bathrooms: 3.5 |
|
| No expense has been spared in producing a truly luxurious canal front home. |
| More > |
|
|
 |
| Prince Charles Quay |
| US$ 2,400,000 |
|
|
| Unique canalfront home with Caribbean flair, located on a double lot with 200ft of waterfront. |
| More > |
|
|
New Listing!
|
| The Avalon - Apartment #9 |
| REDUCED US$ 2,090,000 |
|
|
| Stunning ground floor unit being sold with Unit #8 to provide unique opportunity to purchase two high income earning units side by side |
| More > |
|
|
New Listing!
|
| Cayman Sands Beach front Retreat |
| US$ 1,995,000 |
|
|
| Northside, Beach front retreat combined with strong rental income and rental history, look no further! |
| More > |
|
|
New Listing!
|
| The Avalon - Apartment #8 |
| REDUCED! US$ 1,990,000 |
|
|
| Quiet ground floor high income earning unit! See opportunity to purchase unit 9! |
| More > |
|
|
|
New Listing!
|
|
| Bedrooms: 4 |
Bathrooms: 4.5 |
|
| Stunning views of George Town Harbour and beyond from this very spacious 4 bedroom/4.5 bathroom, two story penthouse. |
| More > |
|
|
New Listing! Reduced Price!
|
| 47 Hoya Quay, Crystal Harbour |
| US$ 1,399,999 |
|
| Bedrooms:3 |
Bathrooms: 3.5 |
|
| Beautifully presented property rich with architectural details and unique charm, the property possesses an incomparable elegance and oozes artistic flair. |
| More > |
|
|
New Listing!
|
| Land to the rear of Cayman Crossing |
| US$ 1,450,000 |
|
|
| Fantastic opportunity to purchase nearly 8 acres in South Sound. |
| More > |
|
|
 |
| Casa Fiesta |
| US$ 1,395,000 |
|
|
| A beach front home with huge potential for future development. |
| More > |
|
|
New Listing!
|
|
| Bedrooms:4 |
Bathrooms: 4.5 |
|
| This delightful residence presents an excellent opportunity to purchase your personal piece of beach front paradise along Grand Cayman's stunning north coast. |
| More > |
|
|
Governors Harbour
|
|
| Bedrooms: 3 |
Bathrooms: 2.5 |
|
| Governors Harbour, Canal View Single Family Home. Delightful canal front home close to Seven Mile Beach |
| More > |
|
|
New Listing!
|
| Charming residence composed of 4 bed/2 bath, spacious living room, gourmet kitchen, gazebo and pool. This setting of 5 parcels offers the perfect private retreat. |
| More > |
|
|
Further Reduced!
|
| No Big Ting - Rum Point |
| US$ 1,045,000 |
|
|
| Spectacular Ocean Views. |
| More > |
|
|
$colour = 0;
}
?>
} while($row = mysql_fetch_array($result));
?>