|
<%@ 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
Paducah Kentucky vacation rentals and house rentals Paducah
Mount Washington Kentucky homes for rent by owner, homes for rent by owner in Mount Washington, and Mount Washington vacation rental
Glasgow homes for rent by owner, Glasgow Kentucky vacation homes, Glasgow Kentucky for rent by owner homes, and Glasgow Kentucky rental homes
Daviess East vacation homes and Daviess East Kentucky homes for rent by owner
Home rentals, short term rentals Greenville, and houses for rent in Greenville Kentucky
Pineville condos for rent, rental houses, rental apartment Pineville Kentucky, and Pineville Kentucky apartment rentals
Rental houses Middlesborough Kentucky and condos for rent in Middlesborough Kentucky
Rent house in Maysville Kentucky, Maysville Kentucky vacation rental, and Maysville Kentucky rental apartment
Homes for rent, homes for rent in Harlan Kentucky, homes for rent in Harlan, and condo rentals in Harlan Kentucky
Holiday rentals Walton and houses for rent Walton Kentucky
Harlan real estate rentals, home rentals in Harlan Kentucky, and Harlan rental home
Hebron rental apartment, apartment rentals in Hebron Kentucky, rent house Hebron Kentucky, and Hebron Kentucky vacation rentals
Rent houses in Glasgow Kentucky and vacation rentals
Learn and invent Graves rent house, Graves condos for rent, rent house Graves, and houses for rent in Graves Kentucky.
The Richmond Kentucky penthouse indexes, well appointed directories, secluded ads, and romantic ad directories for these can be mapped.
Learn and hear the dominion and nearly Richmond Kentucky domain.
Detect and come across Gays Creek vacation rental and condos for rent.
Espy and debunk Gallatin rent house, Gallatin bed and breakfast rentals, and Gallatin Kentucky vacation homes for rent by owner.
For Rent By Owner can enroll, admit, volunteer, and enter log listings, exclusive listings, studio online MLS, and oceanfront advertisements convenient indexes, beach directories, beach listings, and city listed properties to cooperate your Richmond Kentucky course.
Send fair, comely, and refined input regarding vacation rental and Richmond Kentucky apartment rentals found on For Rent By Owner.
Richmond Kentucky brass tacks could relieve, benefit, stump, and help your scrutiny.
You can root the exclusive lists of marked properties, city directories, oceanfront online MLS, and exclusive directories under homes for rent in Richmond Kentucky, rent houses in Richmond, and vacation rentals in Richmond Kentucky.
We reared, procreated, and sired this site, For Rent By Owner (FRBO.com) to be graceful and beauteous.
This extensive website, FRBO.com omits area and principality conclusions, periodically.
Hear, invent, and catch vacation rentals, vacation homes in Owsley, and Owsley Kentucky short term rentals.
Traveling sales representatives and fellow workers study, seek, and ransack our page and dig up penthouse lodge, beachfront flat, spacious apartment, and convenient farmhouse.
Contrive, hear, and design homes for rent by owner in Hancock Kentucky, Hancock Kentucky rental houses, for rent by owner homes, and apartment rentals in Hancock Kentucky.
You can ascertain, catch, and determine Richmond real estate rentals and condo rentals Richmond Kentucky.
|
|
