( ! ) 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.0174688120include_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
  1. Home
  2. Search Listings
  3. Search Results
Searching on:
  1. Subdivision Like Columbia
  2. Listing Status = Active
504 Gulfview Boulevard
Virtual Tour
More Like This
Active
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: 03/11/26
  5. Days On Market: 782
  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.
Listing Details and 18 Additional Pictures
Request more information about this listing.
Tbd Unassigned
More Like This
Active
Details for Tbd Unassigned, LAKE CITY, FL 32024
Land
  1. Price: $2,200,000.00
  2. Days On Market: 33
  3. Acreage: 8.00 acres
  4. Pool: No
  5. Waterfront: No
  6. Year Built: Not Available
MLS#: TB8487231
  1. County: COLUMBIA
  2. City: LAKE CITY
  3. Zipcode: 32024
  4. Subdivision: Columbia
  5. Elementary School: Columbia City Elementary Schoo
  6. High School: Fort White High School CO
  7. Provided by: BAYSIDE REALTY GROUP INC
  8. mfrmls
  9. DMCA Notice
Description
  1. 8 Acres of opportunity waiting on all New Home Builders, Farmers, and Investors with a vision for this growing community. Zoned A 1 (Agriculture), this property offers incredible flexibility for a va
Listing Details and 1 Additional Pictures
Request more information about this listing.
5110 County Road 240
Virtual Tour
More Like This
Active
Details for 5110 County Road 240, LAKE CITY, FL 32024
Single Family
  1. Price: $1,450,000.00
  2. Price sqft: $202.57 / sqft
  3. Days On Market: 26
  4. Bedrooms: 5
  5. Baths: 6
  6. Garage / Parking Spaces: 4
  7. Bldg sqft: 7158
  8. Acreage: 4.01 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2012
MLS#: GC538703
  1. County: COLUMBIA
  2. City: LAKE CITY
  3. Zipcode: 32024
  4. Subdivision: Columbia Meadows
  5. Provided by: COLDWELL BANKER M.M. PARRISH REALTORS
  6. mfrmls
  7. DMCA Notice
Description
  1. One of a Kind custom brick Luxury Estate situated on four private acres. The circular drive with fountain brings you to the double eight foot imported Italian entry doors inviting you into a spacious
Listing Details and 37 Additional Pictures
Request more information about this listing.
2807 Locicero Drive
Virtual Tour
More Like This
Active
Details for 2807 Locicero Drive, TAMPA, FL 33619
Commercial
  1. Price: $575,000.00
  2. Price sqft: $376.31 / sqft
  3. Days On Market: 44
  4. Bldg sqft: 1528
  5. Acreage: 0.55 acres
  6. Pool: No
  7. Waterfront: No
  8. Year Built: 1925
MLS#: TB8482196
  1. County: HILLSBOROUGH
  2. City: TAMPA
  3. Zipcode: 33619
  4. Subdivision: Locicero Columbia Park
  5. Provided by: IMPACT REALTY TAMPA BAY
  6. mfrmls
  7. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. Positioned in the heart of Tampa Bays rapidly expanding commercial corridor, 2807 Locicero Drive offers a rare opportunity to acquire a high visibility
Listing Details and 25 Additional Pictures
Request more information about this listing.
1438 10th Avenue S
Virtual Tour
More Like This
Active
Details for 1438 10th Avenue S, ST PETERSBURG, FL 33705
Single Family
  1. Price: $367,000.00
  2. Price sqft: $244.67 / sqft
  3. Previous Price: $369,000
  4. Last Price Change: 11/26/25
  5. Days On Market: 233
  6. Bedrooms: 3
  7. Baths: 2
  8. Garage / Parking Spaces: 1
  9. Bldg sqft: 1500
  10. Acreage: 0.13 acres
  11. Pool: No
  12. Waterfront: No
  13. Year Built: 1925
MLS#: TB8422199
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33705
  4. Subdivision: Columbia Heights 2
  5. Provided by: SIGNATURE REALTY ASSOCIATES
  6. mfrmls
  7. DMCA Notice
Description
  1. One or more photo(s) has been virtually staged. This delightful two story bungalow style home offers everything you could need. This fully renovated home features three bedrooms, two bathrooms, an off
Listing Details and 39 Additional Pictures
Request more information about this listing.
1240 James Avenue S
More Like This
Active
Details for 1240 James Avenue S, ST PETERSBURG, FL 33705
Single Family
  1. Price: $299,950.00
  2. Price sqft: $243.47 / sqft
  3. Previous Price: $289,950
  4. Last Price Change: 03/04/26
  5. Days On Market: 253
  6. Bedrooms: 2
  7. Baths: 1
  8. Bldg sqft: 1232
  9. Acreage: 0.06 acres
  10. Pool: No
  11. Waterfront: No
  12. Year Built: 1927
MLS#: TB8414281
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33705
  4. Subdivision: Columbia Heights
  5. Provided by: DALTON WADE INC
  6. mfrmls
  7. DMCA Notice
Description
  1. Be the proud owner of this charming, historic, century old home with character for modern living from a complete renovation with permits, while keeping the old charm. This house is packed with a compl
Listing Details and 25 Additional Pictures
Request more information about this listing.
4725 Cove Circle 604
Virtual Tour
Adult Community
More Like This
Active
Details for 4725 Cove Circle 604, ST PETERSBURG, FL 33708
Condominium
  1. Price: $239,999.00
  2. Price sqft: $294.48 / sqft
  3. Previous Price: $242,900
  4. Last Price Change: 04/10/26
  5. Days On Market: 178
  6. Bedrooms: 1
  7. Baths: 1
  8. Bldg sqft: 815
  9. Acreage: 0.00 acres
  10. Pool: No
  11. Waterfront: Yes
  12. Wateraccess: Yes
  13. Waterfront Type: Intracoastal Waterway,Lagoon
  14. Year Built: 1970
MLS#: TB8440398
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33708
  4. Subdivision: Columbia Towers Condo
  5. Building: Columbia Towers Condo
  6. Provided by: FUTURE HOME REALTY INC
  7. mfrmls
  8. DMCA Notice
Description
  1. Wake up to beautiful waterfront views from this sixth floor condo in the highly sought after Sea Towers gated community! This 1 bedroom, 1 bath residence offers elevated views of Boca Ciega Bay and th
Listing Details and 52 Additional Pictures
Request more information about this listing.
1311 11th Avenue S
Virtual Tour
Reduced
More Like This
Active
Details for 1311 11th Avenue S, ST PETERSBURG, FL 33705
Single Family
  1. Price: $237,000.00
  2. Price sqft: $230.10 / sqft
  3. Previous Price: $247,000
  4. Last Price Change: 04/16/26
  5. Days On Market: 68
  6. Bedrooms: 3
  7. Baths: 1
  8. Bldg sqft: 1030
  9. Acreage: 0.06 acres
  10. Pool: No
  11. Waterfront: No
  12. Year Built: 1925
MLS#: O6381499
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33705
  4. Subdivision: Columbia Heights
  5. Provided by: CREATIVE R.E. & PROJECTS, LLC
  6. mfrmls
  7. DMCA Notice
Description
  1. SELLER WILLING TO CONTRIBUTE $14,000 TO BUYER TOWARDS CLOSING COSTS and/or to install a washer and dryer, landscape or any other improvements that the Buyer would like to do (Contribution applies only
Listing Details and 35 Additional Pictures
Request more information about this listing.
510 15th Avenue
Virtual Tour
New Construction
More Like This
Active
Details for 510 15th Avenue, OCALA, FL 34471
Single Family
  1. Price: $230,000.00
  2. Price sqft: $152.12 / sqft
  3. Days On Market: 33
  4. Bedrooms: 3
  5. Baths: 2
  6. Garage / Parking Spaces: 1
  7. Bldg sqft: 1512
  8. Acreage: 0.16 acres
  9. Pool: No
  10. Waterfront: No
  11. Year Built: 2026
MLS#: O6379521
  1. County: MARION
  2. City: OCALA
  3. Zipcode: 34471
  4. Subdivision: Columbia City
  5. Elementary School: Dr. N.H. Jones Elem. (Mag)
  6. Middle School: Osceola Middle School
  7. High School: Forest High School
  8. Provided by: OLYMPUS EXECUTIVE REALTY INC
  9. mfrmls
  10. DMCA Notice
Description
  1. Photos may include virtual staging. Homes may feature design variations and multiple interior finish and exterior landscaping packages to select from. We offer both completed homes and homes to be bui
Listing Details and 24 Additional Pictures
Request more information about this listing.
4725 Cove Circle 207
Virtual Tour
Adult Community
More Like This
Active
Details for 4725 Cove Circle 207, ST PETERSBURG, FL 33708
Condominium
  1. Price: $229,000.00
  2. Price sqft: $220.19 / sqft
  3. Previous Price: $129,000
  4. Last Price Change: 03/20/26
  5. Days On Market: 30
  6. Bedrooms: 2
  7. Baths: 2
  8. Bldg sqft: 1040
  9. Acreage: 0.00 acres
  10. Pool: No
  11. Waterfront: No
  12. Year Built: 1970
MLS#: TB8488203
  1. County: PINELLAS
  2. City: ST PETERSBURG
  3. Zipcode: 33708
  4. Subdivision: Columbia Towers
  5. Building: Columbia Towers
  6. Provided by: AVALON GROUP REALTY
  7. mfrmls
  8. DMCA Notice
Description
  1. Waterfront views and move in ready condition come together in this updated 2BR/2BA condo located in a desirable 55+ community. Situated on the second floor, this unit offers a comfortable layout with
Listing Details and 45 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
4506 Georgia Avenue
2301 66th Street
2811 14th Street
12472 85th Place
274 34th Place
22649, 22645 And Tbd 105th Avenue Road
3004 Mahalo Drive
22649 105th Avenue Road

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