( ! ) Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /home/bpweb/public_html/index.php on line 11

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 702
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 708
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 725
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 731
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 737
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 743
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Case statements followed by a semicolon (;) are deprecated, use a colon (:) instead in /home/bpweb/Agentsites/includes/function.php on line 749
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0

( ! ) Deprecated: Constant E_STRICT is deprecated since 8.4, the error level was removed in /home/bpweb/Agentsites/includes/arraysu.php on line 1854
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0
20.0032442344require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11
30.0182688056include_once( '/home/bpweb/Agentsites/includes/arraysu.php ).../function.php:135

( ! ) Deprecated: email_footerblock(): Implicitly marking parameter $dump_array as nullable is deprecated, the explicit nullable type must be used instead in /home/bpweb/Agentsites/includes/notifications_functions.php on line 425
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0
20.0032442344require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11

( ! ) Deprecated: load_mail_template(): Implicitly marking parameter $domain_info as nullable is deprecated, the explicit nullable type must be used instead in /home/bpweb/Agentsites/includes/notifications_functions.php on line 463
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0
20.0032442344require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11

( ! ) Deprecated: load_mail_template(): Implicitly marking parameter $dump_array as nullable is deprecated, the explicit nullable type must be used instead in /home/bpweb/Agentsites/includes/notifications_functions.php on line 463
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0
20.0032442344require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11

( ! ) Deprecated: Validation::rule(): Implicitly marking parameter $params as nullable is deprecated, the explicit nullable type must be used instead in /home/bpweb/Agentsites/includes/classes/class_validation.php on line 998
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0
20.0032442344require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11

( ! ) Deprecated: Validation::error(): Implicitly marking parameter $params as nullable is deprecated, the explicit nullable type must be used instead in /home/bpweb/Agentsites/includes/classes/class_validation.php on line 1234
Call Stack
#TimeMemoryFunctionLocation
10.0002440664{main}( ).../index.php:0
20.0032442344require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11
Search Results
Call Now:

Hardeep Kumar Yh

HR Moon Homes
We are the World
Searching on:
  1. County = Pinellas
  2. Listing Status = Active
Details for 1198 Mandalay Point, CLEARWATER, FL 33767
Single Family
  1. Price: $37,500,000.00
  2. Price sqft: $7,104.96 / sqft
  3. Previous Price: $27,500,000
  4. Last Price Change: 10/29/25
  5. Days On Market: 780
  6. Bedrooms: 3
  7. Baths: 3
  8. Garage / Parking Spaces: 2
  9. Bldg sqft: 5278
  10. Acreage: 42.57 acres
  11. Pool: Yes
  12. Waterfront: Yes
  13. Wateraccess: Yes
  14. Waterfront Type: Bay/Harbor,Beach Front,Gulf/Ocean,Gulf/Ocean to Bay,Lagoon
  15. Year Built: 1987
MLS#: U8231430
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33767
  4. Subdivision: Mandalay Point Sub 1st Add
  5. Provided by: COASTAL PROPERTIES GROUP INTERNATIONAL
  6. mfrmls
  7. DMCA Notice
Description
  1. An opportunity of this caliber rarely presents itself on the west coast of Florida, 1198 Mandalay Point represents extraordinary value for one of the state's most exclusive waterfront properties. Set
Details for 1700 Gulf Boulevard, BELLEAIR BEACH, FL 33786
Single Family
  1. Price: $33,500,000.00
  2. Price sqft: $900.90 / sqft
  3. Previous Price: $34,000,000
  4. Last Price Change: 04/11/26
  5. Days On Market: 160
  6. Bedrooms: 10
  7. Baths: 14
  8. Garage / Parking Spaces: 7
  9. Bldg sqft: 37185
  10. Acreage: 1.17 acres
  11. Pool: Yes
  12. Spa/HotTub: Yes
  13. Waterfront: Yes
  14. Wateraccess: Yes
  15. Waterfront Type: Beach Front,Gulf/Ocean
  16. Year Built: 2015
MLS#: TB8438533
  1. County: PINELLAS
  2. City: BELLEAIR BEACH
  3. Zipcode: 33786
  4. Subdivision: Belleair Beach
  5. Provided by: CHARLES RUTENBERG REALTY INC
  6. mfrmls
  7. DMCA Notice
Description
  1. Welcome to Sandcastle on the Gulf! This one of a kind Beachfront Estate embodies unparalleled luxury and resort style living. This Mediterranean inspired architectural masterpiece spans three lots and
Details for 648 Poinsettia Avenue, CLEARWATER BEACH, FL 33767
Commercial
  1. Price: $24,600,000.00
  2. Price sqft: $1,098.80 / sqft
  3. Days On Market: 394
  4. Bldg sqft: 22388
  5. Acreage: 1.10 acres
  6. Pool: No
  7. Waterfront: No
  8. Year Built: 1960
MLS#: TB8363396
  1. County: PINELLAS
  2. City: CLEARWATER BEACH
  3. Zipcode: 33767
  4. Subdivision: Mandalay
  5. Provided by: VIEWPOINT REALTY INTERNATIONAL
  6. mfrmls
  7. DMCA Notice
Description
  1. 41 unit motel. Over 1 acre of land. 2 minute walk to the beach. Heated pool. Off street parking resurfaced in 2023
Details for 265 Causeway Boulevard, DUNEDIN, FL 34698
Commercial
  1. Price: $18,000,000.00
  2. Price sqft: $454.36 / sqft
  3. Days On Market: 241
  4. Bldg sqft: 39616
  5. Acreage: 1.05 acres
  6. Pool: No
  7. Community Pool: Yes
  8. Waterfront: No
  9. Year Built: 2026
MLS#: TB8418843
  1. County: PINELLAS
  2. City: DUNEDIN
  3. Zipcode: 34698
  4. Provided by: PALM LIFE REALTY
  5. mfrmls
  6. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. Pre Construction. To be built. 12 ICF Luxury Townhomes | 7 Room Boutique Hotel | Retail Winery Space | Pool | STR Zoned Introducing 265 Causeway Blvd
Details for 504 Gulfview Boulevard, CLEARWATER, FL 33767
Commercial
  1. Price: $17,000,000.00
  2. Price sqft: $440.48 / sqft
  3. Previous Price: $26,000,000
  4. Last Price Change: 06/13/25
  5. Days On Market: 779
  6. Bldg sqft: 38594
  7. Acreage: 0.89 acres
  8. Pool: No
  9. Waterfront: Yes
  10. Wateraccess: Yes
  11. Waterfront Type: Canal - Saltwater
  12. Year Built: 1974
MLS#: U8232488
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33767
  4. Subdivision: Columbia Sub 5
  5. Provided by: VIEWPOINT REALTY INT'L INC
  6. mfrmls
  7. DMCA Notice
Description
  1. This waterfront hotel offers 66 units and is an excellent Clearwater Beach location. Waterfront pool. 5 stories and off street parking.
Details for 1114 Mandalay Point, CLEARWATER BEACH, FL 33767
Single Family
  1. Price: $16,750,000.00
  2. Price sqft: $2,245.91 / sqft
  3. Days On Market: 288
  4. Bedrooms: 5
  5. Baths: 5
  6. Garage / Parking Spaces: 2
  7. Bldg sqft: 7458
  8. Acreage: 1.73 acres
  9. Pool: No
  10. Waterfront: Yes
  11. Wateraccess: Yes
  12. Waterfront Type: Bay/Harbor,Gulf/Ocean
  13. Year Built: 1958
MLS#: TB8395604
  1. County: PINELLAS
  2. City: CLEARWATER BEACH
  3. Zipcode: 33767
  4. Subdivision: Mandalay Point Sub
  5. Provided by: COASTAL PROPERTIES GROUP INTERNATIONAL
  6. mfrmls
  7. DMCA Notice
Description
  1. Nestled in the coveted, gated 11 home community at the north end of Clearwater Beach, 1114 Mandalay Point offers a truly rare chance to own one of the most extraordinary waterfront properties on Flori
Details for 2000 Park Street N, ST PETERSBURG, FL 33710
Single Family
  1. Price: $15,100,000.00
  2. Price sqft: $784.62 / sqft
  3. Days On Market: 5
  4. Bedrooms: 5
  5. Baths: 6
  6. Garage / Parking Spaces: 6
  7. Bldg sqft: 19245
  8. Acreage: 1.54 acres
  9. Pool: Yes
  10. Spa/HotTub: Yes
  11. Waterfront: Yes
  12. Wateraccess: Yes
  13. Waterfront Type: Intracoastal Waterway
  14. Year Built: 2020
MLS#: TB8495795
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33710
  4. Subdivision: Golf Course Jungle Sub Rev Ma
  5. Provided by: COLDWELL BANKER REALTY
  6. mfrmls
  7. DMCA Notice
Description
  1. Palazzo Sul Mare is a rare waterfront estate in St. Petersburgs coveted Jungle Prada neighborhood, offering over 19,000 square feet under roof and more than 10,000 square feet of luxurious interior li
Details for 345 Hamden Drive, CLEARWATER BEACH, FL 33767
Commercial
  1. Price: $14,300,000.00
  2. Price sqft: $1,287.48 / sqft
  3. Days On Market: 393
  4. Bldg sqft: 11107
  5. Acreage: 0.38 acres
  6. Pool: No
  7. Waterfront: Yes
  8. Wateraccess: Yes
  9. Waterfront Type: Canal - Saltwater,Intracoastal Waterway
  10. Year Built: 1955
MLS#: TB8363784
  1. County: PINELLAS
  2. City: CLEARWATER BEACH
  3. Zipcode: 33767
  4. Subdivision: Bayside Sub 2
  5. Provided by: VIEWPOINT REALTY INTERNATIONAL
  6. mfrmls
  7. DMCA Notice
Description
  1. Waterfront 22 unit motel. Heated pool renovated in 2024. Waterfront dock with boat lift. Parking resurfaced 2024. Dock measurements are approximate and needs to be verified by buyer
Details for 660 Gulf Boulevard, BELLEAIR SHORES, FL 33786
Single Family
  1. Price: $13,850,000.00
  2. Price sqft: $1,072.65 / sqft
  3. Days On Market: 78
  4. Bedrooms: 7
  5. Baths: 8
  6. Garage / Parking Spaces: 4
  7. Bldg sqft: 12912
  8. Acreage: 0.47 acres
  9. Pool: Yes
  10. Waterfront: Yes
  11. Wateraccess: Yes
  12. Waterfront Type: Gulf/Ocean
  13. Year Built: 2026
MLS#: TB8469775
  1. County: PINELLAS
  2. City: BELLEAIR SHORES
  3. Zipcode: 33786
  4. Subdivision: Belleair Beach
  5. Elementary School: Mildred Helms
  6. Middle School: Largo
  7. High School: Largo
  8. Provided by: CHARLES RUTENBERG REALTY INC
  9. mfrmls
  10. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. Under Construction. Rare PRIVATE BEACH, oceanfront estate opportunity has emerged for a discerning buyer to own a newly constructed home in the prestigi
Details for 333 Hamden Drive, CLEARWATER BEACH, FL 33767
Commercial
  1. Price: $13,650,000.00
  2. Price sqft: $1,015.02 / sqft
  3. Days On Market: 394
  4. Bldg sqft: 13448
  5. Acreage: 0.39 acres
  6. Pool: No
  7. Waterfront: Yes
  8. Wateraccess: Yes
  9. Waterfront Type: Canal - Saltwater,Intracoastal Waterway
  10. Year Built: 1956
MLS#: TB8363416
  1. County: PINELLAS
  2. City: CLEARWATER BEACH
  3. Zipcode: 33767
  4. Subdivision: Bayside Sub 2
  5. Provided by: VIEWPOINT REALTY INTERNATIONAL
  6. mfrmls
  7. DMCA Notice
Description
  1. Clearwater Beach Waterfront motel. 21 units. Renovated heated pool 2024. Waterfront dock. Dock measurements are approximate and needs to be verified by buyer
Hardeep Kumar Yh