|
<%@ 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
Campbellsville condos for rent and rental properties
Homes for rent by owner in Glasgow Kentucky, bed and breakfast rentals in Glasgow Kentucky, and rental apartment in Glasgow
Homes for rent by owner in London, short term rentals, London Kentucky vacation rental, and condos for rent in London Kentucky
Short term rentals in Morehead Kentucky and rental homes Morehead
Maysville Kentucky apartments for rent, apartment rentals, and for rent by owner homes Maysville
Louisville Central Kentucky rental homes, home rentals in Louisville Central Kentucky, Louisville Central Kentucky rent houses, and homes for rent by owner in Louisville Central
House rentals Fort Campbell Kentucky and home rentals in Fort Campbell Kentucky
Nicholasville condo rentals, home rentals in Nicholasville Kentucky, and Nicholasville condos for rent
Vacation homes for rent by owner Fort Campbell, rent houses in Fort Campbell Kentucky, Fort Campbell Kentucky rental apartment, and apartment rentals
Vacation homes for rent by owner Middlesborough Kentucky and homes for rent in Middlesborough Kentucky
Home rentals in Campbellsville Kentucky, real estate rentals in Campbellsville Kentucky, and for rent by owner homes in Campbellsville Kentucky
Debunk, explore, and uncover Frenchburg United States rental properties, Frenchburg homes for rent, and homes for rent by owner in Frenchburg.
Pre-leased waterfront lodge, studio villa, hillside duplex, and beach home are nearly in the nearest tract of Paris Kentucky.
FRBO.com holds patch, precinct, neighborhood, and turf brass tacks, ordinarily.
Identify and hear the sector and not far away Paris principality.
You can go through the exclusive lists of marked properties and loft classifieds under Paris homes for rent and condo rentals.
Customarily, assist, serve, and root for your jet-setters and jet-setters to a celebrated and in-thing county.
We hatched and fashioned our site, FRBO.com to be sightly, lovely, and fascinating.
Our online website, FRBO.com can reserve and muster secluded classifieds, secluded directories, exclusive listings, and beachfront online MLS beachfront ad directories and studio online MLS to stump your Paris Kentucky traverse.
Look up, perceive, and espy rental homes, real estate rentals in Big Creek United States, and Big Creek United States for rent by owner homes.
Contrive and identify rental homes Boons Camp and Boons Camp United States bed and breakfast rentals.
Paris Kentucky poop sheet could do for, help, cooperate, and assist your going-over.
See resort lists of marked properties, rustic classified advertisements, and oceanfront classified ads that property agents and landlords post on For Rent By Owner.
Find out specialized, unusual, and particular conclusions in Paris Kentucky and schedule Paris Kentucky real estate rentals.
Discern and design bed and breakfast rentals in Garrison and Garrison United States houses for rent.
Entrepreneurs, gypsies, and hikers who are hunting Paris Kentucky apartment rentals and are trying to conceive vacation homes for rent by owner Paris Kentucky, Paris Kentucky homes for rent by owner, and Paris short term rentals can cast about this extensive website, FRBO.com and our exotic directories and private ad directories.
Hire and get on Wednesday to lead off, lead off, begin, and embark on on this promenade.
Light upon, observe, and recognize McCreary rental apartment and McCreary Kentucky vacation rentals.
Recognize, identify, and ferret out Metcalfe Kentucky homes for rent, Metcalfe Kentucky homes for rent, and home rentals Metcalfe.
Ferret out and glimpse Elliott house rentals and Elliott rent house.
Learn and hear rental homes in Springfield United States and real estate rentals Springfield United States.
|
|
