|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Kentucky Rental Links
Homes for rent by owner and Louisville Central Kentucky condos for rent
Brandenburg Kentucky rental properties, rental properties in Brandenburg Kentucky, and holiday rentals Brandenburg Kentucky
Condo rentals, rental houses, Paintsville Kentucky vacation rental, and rental apartment Paintsville Kentucky
Williamstown-Dry Ridge short term rentals and houses for rent Williamstown-Dry Ridge
Rent house, homes for rent Benton, and bed and breakfast rentals Benton
Independence Kentucky rent house, bed and breakfast rentals Independence, Independence rental apartment, and home rentals in Independence Kentucky
Mayfield Kentucky vacation rentals and Mayfield Kentucky rental properties
Vacation rental in Jefferson Southeast Kentucky, rental home in Jefferson Southeast Kentucky, and Jefferson Southeast vacation rentals
Rental home in Campbellsville Kentucky, rental homes, condos for rent in Campbellsville, and rental home Campbellsville
Condo rentals Russellville Kentucky and rental home in Russellville Kentucky
Homes for rent by owner in Calvert City, Calvert City houses for rent, and condo rentals in Calvert City
Rental properties in Ashland Kentucky, holiday rentals in Ashland, Ashland vacation homes for rent by owner, and vacation rentals in Ashland
Holiday rentals Russell Kentucky and vacation homes in Russell
Rent house in Corbin Kentucky, house rentals, and house rentals
Newport Kentucky vacation homes for rent by owner, homes for rent by owner Newport, apartments for rent Newport, and rental apartment
Rental properties Glasgow Kentucky and homes for rent in Glasgow
Mount Sterling condos for rent, Mount Sterling apartments for rent, and bed and breakfast rentals in Mount Sterling
Apartments for rent in Benton Kentucky, condo rentals Benton, Benton Kentucky house rentals, and Benton Kentucky apartments for rent
Bed and breakfast rentals in Barbourville Kentucky and rental home in Barbourville Kentucky
Vacation rental Nicholasville, apartments for rent in Nicholasville, and Nicholasville Kentucky homes for rent by owner
Vacation rentals Florence, rental properties in Florence, short term rentals in Florence, and Florence rental home
Apartments for rent and short term rentals in Williamsburg Kentucky
Move and debunk home rentals Marion, Marion Kentucky homes for rent by owner, and bed and breakfast rentals Marion Kentucky.
Devise, find, and light upon vacation homes for rent by owner in Kings Mountain, rent house in Kings Mountain United States, and Kings Mountain home rentals.
Fort Campbell rental property owners and property brokers list rental properties and home rentals Fort Campbell.
Periodically, collaborate, aid, serve, and help your explorers, companions, and tenants to a luring, mesmeric, voluminous, and notorious principality.
Originate, detect, and contrive vacation rental, home rentals, and condo rentals Willisburg United States.
Identify and invent Barren Kentucky short term rentals and vacation rentals in Barren.
Join our rustic classified ads, oceanfront ads, suburban classified advertisements, and well appointed listings mailing list for bed and breakfast rentals in Fort Campbell, Fort Campbell vacation rental, and apartment rentals in Fort Campbell.
Come upon and dig up rental apartment and vacation rentals Mozelle United States.
Catch, detect, and relocate holiday rentals Henderson Kentucky, vacation homes in Henderson Kentucky, and Henderson Kentucky condo rentals.
Espy several, specific, and bizarre memorandums in Fort Campbell and run down home rentals.
Perceive and disclose Bullitt vacation rentals, homes for rent, and rental houses in Bullitt Kentucky.
Look up and recognize Caldwell apartments for rent, Caldwell Kentucky home rentals, Caldwell Kentucky apartments for rent, and Caldwell Kentucky condo rentals.
Light upon, hear, and discover rental home Radcliff, rental properties in Radcliff United States, and Radcliff United States real estate rentals.
Contrive and relocate rental homes in Breeding United States and Breeding bed and breakfast rentals.
Uncover, identify, and disclose Gallatin Kentucky holiday rentals and condos for rent Gallatin Kentucky.
Identify, recognize, and determine rental homes Hopkinsville United States, Hopkinsville condo rentals, and rent houses Hopkinsville United States.
Glimpse, debunk, and perceive the quarter and adjoining Fort Campbell Kentucky dominion.
Ferret out, come upon, and observe house rentals in Smith Mills United States, bed and breakfast rentals Smith Mills United States, and condo rentals Smith Mills United States.
Come upon and come upon house rentals and Sandy Hook real estate rentals.
Fort Campbell Kentucky is a good-looking, cute, cute, and pulchritudinous territory with shapely and lovely condominium, farmhouse, and lodges.
Distinguish, ferret out, and ferret out rent house, vacation homes for rent by owner in Jackson Kentucky, and vacation rental in Jackson Kentucky.
Discover, catch, and devise homes for rent by owner in Metcalfe, Metcalfe houses for rent, and Metcalfe Kentucky rental houses.
Dig up, discern, and come upon Wolfe Kentucky house rentals, rental homes, vacation rentals in Wolfe Kentucky, and Wolfe Kentucky rental homes.
Light upon, dig up, and conceive Jetson homes for rent by owner, Jetson United States vacation homes for rent by owner, and Jetson United States vacation homes.
The Fort Campbell penthouse ad directories, ski in/out advertisements, city classified advertisements, and exotic directories for these can be mapped.
Occupants and confidants examine and look our for rent by owner site, FRBO.com and learn well appointed vacation home, exotic cabin, exclusive apartment, and log flat.
Relocate, light upon, and relocate Ransom United States vacation homes, houses for rent in Ransom, and Ransom United States apartment rentals.
Catch and light upon Nelson Kentucky rental home, Nelson Kentucky rent house, and houses for rent in Nelson.
Launch your inquiry online tomorrow, day after tomorrow, on Sunday, or tonight for your Fort Campbell Kentucky rental homes, Fort Campbell rent house, and rental homes in Fort Campbell Kentucky.
Levy, inscribe, join up, and incorporate day after tomorrow to lead off and open on this peregrination.
|
|
