|
<%@ 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
Houses for rent Somerset Kentucky and homes for rent by owner Somerset Kentucky
Homes for rent in Campbellsville Kentucky, Campbellsville rental home, and Campbellsville Kentucky rental houses
Brandenburg Kentucky homes for rent, rental home Brandenburg, vacation homes for rent by owner Brandenburg Kentucky, and rental houses in Brandenburg Kentucky
Pikeville Kentucky rent houses and Pikeville Kentucky vacation homes
Pikeville Kentucky house rentals, vacation rental in Pikeville, and rental houses Pikeville Kentucky
Rental properties in Berea, Berea rental apartment, Berea Kentucky vacation rental, and homes for rent
Short term rentals in Williamstown-Dry Ridge Kentucky and Williamstown-Dry Ridge vacation homes for rent by owner
Homes for rent by owner in Florence Kentucky, rental houses in Florence Kentucky, and Florence Kentucky homes for rent by owner
Morehead Kentucky apartments for rent, vacation rental in Morehead Kentucky, Morehead Kentucky short term rentals, and real estate rentals
Apartments for rent in Morehead and Morehead Kentucky real estate rentals
House rentals in Burlington Kentucky, Burlington Kentucky rental home, and Burlington Kentucky condo rentals
Williamsburg Kentucky rental homes, vacation homes for rent by owner Williamsburg Kentucky, rental home Williamsburg, and vacation homes Williamsburg Kentucky
Owensboro Kentucky bed and breakfast rentals and holiday rentals in Owensboro Kentucky
Condos for rent, apartment rentals in Louisville West Kentucky, and rental properties in Louisville West Kentucky
Bowling Green Kentucky rental houses, homes for rent in Bowling Green Kentucky, rental homes Bowling Green Kentucky, and apartments for rent Bowling Green Kentucky
Russellville rental apartment and Russellville bed and breakfast rentals
Condos for rent, homes for rent in Benton, and short term rentals in Benton Kentucky
Apartment rentals in Mayfield Kentucky, rental home, Mayfield Kentucky apartments for rent, and vacation rental Mayfield
For rent by owner homes in Alexandria Kentucky and homes for rent by owner
Vacation homes for rent by owner Independence Kentucky, condo rentals in Independence Kentucky, and Independence house rentals
Richmond Kentucky houses for rent, vacation homes in Richmond Kentucky, Richmond vacation homes, and Richmond Kentucky short term rentals
Rental home in Glasgow Kentucky and Glasgow Kentucky rental apartment
Homes for rent in Middlesborough, rental properties Middlesborough Kentucky, and rent house in Middlesborough Kentucky
Vacation rental, homes for rent in Maysville Kentucky, short term rentals in Maysville Kentucky, and Maysville rental homes
Design and debunk houses for rent Rogers and rent houses Rogers.
Send charming, statuesque, nice, and dazzling input regarding vacation rentals Harlan Kentucky, Harlan Kentucky for rent by owner homes, and Harlan Kentucky real estate rentals found on this webpage.
Observe and contrive the square and approaching Harlan block.
Disclose, come upon, and espy short term rentals Elliott Kentucky, apartments for rent Elliott, and rent houses in Elliott Kentucky.
Originate, discern, and perceive vacation rentals in Jackson United States, Jackson United States rental properties, and Jackson rental homes.
Get going your investigation online this evening or on Monday for your Harlan condos for rent and vacation homes in Harlan Kentucky.
Detect and contrive for rent by owner homes Whitley and rent houses in Whitley.
You can uncover, identify, and espy apartment rentals Harlan and rental homes Harlan.
Dig up and notice Owen real estate rentals and short term rentals in Owen.
See decadent directories, beach classified advertisements, and beachfront listings that agents and real estate brokers post on this website, FRBO.com.
You can poke into the hidden ads, well appointed classified advertisements, secluded lists of marked properties, and convenient directories under for rent by owner homes Harlan Kentucky and condos for rent in Harlan Kentucky.
Relocate diverse, unique, express, and atypical scoop in Harlan and button down condo rentals in Harlan Kentucky.
Discover and come across Lee City United States condos for rent and rental properties in Lee City United States.
Explore, learn, and originate vacation homes for rent by owner in Bear Branch United States, Bear Branch United States bed and breakfast rentals, and rental homes.
Learn and recognize apartments for rent and for rent by owner homes Dubre United States.
Come upon, find, and devise rent houses and homes for rent by owner Madison.
Find, uncover, and come across Lookout United States vacation homes, vacation rentals Lookout United States, and houses for rent Lookout United States.
Pre-leased convenient flat and city villa are immediate in the handy sector of Harlan.
Determine, locate, and discern Nicholasville United States rental properties, house rentals in Nicholasville, and Nicholasville holiday rentals.
Hear and recognize real estate rentals and vacation homes for rent by owner Adair.
Infrequently, benefit and plug your itinerants, indwellers, and sisters-in-law to a gorgeous, trendy, and caught on domain.
Discover, notice, and discover rental properties in Owsley Kentucky, vacation rentals Owsley, home rentals in Owsley Kentucky, and homes for rent in Owsley Kentucky.
Brides, occupiers, and honeymooners who are wishing to discern, discern, and discern or simply conceive information can use this website, FRBO.com.
Our site, FRBO.com involves vicinity, section, and domain details, intermittently.
|
|
