Your AI Navigator in Commercial Real Estate
Sign Up Successful!
You now have access to more from Realmo!
Property Lookup
    Property Lookup
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    AI Search
    Back to Search
    Property profile & analytics

    597 Saint Andrews Rd Columbia, SC 29210-4516

    • Drive through restaurants
    • 2,601 SF
    • 0.28 lot acres
    OFF-MARKET
    Value Estimation
    $250,000
    Last Sale
    Aug 10, 2023
    $225,000
    Location Intelligence
    Property ID
    US77-0619317
    The Realmo ID is a unique identifier assigned to every property, incorporating country codes and precise geo-coordinates for 300x300-foot land blocks. It enables standardized data collection and seamless integration of disparate sources such as ownership, tax, title data and physical specifications. By aggregating current and historical records, the Realmo ID powers advanced analytics and delivers deep, verifiable insights for real estate professionals.

    Current Use by Public Records

    • Drive through restaurants

    Property Details for 597 Saint Andrews Rd

    Year built
    1985
    Lot size
    0.28 lot acres
    Property size
    2,601 SF
    Zone code
    ID
    Property type
    Drive through restaurants
    APN
    002899-04-022
    APU
    289904022

    Value Estimation

    Powered by Realmo proprietary methodology Last update: July 3, 2025

    • CAP approach

    • Comparable approach

    • Alternative Use

    Location Insight

    • Map
    • Local Demand
    City
    Columbia
    County
    Lexington
    State
    South Carolina
    Longitude
    -81.1258
    Latitude
    34.0454
    CBSA code
    17900
    CBSA name
    COLUMBIA, SC METROPOLITAN STATISTICAL AREA

    Property Tax & Assessments

    Tax date
    Tax Amount
    Assessed Land Value
    Assessed Improvement Value
    Total Assessed Value
    Applied Tax Rate
    Land Market Value
    Improvement Market Value
    Total Market Value
    2023
    $5,736
    $4,326
    $8,913
    $13,239
    -
    $72,100
    $148,548
    $220,648

    Comparable in this City

    • Value Estimation
      $2,315,000
      2,513 SF

      475 Piney Grv Rd

      DRIVE-THRU RESTAURANT, FAST FOOD • 2,513 SF
      475 Piney Grv Rd, Columbia, SC 29210-3837
      View Details
    • Value Estimation by Request
      4,250 SF

      600 Saint Andrews Rd

      DRIVE-THRU RESTAURANT, FAST FOOD • 4,250 SF
      600 Saint Andrews Rd, Columbia, SC 29210-5113
      View Details
    • Value Estimation by Request
      3,737 SF

      2216 Bush Riv Rd

      DRIVE-THRU RESTAURANT, FAST FOOD • 3,737 SF
      2216 Bush Riv Rd, Columbia, SC 29210-5627
      View Details
    • Value Estimation by Request
      1,620 SF

      1805 Bush Riv Rd

      DRIVE-THRU RESTAURANT, FAST FOOD • 1,620 SF
      1805 Bush Riv Rd, Columbia, SC 29210-6813
      View Details
    • Value Estimation by Request
      3,186 SF

      650 Saint Andrews Rd

      DRIVE-THRU RESTAURANT, FAST FOOD • 3,186 SF
      650 Saint Andrews Rd, Columbia, SC 29210-5134
      View Details
    • Value Estimation
      $270,000
      1,980 SF

      617 Saint Andrews Rd

      DRIVE-THRU RESTAURANT, FAST FOOD • 1,980 SF
      617 Saint Andrews Rd, Columbia, SC 29210-5112
      View Details

    Similar Nearby for Sale

    • Contact for pricing
      2,329 SF

      Restaurant with Drive-Thru Available

      2,329 SF restaurant with drive-thru at signalized intersection.
      529 Bush River Rd, Columbia, SC 29210
      View Details
    • $795,000
      3,068 SF

      Freestanding Restaurant Building For Sale

      Freestanding restaurant building with drive-thru, conveniently located near I-20.
      1939 Broad River Rd, Columbia, SC 29210
      View Details
    • $1,400,000
      5,000 SF

      Columbia Adult Club - High ROI

      Profitable urban club, prime location.
      2219 Broad River Rd, Columbia, SC 29210
      View Details
    • $1,200,000
      6,750 SF

      Columbia Mixed-Use Investment

      High-Cap Rate Restaurant Property
      1704 Bush River Rd, Columbia, SC 29210
      View Details
    • $2,850,345
      4,236 SF

      Bojangles QSR Investment Opportunity

      Columbia, SC Bojangles NNN Lease
      2423 Broad River Rd, Columbia, SC 29210
      View Details
    • $350,000
      3,000 SF

      Columbia Retail Building - $350K

      Prime location, high traffic, vacant 3,000 SF retail space.
      1421 Broad River Rd, Columbia, SC 29210
      View Details

    Similar Nearby for Lease

    • $16 SF/Yr
      2,204 SF

      Freestanding Restaurant with Drive-Thru

      2,204 SF restaurant with commercial kitchen and drive-thru.
      656 Bush River Rd, Columbia, SC 29210
      View Details
    • $11 SF/Yr
      43,520 SF

      Bush River Village Retail Center

      Columbia, SC retail space available.
      1316-1324 Bush River Rd, Columbia, SC 29210
      View Details
    • $3,500 /Mo
      1,586 SF

      Restaurant Space with Pylon Sign

      Restaurant space with high traffic, near I-20 and I-26.
      4505 Broad River Rd, Columbia, SC 29210
      View Details
    • $11 SF/Yr
      1,242 SF

      Retail Space Available For Lease

      Retail space available for lease in Columbia, South Carolina.
      1441 Colonial Life Blvd W, Columbia, SC 29210
      View Details
    • $2,000 /Mo
      1,600 SF

      Office/Retail Space Near Riverbanks Zoo

      1,600 SF office/retail space with frontage on Interstate 126.
      208 Candi Ln, Columbia, SC 29210
      View Details
    • $12 SF/Yr
      4,315 SF

      Retail Space Near Harbison Corridor

      4,315 SF retail space near I-20 and Harbison.
      125 Outlet Pointe Blvd, Columbia, SC 29210
      View Details
    Request Owner's contact information
    Message sent successfully
    Error
    If you are the owner or broker of this property and would like to edit or remove this listing please send a message to web site administrator.
    597 Saint Andrews Rd
    Columbia, SC 29210-4516
    Message sent successfully
    Error
    Email to Your Friends
    Link copied to clipboard
    Separate multiple addresses with a comma
    Message sent successfully
    Error

    Realmo Value Estimation

    Realmo estimates a property’s market value using a proprietary methodology that incorporates public data and user-submitted information. This cumulative value is generated by integrating a variety of conventional and innovative methods. 

    Disclaimer

    These figures are not official appraisals and should not be used as a substitute for a valuation performed by a licensed appraiser.

    Actual market value may differ due to factors not captured in the data. Estimates are offered for informational purposes only, and users should conduct independent research before making financial or investment decisions.

    By using this feature, you acknowledge that Realmo is not responsible for actions taken based on these estimates.

    AI approach

    Realmo AI Method estimates property value using machine learning models trained on millions of comparable listings, transactions, and market signals. It analyzes property features, location intelligence data, and current market dynamics to predict the most probable market value in real time.

    Cap approach

    Capitalization Method calculates value based on estimated net operating income (NOI) and applying a market-based capitalization rate (cap rate), we estimate what a typical investor might be willing to pay for it.

    Comparable approach

    Comparable estimate is based on recent sales of similar nearby properties, adjusted for factors like size, condition, and location.

    Relative

    Relative property class coefficient uses factors that account for typical price differences between various asset types (e.g., retail vs. industrial) to provide a more accurate market-aligned estimate.

    Geo

    Comparable Sales Method, enhanced by Geo coefficients — location-based adjustment factors that reflect differences in price levels across neighborhoods, cities, or regions ensuring a more accurate, market-sensitive valuation.

    Alternative use

    Estimate considers the property’s potential value if used for a different purpose-based on zoning, demand, and market feasibility.

    More about this property
    Thanks! Your message was sent.
    Error! Your message wasn't sent.
    Please enter your name
    Please enter email
    Please enter the email in the correct format
    Please enter phone
    Please enter the number in the correct format
    Please enter message
    Google sign-in failed. Please try again or use another login method.
    Create New Password
    • At least 8 characters
    • Contains both letters and numbers
    • Contains uppercase and lowercase letters
    • At most 32 characters
    • Password required
    • Password reset link has expired. Please request a new one.