|
<%@ 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
Hazard Kentucky apartment rentals and short term rentals in Hazard
Paris Kentucky apartments for rent, rental apartment in Paris Kentucky, and vacation rental Paris
Homes for rent by owner Greenville, Greenville Kentucky rent houses, rental properties Greenville Kentucky, and houses for rent in Greenville Kentucky
Rental houses Louisville South Kentucky and vacation rentals in Louisville South
Harrodsburg condo rentals, Harrodsburg house rentals, and Harrodsburg Kentucky vacation homes
House rentals Glasgow, Glasgow Kentucky real estate rentals, Glasgow Kentucky rental houses, and Glasgow vacation rentals
Home rentals and Louisville West Kentucky real estate rentals
Rental houses Calvert City, rental home in Calvert City Kentucky, and Calvert City Kentucky short term rentals
Louisville Central Kentucky for rent by owner homes, Louisville Central rental houses, holiday rentals in Louisville Central Kentucky, and home rentals in Louisville Central Kentucky
Vacation homes for rent by owner in Harlan Kentucky and bed and breakfast rentals
Rental properties in Elizabethtown, bed and breakfast rentals in Elizabethtown Kentucky, and rental properties
Holiday rentals in Richmond Kentucky, houses for rent in Richmond Kentucky, rental properties Richmond, and Richmond Kentucky houses for rent
Home rentals Elizabethtown and Elizabethtown Kentucky house rentals
Rental apartment Hopkinsville, Hopkinsville rental houses, and Hopkinsville Kentucky rental properties
Distinguish and identify holiday rentals in Grayson Kentucky and rent houses in Grayson.
Using this site, For Rent By Owner (FRBO.com), property agents itemize vacation home, cottage, and villa classified advertisements.
Usually, facilitate and assist your habitants, migrants, and twins to a prepossessing, likable, brimming, and the rage section.
Perceive, relocate, and invent Fulton short term rentals, for rent by owner homes Fulton United States, and houses for rent.
Devise and dig up Clinton Kentucky for rent by owner homes and Clinton Kentucky holiday rentals.
Relocate, ferret out, and detect short term rentals in Nicholas Kentucky and rental apartment.
We parented, formulated, and planned FRBO.com to be well-formed, sightly, stunning, and refined.
Disclose and debunk vacation homes Lincoln Kentucky and real estate rentals Lincoln Kentucky.
You can glimpse and glimpse rent houses in Berea Kentucky and Berea Kentucky vacation rental.
See waterfront classified advertisements and hillside directories that home owners and town home owners post on our site, FRBO.com.
The Berea Kentucky indexes numerated and tabulated on this site, FRBO.com eliminate waterfront cottage, private apartment, beach flat, and beach castle.
FRBO.Com, For Rent By Owner, incorporates field, township, territory, and plot whole story, at times.
Sightseers and fraternity members who are casing about condos for rent in Berea Kentucky and are trying to detect rental homes Berea and homes for rent Berea can shake down this webpage and our penthouse listings, well appointed classified advertisements, and spacious indexes.
Ready to move in lakefront townhouse and studio townhouse are adjacent in the approaching field of Berea Kentucky.
Identify and look up for rent by owner homes Bradfordsville United States and rental houses Bradfordsville United States.
Espy, notice, and contrive bed and breakfast rentals in Hebron, rental apartment Hebron United States, and home rentals.
Devise startling, discrete, ad hoc, and other poop sheet in Berea Kentucky and index rental houses in Berea.
Come upon, light upon, and catch Bullitt vacation rentals, house rentals, and rental properties Bullitt Kentucky.
Disclose and perceive vacation rentals Garrard, houses for rent Garrard, and rent houses Garrard Kentucky.
|
|
