Coding an app to retrieve a stored map based on geolocation

What database brand do you have?

You said:

• Use those coordinates to query my database —I also need a way for my search to get "near" my stored values, as my user's and my database's values will not match. 

I would do the following instead:

Use those coordinates - from the user - as input coordinates in a dynamic query. In the query's SQL, you calculate the minimum distance between the user's coordinates and those of each of the locations in the database table.

I asked what your database brand is because some have geographical functions you could use. See, for example, https://stackoverflow.com/questions/13026675/calculating-distance-between-two-points-latitude-longitude

Alternatively, you could do all the calculations in ColdFusion rather than in the database. This method is likely to be inefficient. I am giving it just for completeness.

Here, your query would return the coordinates of the property locations. You could then loop through, calculating distances by means of formulas you can find on the web. For example, https://www.geeksforgeeks.org/program-distance-two-points-earth/

Here's the calculation expressed as a coldfusion function:

<cfscript>
	distance=calculateDistanceOnEarth(53.32055555555556,-1.7297222222222221,53.31861111111111,-1.6997222222222223);
    writeoutput(distance);
    
	public numeric function calculateDistanceOnEarth(numeric lt1, numeric lg1, numeric lt2, numeric lg2) 
    { 
  
        // The math module contains a function 
        // named toRadians which converts from 
        // degrees to radians. 
        var lat1 = toRadians(arguments.lt1); 
        var lon1 = toRadians(arguments.lg1); 
        var lat2 = toRadians(arguments.lt2); 
        var lon2 = toRadians(arguments.lg2); 
  
        // Haversine formula  
        var deltaLong = lon2 - lon1;  
        var deltaLat = lat2 - lat1; 
        var a = sin(deltaLat / 2)^2 
                 + cos(lat1) * cos(lat2) 
                 * sin(deltaLong / 2)^2; 
              
        var c = 2 * asin(sqr(a)); 
  
        // Radius of earth in kilometers. Use 3956  
        // for miles 
        var r = 6371; 
  
        // calculate the resulting distance in kilometers 
        return(c * r); 
    }  
  
    public numeric function toRadians(numeric deg) {
    	return arguments.deg*pi()/180;
    }
    
</cfscript>