( ! ) 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.0001440728{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.0001440728{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.0001440728{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.0001440728{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.0001440728{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.0001440728{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.0001440728{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.0001440728{main}( ).../index.php:0
20.0035442408require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11
30.0195688120include_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.0001440728{main}( ).../index.php:0
20.0035442408require( '/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.0001440728{main}( ).../index.php:0
20.0035442408require( '/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.0001440728{main}( ).../index.php:0
20.0035442408require( '/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.0001440728{main}( ).../index.php:0
20.0035442408require( '/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.0001440728{main}( ).../index.php:0
20.0035442408require( '/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. Subdivision Like Overlook
  2. Listing Status = Active
Details for 3830 Shore Acres Boulevard Ne, ST PETERSBURG, FL 33703
Single Family
  1. Price: $4,395,000.00
  2. Price sqft: $506.34 / sqft
  3. Days On Market: 72
  4. Bedrooms: 6
  5. Baths: 7
  6. Garage / Parking Spaces: 4
  7. Bldg sqft: 8680
  8. Acreage: 0.29 acres
  9. Pool: Yes
  10. Spa/HotTub: Yes
  11. Waterfront: Yes
  12. Wateraccess: Yes
  13. Waterfront Type: Bay/Harbor
  14. Year Built: 2023
MLS#: TB8472930
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33703
  4. Subdivision: Shore Acres Overlook Sec
  5. Elementary School: Shore Acres Elementary PN
  6. Middle School: Meadowlawn Middle PN
  7. High School: Northeast High PN
  8. Provided by: CHARLES RUTENBERG REALTY INC
  9. mfrmls
  10. DMCA Notice
Description
  1. This exceptional waterfront residence, built in 2023, delivers a refined blend of modern design, advanced technology, and sweeping open bayou views. Thoughtfully enhanced over time and constructed wit
Details for 3319 Bayshore Boulevard Ne, ST PETERSBURG, FL 33703
Single Family
  1. Price: $2,650,000.00
  2. Price sqft: $668.85 / sqft
  3. Days On Market: 299
  4. Bedrooms: 3
  5. Baths: 3
  6. Garage / Parking Spaces: 2
  7. Bldg sqft: 3962
  8. Acreage: 0.24 acres
  9. Pool: Yes
  10. Spa/HotTub: Yes
  11. Waterfront: Yes
  12. Wateraccess: Yes
  13. Waterfront Type: Bay/Harbor,Gulf/Ocean to Bay
  14. Year Built: 1960
MLS#: TB8400049
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33703
  4. Subdivision: Shore Acres Overlook Sec
  5. Provided by: BROPHY REAL ESTATE
  6. mfrmls
  7. DMCA Notice
Description
  1. Welcome to this spectacular open water estate on Bayshore Boulevard Northeast, offering unparalleled views of Tampa Bay and showcasing the pinnacle of luxurious coastal living. Situated on nearly a qu
Details for 5340 Bowman Drive, WINTER GARDEN, FL 34787
Single Family
  1. Price: $2,195,000.00
  2. Price sqft: $257.66 / sqft
  3. Days On Market: 5
  4. Bedrooms: 5
  5. Baths: 7
  6. Garage / Parking Spaces: 3
  7. Bldg sqft: 8519
  8. Acreage: 2.73 acres
  9. Pool: No
  10. Waterfront: Yes
  11. Wateraccess: Yes
  12. Waterfront Type: Lake Front
  13. Year Built: 2017
MLS#: O6398618
  1. County: ORANGE
  2. City: WINTER GARDEN
  3. Zipcode: 34787
  4. Subdivision: Overlook 2hamlin Ph 1 6
  5. Elementary School: Keene Crossing Elementary
  6. Middle School: Bridgewater Middle
  7. High School: Windermere High School
  8. Provided by: CORCORAN PREMIER REALTY
  9. mfrmls
  10. DMCA Notice
Description
  1. Lakefront living, done at scale. Set along approximately 160 feet of shoreline on Lake Hancock, this five bedroom, six and a half bath residence delivers expansive water views, refined finishes, and a
Details for 3752 Arkansas Avenue Ne, ST PETERSBURG, FL 33703
Single Family
  1. Price: $1,900,000.00
  2. Price sqft: $316.56 / sqft
  3. Days On Market: 81
  4. Bedrooms: 5
  5. Baths: 5
  6. Garage / Parking Spaces: 5
  7. Bldg sqft: 6002
  8. Acreage: 0.15 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2025
MLS#: TB8469471
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33703
  4. Subdivision: Shore Acres Overlook Sec
  5. Elementary School: Shore Acres Elementary PN
  6. Middle School: Meadowlawn Middle PN
  7. High School: Northeast High PN
  8. Provided by: CENTURY 21 BEGGINS
  9. mfrmls
  10. DMCA Notice
Description
  1. A refined expression of modern luxury, this custom new construction by Iridium Development delivers exceptional craftsmanship, thoughtful design, and an elevated Northeast St. Petersburg lifestyle jus
Details for 4111 Arkansas Avenue Ne, ST PETERSBURG, FL 33703
Single Family
  1. Price: $1,790,000.00
  2. Price sqft: $346.23 / sqft
  3. Previous Price: $1,649,900
  4. Last Price Change: 03/03/26
  5. Days On Market: 48
  6. Bedrooms: 4
  7. Baths: 4
  8. Garage / Parking Spaces: 2
  9. Bldg sqft: 5170
  10. Acreage: 0.16 acres
  11. Pool: Yes
  12. Waterfront: No
  13. Year Built: 2027
MLS#: A4684205
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33703
  4. Subdivision: Shore Acres Overlook Sec
  5. Provided by: THE REAL ESTATE STORE
  6. mfrmls
  7. DMCA Notice
Description
  1. Pre Construction. To be built. The ultimate luxury opportunity 15 minutes to downtown St. Petersburg. Skip the time of planning the construction, this project is fully permitted, documented, and r
Details for 2612 Ravencliffe Terrace, OVIEDO, FL 32765
Single Family
  1. Price: $1,375,000.00
  2. Price sqft: $194.24 / sqft
  3. Days On Market: 16
  4. Bedrooms: 6
  5. Baths: 6
  6. Garage / Parking Spaces: 3
  7. Bldg sqft: 7079
  8. Acreage: 0.21 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2025
MLS#: O6393958
  1. County: SEMINOLE
  2. City: OVIEDO
  3. Zipcode: 32765
  4. Subdivision: Hawks Overlook
  5. Elementary School: Evans Elementary
  6. Middle School: Jackson Heights Middle
  7. High School: Hagerty High
  8. Provided by: PALMANO GROUP RE BROKERAGE LLC
  9. mfrmls
  10. DMCA Notice
Description
  1. Welcome to Ravencliffe, a private gated enclave in the heart of Oviedo. Located off Alafaya Trail and Lake Hayes Road, this intimate 20 acre community offers a refined, boutique lifestyle with timeles
Details for 3800 Shore Acres Boulevard Ne, ST PETERSBURG, FL 33703
Single Family
  1. Price: $1,250,000.00
  2. Price sqft: $487.14 / sqft
  3. Previous Price: $1,300,000
  4. Last Price Change: 01/12/26
  5. Days On Market: 333
  6. Bedrooms: 3
  7. Baths: 3
  8. Garage / Parking Spaces: 1
  9. Bldg sqft: 2566
  10. Acreage: 0.17 acres
  11. Pool: No
  12. Waterfront: Yes
  13. Wateraccess: Yes
  14. Waterfront Type: Bayou,Canal - Saltwater
  15. Year Built: 1962
MLS#: TB8387721
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33703
  4. Subdivision: Shore Acres Overlook Sec
  5. Provided by: REAL ESTATE WITH AN ACCENT LLC
  6. mfrmls
  7. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. Discover the rare opportunity to own a waterfront property framed by multimillion dollar estates. Its generous 51 150 ft lot offers spectacular sunrise
Details for 984 Hawksnest Point, OVIEDO, FL 32765
Single Family
  1. Price: $1,099,990.00
  2. Price sqft: $269.87 / sqft
  3. Days On Market: 129
  4. Bedrooms: 5
  5. Baths: 5
  6. Garage / Parking Spaces: 3
  7. Bldg sqft: 4076
  8. Acreage: 0.30 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2025
MLS#: O6366370
  1. County: SEMINOLE
  2. City: OVIEDO
  3. Zipcode: 32765
  4. Subdivision: Hawks Overlook
  5. Elementary School: Evans Elementary
  6. Middle School: Jackson Heights Middle
  7. High School: Hagerty High
  8. Provided by: KELLER WILLIAMS ADVANTAGE REALTY
  9. mfrmls
  10. DMCA Notice
Description
  1. Under Construction. Discover this stunning new construction home at 984 Hawksnest Pt Oviedo, built by M/I Homes. This impressive 4,076 square foot home offers exceptional design quality and thoughtful
Details for 2564 Hawks Overlook Place, OVIEDO, FL 32765
Single Family
  1. Price: $979,990.00
  2. Price sqft: $199.31 / sqft
  3. Days On Market: 3
  4. Bedrooms: 5
  5. Baths: 5
  6. Garage / Parking Spaces: 3
  7. Bldg sqft: 4917
  8. Acreage: 0.30 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2024
MLS#: O6399612
  1. County: SEMINOLE
  2. City: OVIEDO
  3. Zipcode: 32765
  4. Subdivision: Hawks Overlook
  5. Elementary School: Evans Elementary
  6. Middle School: Jackson Heights Middle
  7. High School: Hagerty High
  8. Provided by: KELLER WILLIAMS ADVANTAGE REALTY
  9. mfrmls
  10. DMCA Notice
Description
  1. Welcome to this stunning new construction home by M/I Homes, nestled at 2564 Hawks Overlook Place in the charming Oviedo, FL. This 5 bedroom, 4 bathroom home offers a spacious and modern setting for y
Details for 4223 Henderson Boulevard, TAMPA, FL 33629
Commercial
  1. Price: $975,000.00
  2. Price sqft: $492.42 / sqft
  3. Days On Market: 326
  4. Bldg sqft: 1980
  5. Acreage: 0.14 acres
  6. Pool: No
  7. Waterfront: No
  8. Year Built: 1958
MLS#: TB8390242
  1. County: HILLSBOROUGH
  2. City: TAMPA
  3. Zipcode: 33629
  4. Subdivision: Overlook Add
  5. Provided by: SMITH & ASSOCIATES REAL ESTATE
  6. mfrmls
  7. DMCA Notice
Description
  1. South Tampa Corner location Retail/office site with concrete building 1 roll up door Signage on building Lighted intersection Building needs work Owner occupied and will relocate post cl
Hardeep Kumar Yh