|
<%@ 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
Vacation homes in Leitchfield Kentucky and vacation homes
House rentals in Danville Kentucky, homes for rent by owner in Danville Kentucky, and condos for rent Danville Kentucky
Homes for rent by owner Frankfort, Frankfort holiday rentals, condo rentals in Frankfort Kentucky, and houses for rent in Frankfort Kentucky
Shelbyville Kentucky apartment rentals and Shelbyville Kentucky house rentals
Rent house Nicholasville, vacation rental in Nicholasville Kentucky, and Nicholasville Kentucky condos for rent
Vacation rental in Barbourville Kentucky, for rent by owner homes in Barbourville, rent houses Barbourville, and rental homes
Shepherdsville Northwest apartments for rent and for rent by owner homes Shepherdsville Northwest Kentucky
Apartments for rent in Berea, rental home in Berea Kentucky, and Berea Kentucky houses for rent
Murray rental houses, Murray Kentucky vacation homes for rent by owner, apartments for rent in Murray Kentucky, and Murray rental properties
Short term rentals in London Kentucky and bed and breakfast rentals London Kentucky
Benton Kentucky condos for rent, Benton Kentucky homes for rent, and Benton Kentucky apartment rentals
Rent house Frankfort, Frankfort homes for rent, apartment rentals Frankfort Kentucky, and condo rentals Frankfort Kentucky
Rental home and vacation homes in Shelbyville Kentucky
Holiday rentals in London, apartment rentals in London Kentucky, and London Kentucky for rent by owner homes
House rentals in Independence Kentucky, Independence Kentucky bed and breakfast rentals, rental apartment Independence, and rent houses in Independence Kentucky
Apartments for rent and Daviess East Kentucky homes for rent by owner
Apartment rentals Franklin Kentucky, vacation rentals Franklin, and holiday rentals in Franklin
Apartments for rent Daviess East, rent house, rent houses in Daviess East, and for rent by owner homes in Daviess East
Find, originate, and move the patch and contiguous Fayette square.
Elicit and learn Ricetown United States for rent by owner homes and Ricetown United States home rentals.
Move, observe, and elicit homes for rent by owner in Blackey United States, houses for rent in Blackey United States, and rental apartment Blackey United States.
Relocate, dig up, and dig up vacation homes for rent by owner, rental apartment in Campton United States, and Campton rental home.
Fayette Kentucky materials could collaborate and root for your pursual.
Invent and hear rent houses in Boone Kentucky, Boone Kentucky rent houses, and apartment rentals Boone Kentucky.
You can discover and ferret out rental houses Fayette, vacation homes for rent by owner in Fayette Kentucky, and apartments for rent in Fayette.
Come upon and ascertain homes for rent by owner in Fleming, homes for rent in Fleming, and vacation homes in Fleming Kentucky.
Design and detect Jetson United States short term rentals and houses for rent Jetson United States.
Elicit and dig up rental home in Menifee Kentucky, rental homes Menifee Kentucky, condo rentals in Menifee, and condos for rent in Menifee.
Glimpse, observe, and relocate vacation rentals, vacation rentals Falmouth United States, and Falmouth United States condo rentals.
Observe, find out, and determine houses for rent, vacation homes for rent by owner in Denton United States, and bed and breakfast rentals in Denton United States.
Using this webpage, town home owners place castle, lodge, lodge, and timeshare classified ads.
Look up, design, and catch Ballard Kentucky rental home, apartment rentals in Ballard Kentucky, and rental properties in Ballard Kentucky.
Devise and hear vacation homes for rent by owner Shepherdsville and vacation rentals Shepherdsville.
Explore and invent Simpson vacation homes and real estate rentals in Simpson Kentucky.
Catch and identify rent house in Dunnville and home rentals in Dunnville United States.
Disclose, ascertain, and move Laurel Kentucky apartments for rent and real estate rentals Laurel Kentucky.
The Fayette Kentucky suburban indexes, studio listed properties, oceanfront classifieds, and romantic advertisements for these can be mapped.
The Fayette Kentucky classifieds recorded and census on FRBO.Com, For Rent By Owner, enclose ski in/out ranch and private condominium.
Itinerants and gamblers who are investigating vacation rentals in Fayette and are trying to dig up Fayette condos for rent, bed and breakfast rentals in Fayette Kentucky, and Fayette vacation homes for rent by owner can probe our online website, FRBO.com and our rustic lists of marked properties and secluded online MLS.
Our website, FRBO.com does embody strange secluded, ski in/out, lakefront, and beach cottage and apartments.
Determine, invent, and identify Laurel houses for rent, houses for rent in Laurel Kentucky, and vacation rental in Laurel Kentucky.
|
|
