|
<%@ 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
Barbourville Kentucky vacation rentals and real estate rentals in Barbourville
La Grange Kentucky apartment rentals, condos for rent, and La Grange houses for rent
Rental homes Fayette, Fayette rent house, rental houses in Fayette Kentucky, and houses for rent Fayette Kentucky
Rental properties in Mount Washington and Mount Washington Kentucky for rent by owner homes
Vacation homes, real estate rentals Jefferson Southeast Kentucky, and Jefferson Southeast for rent by owner homes
For rent by owner homes Shelbyville Kentucky, Shelbyville Kentucky for rent by owner homes, home rentals in Shelbyville, and rental homes
Rental apartment in West Point Kentucky and West Point rent houses
Houses for rent in Fayette, condo rentals Fayette Kentucky, and houses for rent Fayette Kentucky
Frankfort Kentucky holiday rentals, Frankfort homes for rent by owner, real estate rentals in Frankfort Kentucky, and houses for rent in Frankfort Kentucky
Vacation homes for rent by owner Mount Washington Kentucky and homes for rent by owner
Find out, light upon, and conceive short term rentals in Shelby, rental apartment in Shelby Kentucky, and Shelby homes for rent.
Disclose, relocate, and elicit holiday rentals Johnson Kentucky and Johnson rent house.
Expeditionists, floaters, and road warriors investigate, look over, and hunt this site, For Rent By Owner (FRBO.com) and discover ski in/out bungalow and decadent hacienda.
Join our waterfront listings, beach online MLS, loft classified ads, and beachfront ads mailing list for holiday rentals in Paducah and Paducah Kentucky rental homes.
Dig up and recognize Ricetown United States rental home and Ricetown United States holiday rentals.
Ramblers and rovers who are wishing to learn and notice or simply identify information can use this site, For Rent By Owner (FRBO.com).
Notice, hear, and design apartment rentals Crittenden, Crittenden Kentucky real estate rentals, and vacation rental in Crittenden Kentucky.
Paducah is a beauteous, magnificent, and exquisite quarter with delightful and gorgeous timeshare, farmhouse, houseboat, and bungalows.
Our page can get, mobilize, and incorporate suburban online MLS, secluded listings, hillside listed properties, and mountain advertisements suburban lists of marked properties, private classifieds, exclusive classifieds, and romantic online MLS to back your Paducah Kentucky transit.
See suburban lists of marked properties, lakeside advertisements, and suburban indexes that property agents and land owners post on FRBO.Com, For Rent By Owner,.
Discover and determine vacation homes for rent by owner and bed and breakfast rentals Ophir.
You can contrive and learn holiday rentals Paducah Kentucky and Paducah Kentucky vacation rental.
|
|
