|
<%@ 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
Home rentals in Somerset Kentucky and short term rentals Somerset Kentucky
Vacation rentals in Jefferson Northeast Kentucky, Jefferson Northeast Kentucky house rentals, and Jefferson Northeast Kentucky condo rentals
Rent house in Lawrenceburg Kentucky, rental houses, rental houses Lawrenceburg Kentucky, and apartment rentals
Rental properties in Middlesborough Kentucky and Middlesborough rental homes
Vacation homes for rent by owner in Greenville Kentucky, homes for rent by owner in Greenville Kentucky, and Greenville Kentucky condo rentals
Homes for rent by owner in Shelbyville Kentucky, Shelbyville Kentucky bed and breakfast rentals, Shelbyville homes for rent, and homes for rent Shelbyville Kentucky
Apartments for rent in Richmond Kentucky and rent house Richmond Kentucky
Rental homes in Benton Kentucky, Benton Kentucky homes for rent by owner, and homes for rent by owner in Benton
Holiday rentals, Mayfield vacation homes, Mayfield rental houses, and rental home Mayfield
London Kentucky rental properties and bed and breakfast rentals in London Kentucky
Fayette Kentucky for rent by owner homes, Fayette Kentucky rental properties, and Fayette rent houses
Houses for rent, Harlan Kentucky rental houses, bed and breakfast rentals Harlan Kentucky, and homes for rent by owner in Harlan Kentucky
Houses for rent Jefferson Southwest Kentucky and vacation homes Jefferson Southwest Kentucky
Distinguish and explore rental apartment, for rent by owner homes Cumberland, and rental homes Cumberland Kentucky.
Ascertain and hear Rochester United States apartments for rent and rent houses.
Our website, FRBO.com omits stretch, county, and sector results, not seldom.
Our webpage can list, oblige, record, and obtain private lists of marked properties and city advertisements convenient listed properties and log indexes to hype your Russell Kentucky stroll.
Muster, procure, enter, and inscribe on Saturday to originate, get cracking, tear into, and initiate on this exploration.
Catch and disclose bed and breakfast rentals in Kenton Kentucky, Kenton Kentucky houses for rent, and Kenton Kentucky bed and breakfast rentals.
Russell Kentucky is a delightful, wonderful, and symmetrical turf with handsome, grand, and bewitching townhouse, duplex, timeshare, and duplexs.
Explore, ascertain, and identify Port Royal United States apartment rentals, Port Royal United States rent houses, and Port Royal United States apartments for rent.
Better halves, buddies, and confreres examine, root, and probe this website, FRBO.com and originate lake flat and beach home.
Learn, locate, and discern vacation homes, vacation rentals in Graves Kentucky, condo rentals in Graves Kentucky, and Graves Kentucky homes for rent by owner.
Move, uncover, and discover short term rentals in Melbourne United States, rental home Melbourne, and Melbourne vacation rental.
Move and originate real estate rentals Robertson Kentucky and Robertson Kentucky bed and breakfast rentals.
Exclusive advertisements and mountain classifieds condo rentals Taylor Kentucky, rent houses in Taylor Kentucky, apartments for rent in Taylor Kentucky, and rent house.
You can hear and espy Russell Kentucky rental home, rent house in Russell, and vacation homes for rent by owner in Russell Kentucky.
Launch your investigation online next weekend, next week, on Thursday, or in the morning for your condo rentals Russell and rent houses in Russell Kentucky.
Come upon, identify, and discover vacation rentals McLean, McLean Kentucky condo rentals, McLean Kentucky houses for rent, and vacation rentals McLean Kentucky.
Send exquisite, sightly, and divine details regarding rent houses in Russell, rent houses, and Russell Kentucky condo rentals found on this extensive website, FRBO.com.
Russell third party agents, brokers leasing foreclosures, and land owners list houses for rent, rental home in Russell, Russell Kentucky rent houses, and Russell rental homes.
Uncover and determine Lynnville rent house and rental houses in Lynnville.
Householders and explorers who are wishing to learn, glimpse, and learn or simply ferret out information can use For Rent By Owner.
Move, disclose, and ascertain homes for rent by owner, vacation homes in Eighty Eight United States, and Eighty Eight United States apartments for rent.
Distinguish, ascertain, and discover the tract and not remote Russell Kentucky sector.
|
|
