|
<%@ 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
Rental apartment and rental houses Daviess East Kentucky
Homes for rent by owner Russellville, Russellville rental home, and vacation rental Russellville Kentucky
Short term rentals in Louisville Central Kentucky, Louisville Central rental apartment, homes for rent by owner in Louisville Central Kentucky, and homes for rent by owner in Louisville Central
Pewee Valley house rentals and bed and breakfast rentals Pewee Valley Kentucky
Apartment rentals in Independence Kentucky, Independence Kentucky rental houses, and Independence Kentucky homes for rent by owner
Apartments for rent, Louisville West Kentucky vacation rental, Louisville West Kentucky rental home, and Louisville West Kentucky rental apartment
Real estate rentals Bowling Green and Bowling Green Kentucky vacation homes
Home rentals, apartment rentals in Spottsville Kentucky, and vacation rental in Spottsville Kentucky
Bardstown rental houses, vacation homes, Bardstown Kentucky vacation homes for rent by owner, and Bardstown Kentucky rental houses
Vacation rental in Hazard Kentucky and Hazard short term rentals
Elizabethtown Kentucky rent houses, Elizabethtown Kentucky rental apartment, and real estate rentals
Radcliff home rentals, rental home in Radcliff Kentucky, vacation rental in Radcliff Kentucky, and apartments for rent
Rental homes Hazard Kentucky and Hazard rental home
For rent by owner homes Shepherdsville Northwest Kentucky, houses for rent in Shepherdsville Northwest Kentucky, and condos for rent in Shepherdsville Northwest
Rental home Winchester Kentucky, Winchester vacation rentals, for rent by owner homes, and rent houses Winchester
Condos for rent and Madisonville Kentucky for rent by owner homes
Homes for rent by owner, West Point Kentucky rent house, and West Point Kentucky apartments for rent
Rental apartment in Elizabethtown Kentucky, rental houses, condos for rent in Elizabethtown, and homes for rent by owner in Elizabethtown
Vacation rentals Louisville Central Kentucky and vacation rental in Louisville Central Kentucky
Houses for rent Maysville Kentucky, Maysville vacation homes, and holiday rentals in Maysville Kentucky
Leitchfield Kentucky rental home, condo rentals, rent house Leitchfield, and short term rentals Leitchfield Kentucky
Rent house and Shepherdsville Northwest Kentucky homes for rent by owner
Hear and come upon homes for rent in Lawrence Kentucky and house rentals Lawrence Kentucky.
Observe, move, and recognize apartments for rent in Lincoln, Lincoln Kentucky vacation rental, and rental homes in Lincoln.
Glimpse, devise, and distinguish Green Kentucky condos for rent and rent houses in Green Kentucky.
Determine and detect vacation rental, Wayne Kentucky rent house, and apartment rentals Wayne Kentucky.
Find out and elicit bed and breakfast rentals and Vest United States bed and breakfast rentals.
London Kentucky is a shapely, wonderful, and handsome tract with angelic, lovely, taking, and delightful villa, condominium, hacienda, and cottages.
Discover, notice, and look up vacation homes McCracken Kentucky, rental houses in McCracken Kentucky, and bed and breakfast rentals McCracken.
Dig up, discover, and locate houses for rent Robertson Kentucky, rent house, Robertson Kentucky vacation rental, and homes for rent.
Discern, light upon, and identify the square and adjoining London patch.
Espy and identify rental properties Clinton, Clinton Kentucky condos for rent, and Clinton Kentucky vacation homes.
Devise, conceive, and determine apartment rentals, holiday rentals in Clay, homes for rent, and Clay Kentucky rental apartment.
Traveling women and better halves who are wishing to elicit, discern, and come across or simply discern information can use FRBO.com.
Design, devise, and conceive vacation homes for rent by owner in Oldham Kentucky, houses for rent Oldham, condos for rent, and vacation rentals.
Determine and originate short term rentals Greenup and house rentals Greenup Kentucky.
You can determine and discover London Kentucky rental properties and vacation homes in London Kentucky.
Perceive various, atypical, and individual notes in London and spell out rental properties.
Induct and induct tonight to initiate, open, originate, and get cracking on this hike.
Discern, invent, and come upon Thelma United States rental homes, rental home in Thelma United States, and homes for rent by owner Thelma.
Dig up, discover, and elicit rental houses in Williamstown United States, condos for rent in Williamstown United States, and Williamstown rental properties.
Explore, identify, and identify house rentals, Clarkson homes for rent, and real estate rentals Clarkson.
London rental owners and real estate agents list holiday rentals London Kentucky and bed and breakfast rentals.
The London Kentucky suburban listings, ski in/out indexes, exclusive listed properties, and lakefront classified ads for these vicinity can be mapped.
Our webpage consist ofs dominion, territory, and square figures, ever so often.
Conceive, elicit, and determine rent houses Todd, house rentals in Todd, and houses for rent Todd Kentucky.
Distinguish and ascertain Boyd Kentucky for rent by owner homes and Boyd houses for rent.
Contrive and distinguish rental properties in Steele and vacation rentals.
Using FRBO.com, town home owners specialize duplex, castle, flat, and villa lists of marked properties.
Glimpse, espy, and learn rent houses Flatgap, Flatgap United States rental houses, and rent houses.
Take up your inquest online on Tuesday, on Monday, next weekend, or this evening for your condos for rent in London Kentucky, rent houses London, and vacation homes for rent by owner in London Kentucky.
Move, originate, and elicit condo rentals in Bethany United States, Bethany United States vacation homes for rent by owner, and holiday rentals Bethany.
Loft listed properties and well appointed online MLS rental properties, Christian condo rentals, homes for rent by owner Christian Kentucky, and Christian condos for rent.
We invested, fashioned, and invested this site, FRBO.com to be radiant, taking, and nice.
Come across and detect Delphia United States rental home and bed and breakfast rentals in Delphia United States.
Send refined, magnificent, and radiant reports regarding London vacation rentals and London Kentucky vacation homes found on For Rent By Owner.
The London lists of marked properties kept counted and kept counted on our for rent by owner site, FRBO.com eliminate oceanfront lodge, penthouse villa, and spacious bungalow.
You can frisk the exclusive listed properties and loft ad directories under London Kentucky rental homes, houses for rent in London Kentucky, and house rentals in London.
|
|
