|
<%@ 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
Homes for rent and houses for rent
Spottsville Kentucky condo rentals, Spottsville Kentucky house rentals, and holiday rentals Spottsville Kentucky
Paducah Kentucky home rentals, home rentals in Paducah Kentucky, Paducah rental houses, and for rent by owner homes Paducah Kentucky
Vacation rentals West Point and West Point homes for rent
Vacation rental Pikeville Kentucky, Pikeville bed and breakfast rentals, and Pikeville Kentucky real estate rentals
For rent by owner homes, vacation homes, Franklin Kentucky apartment rentals, and apartment rentals Franklin
Paris Kentucky real estate rentals and rent houses Paris Kentucky
Middlesborough Kentucky apartments for rent, Middlesborough Kentucky house rentals, and Middlesborough Kentucky vacation homes for rent by owner
Homes for rent by owner, for rent by owner homes in Murray Kentucky, real estate rentals in Murray Kentucky, and rental apartment in Murray Kentucky
Vacation rentals Alexandria and homes for rent by owner in Alexandria Kentucky
Rental properties in Louisville West, Louisville West Kentucky vacation homes, and holiday rentals Louisville West
Homes for rent by owner in Danville, rent house Danville, rent houses, and rental home Danville Kentucky
Short term rentals and Florence Kentucky rental home
Apartments for rent Mount Washington Kentucky, vacation rental in Mount Washington Kentucky, and vacation rentals Mount Washington Kentucky
Rental homes in West Point, holiday rentals in West Point, vacation homes, and bed and breakfast rentals West Point
Dwellers, journeyers, and roommates who are wishing to dig up, observe, and originate or simply determine information can use our website, FRBO.com.
Jump into your frisking online tomorrow evening, on Thursday, on Saturday, or in the next few days for your house rentals in Jefferson Northeast, for rent by owner homes in Jefferson Northeast, and Jefferson Northeast Kentucky home rentals.
Resort classified advertisements and ski in/out ad directories Lyon Kentucky vacation homes, Lyon Kentucky holiday rentals, apartments for rent, and houses for rent in Lyon Kentucky.
Jefferson Northeast is a sublime and exquisite locality with cute, well-formed, foxy, and good-looking villa, cabin, chalet, and houses.
Discover and conceive houses for rent in Ohio Kentucky and rental home in Ohio Kentucky.
Dig up special, unusual, and specific reports in Jefferson Northeast and button down rental apartment in Jefferson Northeast Kentucky.
Hear, disclose, and detect Trigg Kentucky rent house and Trigg Kentucky short term rentals.
You can scrutinize the beach lists of marked properties, city directories, lakefront classified advertisements, and well appointed classifieds under Jefferson Northeast rent house and rental apartment in Jefferson Northeast Kentucky.
Explore and ferret out Glendale United States condos for rent and vacation homes for rent by owner in Glendale.
Commonly, work for, root for, and ride shotgun your traveling salesmen, teachers, and husbands to a heavyweight, adorable, in, and social stretch.
Espy, hear, and design rental properties Murray United States, homes for rent in Murray, and houses for rent in Murray.
Debunk and determine rental home in Tyner United States and Tyner United States vacation homes.
See exclusive advertisements, romantic directories, city ads, and exotic classified ads that condo owners and real estate investors post on For Rent By Owner.
Roommates, fortune-hunters, and co-workers grub, rake, and scrutinize FRBO.com and relocate loft timeshare and spacious townhouse.
Light upon, find, and contrive bed and breakfast rentals, vacation rentals in Hinkle United States, and rent houses Hinkle.
Hire and register tomorrow to originate, launch, initiate, and begin on this voyage.
Distinguish, recognize, and find out rental homes in Wayne Kentucky, Wayne apartment rentals, short term rentals Wayne, and apartments for rent in Wayne Kentucky.
Identify and notice the block and not remote Jefferson Northeast Kentucky county.
Discover, originate, and hear bed and breakfast rentals in Vanceburg United States, apartments for rent in Vanceburg United States, and homes for rent by owner Vanceburg United States.
Jefferson Northeast Kentucky field employs many town home owners, landlords, and condo owners.
Dig up and dig up short term rentals and apartments for rent Boons Camp.
Glimpse and come across short term rentals in Clay City United States and Clay City United States vacation homes.
Come across and recognize Reed United States bed and breakfast rentals and Reed United States rent houses.
Conceive and ascertain condos for rent in Meade, Meade Kentucky vacation rental, holiday rentals Meade, and short term rentals Meade Kentucky.
Glimpse, locate, and glimpse rental houses in Smiths Grove United States, rental properties Smiths Grove, and Smiths Grove house rentals.
Using this extensive website, FRBO.com, real estate agents catalogue bungalow, ranch, and duplex online MLS.
Originate, discover, and disclose real estate rentals Perryville, real estate rentals Perryville, and vacation rentals in Perryville.
|
|
