( ! ) 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.0001440712{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.0001440712{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.0001440712{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.0001440712{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.0001440712{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.0001440712{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.0001440712{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.0001440712{main}( ).../index.php:0
20.0023442392require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11
30.0164688104include_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.0001440712{main}( ).../index.php:0
20.0023442392require( '/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.0001440712{main}( ).../index.php:0
20.0023442392require( '/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.0001440712{main}( ).../index.php:0
20.0023442392require( '/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.0001440712{main}( ).../index.php:0
20.0023442392require( '/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.0001440712{main}( ).../index.php:0
20.0023442392require( '/home/bpweb/Agentsites/includes/function.php ).../index.php:11
 Search Results
Call Now:

Hardeep Kumar Yh

HR Moon Homes
We are the World
  1. Home
  2. Search Listings
  3. Search Results
Searching on:
  1. School = Frontier
  2. Listing Status = Active
Whitney Road
Virtual Tour
More Like This
Active
Details for Whitney Road, CLEARWATER, FL 33760
Land
  1. Price: $2,772,000.00
  2. Previous Price: $3,080,000
  3. Last Price Change: 03/31/26
  4. Days On Market: 208
  5. Acreage: 2.00 acres
  6. Pool: No
  7. Waterfront: No
  8. Year Built: Not Available
MLS#: TB8430692
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33760
  4. Subdivision: Whitney Townhomes Lot 14 1740
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: SCHERER DEVELOPMENT LLC
  9. mfrmls
  10. DMCA Notice
Description
  1. New Subdivision for Sale! 28 Fully Developed & Platted Townhome Lots: Priced to sell at $99,000/finished lot. All infrastructure completed, including roads, curbs, perimeter landscaping, access gates,
Listing Details and 12 Additional Pictures
Request more information about this listing.
2402 Pine Hammock
Virtual Tour
Green Listing
More Like This
Active
Details for 2402 Pine Hammock, CLEARWATER, FL 33764
Single Family
  1. Price: $2,200,000.00
  2. Price sqft: $307.61 / sqft
  3. Days On Market: 94
  4. Bedrooms: 6
  5. Baths: 5
  6. Garage / Parking Spaces: 2
  7. Bldg sqft: 7152
  8. Acreage: 1.80 acres
  9. Pool: Yes
  10. Waterfront: Yes
  11. Wateraccess: Yes
  12. Waterfront Type: Lake Front
  13. Year Built: 1980
MLS#: TB8463686
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33764
  4. Subdivision: Pinellas Groves
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Largo High PN
  8. Provided by: COLDWELL BANKER REALTY
  9. mfrmls
  10. DMCA Notice
Description
  1. Nestled on a picturesque lake in the heart of Pinellas County, this exceptional home in desirable Kent Place offers the perfect blend of privacy, resilience, and refined Florida living. Thoughtfully d
Listing Details and 82 Additional Pictures
Request more information about this listing.
16288 48th Street N
Virtual Tour
New Construction
More Like This
Active
Details for 16288 48th Street N, CLEARWATER, FL 33762
Single Family
  1. Price: $775,000.00
  2. Price sqft: $162.00 / sqft
  3. Days On Market: 104
  4. Bedrooms: 3
  5. Baths: 3
  6. Garage / Parking Spaces: 3
  7. Bldg sqft: 4784
  8. Acreage: 0.25 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2025
MLS#: TB8460930
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33762
  4. Subdivision: Pinellas Groves
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: MARK SPAIN REAL ESTATE
  9. mfrmls
  10. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. Brand new 2025 custom built stilt home never lived in! Appraised at $965,000, this modern 3 bed, 2.5 bath residence showcases designer finishes and tho
Listing Details and 36 Additional Pictures
Request more information about this listing.
7337 Cambridge Way
Virtual Tour
Reduced
More Like This
Active
Details for 7337 Cambridge Way, CLEARWATER, FL 33764
Single Family
  1. Price: $449,999.00
  2. Price sqft: $221.89 / sqft
  3. Days On Market: 93
  4. Bedrooms: 3
  5. Baths: 2
  6. Garage / Parking Spaces: 2
  7. Bldg sqft: 2028
  8. Acreage: 0.35 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 1981
MLS#: TB8465231
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33764
  4. Subdivision: Newport
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Fitzgerald Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: SMITH & ASSOCIATES REAL ESTATE
  9. mfrmls
  10. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. Welcome to this beautifully maintained 3 bedroom, 2 bathroom home offering 1,318 square feet of comfortable living space, located in the desirable Newpo
Listing Details and 27 Additional Pictures
Request more information about this listing.
3061 Overlook Place
Virtual Tour
More Like This
Active
Details for 3061 Overlook Place, CLEARWATER, FL 33760
Townhome
  1. Price: $424,900.00
  2. Price sqft: $220.38 / sqft
  3. Previous Price: $439,000
  4. Last Price Change: 03/03/26
  5. Days On Market: 96
  6. Bedrooms: 4
  7. Baths: 3
  8. Garage / Parking Spaces: 2
  9. Bldg sqft: 1928
  10. Acreage: 0.12 acres
  11. Pool: No
  12. Community Pool: Yes
  13. Waterfront: No
  14. Year Built: 1993
MLS#: W7882006
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33760
  4. Subdivision: Overlook
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: RE/MAX CHAMPIONS
  9. mfrmls
  10. DMCA Notice
Description
  1. NEW PRICE END UNIT TWO STORY MAINTENANCE FREE TOWNHOME Located in the popular Clearwater community of Overlook you will love this Florida lifestyle. This two story move in ready townhome featu
Listing Details and 63 Additional Pictures
Request more information about this listing.
4068 Alan Drive
Virtual Tour
Reduced
More Like This
Active
Details for 4068 Alan Drive, LARGO, FL 33771
Townhome
  1. Price: $399,000.00
  2. Price sqft: $198.90 / sqft
  3. Days On Market: 60
  4. Bedrooms: 3
  5. Baths: 3
  6. Garage / Parking Spaces: 2
  7. Bldg sqft: 2006
  8. Acreage: 0.06 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2006
MLS#: TB8476772
  1. County: PINELLAS
  2. City: LARGO
  3. Zipcode: 33771
  4. Subdivision: Meadows At Largo
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Fitzgerald Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: LPT REALTY, LLC
  9. mfrmls
  10. DMCA Notice
Description
  1. Welcome to 4068 Allen Dr. in Largo, Florida a beautifully updated end unit townhome offering space, privacy, and convenience in the heart of Pinellas County. From the moment you arrive, youll appr
Listing Details and 39 Additional Pictures
Request more information about this listing.
14985 Alan Court
Virtual Tour
More Like This
Active
Details for 14985 Alan Court, LARGO, FL 33771
Townhome
  1. Price: $375,000.00
  2. Price sqft: $186.75 / sqft
  3. Days On Market: 2
  4. Bedrooms: 3
  5. Baths: 3
  6. Garage / Parking Spaces: 2
  7. Bldg sqft: 2008
  8. Acreage: 0.05 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2007
MLS#: TB8499103
  1. County: PINELLAS
  2. City: LARGO
  3. Zipcode: 33771
  4. Subdivision: Meadows At Largo
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Fitzgerald Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: CHARLES RUTENBERG REALTY INC
  9. mfrmls
  10. DMCA Notice
Description
  1. Enjoy a maintenance free lifestyle at Meadows of Largo. This townhome is nestled in a premium back lot of this pet friendly community. This home boasts the largest floor plan available (over 2,000 sq
Listing Details and 20 Additional Pictures
Request more information about this listing.
2055 Arbor Drive
Virtual Tour
Green Listing
Reduced
More Like This
Active
Details for 2055 Arbor Drive, CLEARWATER, FL 33760
Townhome
  1. Price: $349,900.00
  2. Price sqft: $178.89 / sqft
  3. Previous Price: $364,500
  4. Last Price Change: 04/16/26
  5. Days On Market: 29
  6. Bedrooms: 3
  7. Baths: 3
  8. Garage / Parking Spaces: 2
  9. Bldg sqft: 1956
  10. Acreage: 0.05 acres
  11. Pool: No
  12. Community Pool: Yes
  13. Waterfront: Yes
  14. Wateraccess: Yes
  15. Waterfront Type: Creek
  16. Year Built: 1986
MLS#: TB8488874
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33760
  4. Subdivision: Arbor Trace
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: BLAKE REAL ESTATE INC
  9. mfrmls
  10. DMCA Notice
Description
  1. Welcome to your own private retreat nestled among the treeswhere nature, tranquility, and peace of mind come together in one exceptional townhome. This beautifully maintained, elevated residence offer
Listing Details and 34 Additional Pictures
Request more information about this listing.
1963 Georgia Circle N
Virtual Tour
More Like This
Active
Details for 1963 Georgia Circle N, CLEARWATER, FL 33760
Townhome
  1. Price: $349,000.00
  2. Price sqft: $238.39 / sqft
  3. Days On Market: 17
  4. Bedrooms: 3
  5. Baths: 3
  6. Garage / Parking Spaces: 1
  7. Bldg sqft: 1464
  8. Acreage: 0.06 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 1990
MLS#: TB8492753
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33760
  4. Subdivision: Middlecreek
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: STOFEL & ASSOCIATES REALTY
  9. mfrmls
  10. DMCA Notice
Description
  1. Welcome to 1963 Georgia Circle, a move in ready 3 bedroom 2.5 bathroom 2 story townhome. This charming property offers a blend of comfort, style, and convenience, making it an ideal home for anyone lo
Listing Details and 30 Additional Pictures
Request more information about this listing.
5152 Bay Isle Circle
Virtual Tour
More Like This
Active
Details for 5152 Bay Isle Circle, CLEARWATER, FL 33760
Townhome
  1. Price: $325,000.00
  2. Price sqft: $154.76 / sqft
  3. Previous Price: $332,500
  4. Last Price Change: 03/27/26
  5. Days On Market: 451
  6. Bedrooms: 2
  7. Baths: 3
  8. Garage / Parking Spaces: 2
  9. Bldg sqft: 2100
  10. Acreage: 0.03 acres
  11. Pool: No
  12. Waterfront: No
  13. Year Built: 2015
MLS#: TB8342430
  1. County: PINELLAS
  2. City: CLEARWATER
  3. Zipcode: 33760
  4. Subdivision: Bay Isle Landings
  5. Elementary School: Frontier Elementary PN
  6. Middle School: Oak Grove Middle PN
  7. High School: Pinellas Park High PN
  8. Provided by: RE/MAX REALTY UNLIMITED
  9. mfrmls
  10. DMCA Notice
Description
  1. Now Available in desirable Bay Isle Landings, this well maintained townhome delivers exceptional value just minutes from Downtown St Petersburg. Located in a gated community that remained unaffected b
Listing Details and 30 Additional Pictures
Request more information about this listing.
Hardeep Kumar Yh

Looking To Sell Your Property ?

Connecting agents, buyers, and sellers
Call Us Now 3333333333 Get In Touch
Featured Listings
22645 105th Avenue Road
1321 42nd Street
5247 18th Street
7086 12th Circle
2301 66th Street
10300 98th Terrace
12472 85th Place
18001 Hawthorne Road

Copyright ©2006-2026 brokerIDXsites.com   |   All Rights Reserved.