|
<%@ 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
Daviess West real estate rentals and vacation rental in Daviess West Kentucky
Richmond short term rentals, Richmond Kentucky rental houses, and rental home in Richmond
Apartment rentals Owensboro, Owensboro rental houses, condo rentals in Owensboro, and short term rentals in Owensboro
Louisville West Kentucky houses for rent and house rentals in Louisville West Kentucky
Short term rentals in Fort Campbell Kentucky, rental home in Fort Campbell, and apartments for rent
Apartments for rent in Florence Kentucky, rental apartment in Florence, bed and breakfast rentals in Florence Kentucky, and holiday rentals Florence Kentucky
Houses for rent La Grange Kentucky and bed and breakfast rentals in La Grange
Louisville West Kentucky rental homes, Louisville West vacation homes for rent by owner, and rental properties
Winchester vacation homes, real estate rentals, apartments for rent, and Winchester Kentucky vacation homes
Rental properties in Florence Kentucky and houses for rent in Florence Kentucky
Bed and breakfast rentals, condos for rent, and West Point Kentucky holiday rentals
Rental homes in Shelbyville, rental houses Shelbyville Kentucky, for rent by owner homes in Shelbyville Kentucky, and short term rentals in Shelbyville
Adventurers and hikers who are running down Jefferson Central rent houses and are trying to determine rent houses Jefferson Central Kentucky, condos for rent in Jefferson Central, and Jefferson Central apartments for rent can quest this site, FRBO.com and our resort ads, lake listings, loft lists of marked properties, and loft classified advertisements.
Explore, devise, and contrive real estate rentals, apartment rentals Lincoln Kentucky, Lincoln Kentucky homes for rent by owner, and Lincoln Kentucky house rentals.
Originate, relocate, and conceive vacation homes for rent by owner in Clarkson United States, Clarkson United States condos for rent, and Clarkson United States apartments for rent.
Jefferson Central Kentucky materials could cooperate and run interference your pursuance.
Jefferson Central brokers leasing foreclosures, land owners, real estate agents, and town home owners list Jefferson Central Kentucky bed and breakfast rentals, Jefferson Central Kentucky real estate rentals, and Jefferson Central real estate rentals.
Join our resort lists of marked properties, romantic listed properties, and private ad directories mailing list for homes for rent by owner and home rentals.
Hear, light upon, and invent apartments for rent Simpson, Simpson Kentucky real estate rentals, vacation homes Simpson Kentucky, and Simpson Kentucky home rentals.
Come upon and ascertain rent houses in Loretto United States and rent house.
Uncover, design, and design Elliott Kentucky apartment rentals, vacation homes for rent by owner in Elliott, and Elliott Kentucky holiday rentals.
Detect, uncover, and come upon rental homes in Middlesboro, Middlesboro United States houses for rent, and holiday rentals.
This site, FRBO.com can assign, enroll, reserve, and oblige waterfront lists of marked properties and hidden advertisements loft listings and secluded indexes to push your Jefferson Central Kentucky patrol.
Jefferson Central Kentucky is a delicate and well-formed precinct with shapely, magnificent, and ideal home and lodges.
Identify and discover rent house, homes for rent by owner in Wolfe Kentucky, Wolfe Kentucky vacation homes for rent by owner, and rental houses in Wolfe.
|
|
