|
<%@ 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 home Louisville South and rental properties in Louisville South Kentucky
Fort Campbell Kentucky apartment rentals, Fort Campbell rental homes, and Fort Campbell Kentucky apartment rentals
Vacation rental, Jefferson Southwest Kentucky condo rentals, home rentals in Jefferson Southwest Kentucky, and for rent by owner homes
Vacation homes for rent by owner in Elizabethtown Kentucky and rent house Elizabethtown Kentucky
Vacation homes in Princeton Kentucky, home rentals Princeton, and rent houses
Fayette short term rentals, rental properties in Fayette, short term rentals, and house rentals Fayette
Apartments for rent Corbin Kentucky and Corbin Kentucky homes for rent by owner
Condos for rent in Jefferson Central Kentucky, vacation rentals Jefferson Central, and bed and breakfast rentals in Jefferson Central Kentucky
Home rentals, short term rentals in Paintsville Kentucky, Paintsville Kentucky vacation rental, and real estate rentals Paintsville
Condo rentals in Fort Campbell Kentucky and rent houses Fort Campbell
Danville Kentucky vacation homes, Danville vacation rental, and short term rentals in Danville
Vacation homes in Daviess East Kentucky, Daviess East Kentucky rental apartment, Daviess East Kentucky vacation rental, and rent houses Daviess East
Rental apartment in Mount Sterling and Mount Sterling Kentucky condo rentals
Mount Sterling Kentucky holiday rentals, vacation homes Mount Sterling Kentucky, and apartment rentals in Mount Sterling
Vacation rental, Hebron for rent by owner homes, vacation rentals in Hebron Kentucky, and rental homes in Hebron Kentucky
Paris Kentucky house rentals and Paris Kentucky house rentals
Rent house, Nicholasville vacation homes for rent by owner, and short term rentals Nicholasville
Vacation homes in Leitchfield, Leitchfield Kentucky rental home, Leitchfield apartment rentals, and Leitchfield rental homes
Radcliff Kentucky bed and breakfast rentals and houses for rent Radcliff
House rentals in Mayfield Kentucky, Mayfield Kentucky rental properties, and holiday rentals in Mayfield
Harlan Kentucky bed and breakfast rentals, vacation rentals in Harlan Kentucky, Harlan Kentucky rental properties, and vacation rental
Cynthiana houses for rent and holiday rentals
Bed and breakfast rentals in Princeton Kentucky, rental home Princeton Kentucky, and Princeton Kentucky vacation homes for rent by owner
Holiday rentals Brandenburg Kentucky, Brandenburg Kentucky rental home, vacation homes Brandenburg Kentucky, and Brandenburg Kentucky apartment rentals
Short term rentals in Mount Vernon and holiday rentals in Mount Vernon Kentucky
The Louisville Central Kentucky online MLS tallied and tallied on this webpage have city castle, lake home, and beach duplex.
Catch and invent vacation rentals in Barlow United States and homes for rent Barlow United States.
The Louisville Central Kentucky lake online MLS, lakeside advertisements, hillside indexes, and studio advertisements for these can be mapped.
Espy, come upon, and uncover homes for rent by owner in Mc Daniels United States, homes for rent by owner in Mc Daniels United States, and Mc Daniels condo rentals.
Using our for rent by owner website, third party listing companies census houseboat, lodge, and cabin indexes.
Our for rent by owner website comprehends neighborhood and principality materials, ofttimes.
Vacation rentals and Chippewa Ohio vacation homes
Discern, come across, and come across home rentals, rent house Emmalena United States, and rent house.
Find out and contrive Hardin Kentucky homes for rent by owner, house rentals in Hardin Kentucky, vacation rental, and rent houses in Hardin Kentucky.
Jump into your pursuit online now or next week for your Louisville Central homes for rent by owner, Louisville Central Kentucky real estate rentals, and homes for rent Louisville Central Kentucky.
Hear, move, and find Casey Kentucky vacation homes for rent by owner, real estate rentals in Casey Kentucky, Casey Kentucky rent house, and rental properties Casey.
Come across, dig up, and conceive short term rentals Clay Kentucky, Clay Kentucky rent houses, Clay Kentucky vacation rentals, and apartments for rent.
Explore, explore, and debunk house rentals in Larue Kentucky, homes for rent by owner Larue, holiday rentals in Larue Kentucky, and home rentals in Larue Kentucky.
Tenants, habitants, and householders search for , scour, and rifle through our website, FRBO.com and originate studio villa, waterfront villa, oceanfront duplex, and waterfront cabin.
Louisville Central sector employs many rental property owners, third party agents, and third party agents.
Contrive and espy Wheelwright United States rent houses and rental houses Wheelwright United States.
Dig up, locate, and design rental houses Confluence, rent house in Confluence United States, and Confluence United States rent houses.
Notice, discern, and invent short term rentals, apartments for rent, and condo rentals.
Pre-leased lakeside chalet, beachfront castle, spacious timeshare, and ski in/out vacation home are next in the immediate square of Louisville Central.
Contrive, find, and determine Logan Kentucky homes for rent by owner, Logan Kentucky real estate rentals, and houses for rent in Logan Kentucky.
Spasmodically, push, facilitate, and aid your roamers and inhabitants to a right stuff and luring territory.
Ferret out and ascertain Arlington houses for rent and Arlington home rentals.
Send exquisite and charming knowledge regarding Louisville Central Kentucky rental houses, Louisville Central Kentucky for rent by owner homes, and Louisville Central Kentucky for rent by owner homes found on our for rent by owner website.
Convenient advertisements and resort advertisements rental houses in Lewis, rental properties Lewis, for rent by owner homes Lewis Kentucky, and holiday rentals in Lewis Kentucky.
Identify and dig up rental houses, Metcalfe Kentucky real estate rentals, and condo rentals Metcalfe Kentucky.
Locate and discover Nelson Kentucky homes for rent, Nelson Kentucky vacation homes, bed and breakfast rentals in Nelson Kentucky, and rental apartment Nelson Kentucky.
Join our ski in/out listings, well appointed lists of marked properties, and loft ad directories mailing list for vacation homes for rent by owner in Louisville Central Kentucky and Louisville Central Kentucky homes for rent.
Distinguish and design holiday rentals in Carter Kentucky, Carter for rent by owner homes, and vacation rentals Carter Kentucky.
We conceived, spawned, and sired our website, FRBO.com to be divine and refined.
Discern, notice, and find out Crittenden Kentucky rental houses, Crittenden Kentucky vacation rental, and real estate rentals in Crittenden Kentucky.
Ramblers, journeyers, and occupants who are wishing to come upon and distinguish or simply find information can use our page.
|
|
