|
<%@ 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
Versailles rental houses and Versailles Kentucky rental home
Hebron Kentucky condo rentals, rent house in Hebron Kentucky, and Hebron rent house
Alexandria Kentucky apartments for rent, Alexandria Kentucky apartments for rent, Alexandria apartment rentals, and Alexandria Kentucky vacation homes
Real estate rentals Shepherdsville Northwest and Shepherdsville Northwest Kentucky house rentals
Rent houses in Winchester Kentucky, vacation homes Winchester, and rent houses in Winchester Kentucky
Rent house, Radcliff rental homes, Radcliff Kentucky rental home, and holiday rentals Radcliff Kentucky
Bed and breakfast rentals Calvert City Kentucky and vacation homes in Calvert City Kentucky
Rental properties in Daviess East Kentucky, Daviess East rental properties, and Daviess East houses for rent
Lawrenceburg rent houses, short term rentals Lawrenceburg Kentucky, vacation rental in Lawrenceburg, and Lawrenceburg Kentucky houses for rent
Apartment rentals Walton and rental homes Walton Kentucky
Vacation rental in Franklin Kentucky, Franklin Kentucky condo rentals, and condos for rent in Franklin
Burlington Kentucky vacation homes for rent by owner, vacation rental in Burlington Kentucky, short term rentals Burlington, and homes for rent by owner in Burlington Kentucky
Rental apartment and rental properties Franklin
Vacation rentals in Hopkinsville Kentucky, Hopkinsville Kentucky home rentals, and Hopkinsville Kentucky vacation rentals
Find out, relocate, and come across Waddy United States house rentals, holiday rentals, and bed and breakfast rentals in Waddy.
The Benton Kentucky classified advertisements placed and scheduled on this website, FRBO.com comprehend suburban vacation home, beachfront house, and suburban ranch.
Locate and perceive Lost Creek short term rentals and Lost Creek United States real estate rentals.
Benton Kentucky is a cute and gorgeous county with splendid, delicate, and sublime condominium, hacienda, timeshare, and houseboats.
Explore and hear rental houses in Mount Sherman United States and Mount Sherman United States homes for rent.
Light upon diverse and specific knowledge in Benton Kentucky and tick off Benton Kentucky bed and breakfast rentals.
Opportunists and brothers who are scanning holiday rentals Benton Kentucky and are trying to design rental home in Benton, Benton rental homes, and Benton Kentucky holiday rentals can look our online website, FRBO.com and our ski in/out classified advertisements and suburban indexes.
Come across, dig up, and come across short term rentals in Hancock Kentucky and condos for rent in Hancock.
Look up and observe Allen house rentals and apartment rentals in Allen.
This site, FRBO.com does comprehend unconventional city waterfront, beach, and well appointed house and cabins.
We initiated and generated our site, FRBO.com to be marvelous, exquisite, and superb.
Lake ad directories and lake ad directories condos for rent in Trimble Kentucky, vacation homes for rent by owner, condos for rent in Trimble, and Trimble Kentucky rent house.
Explore, distinguish, and come upon rental apartment in Warren Kentucky and rental properties.
Better halves, travelers, and roadmen who are wishing to catch and identify or simply identify information can use this extensive website, FRBO.com.
Dig up and hear Knott Kentucky rental properties, houses for rent in Knott Kentucky, Knott Kentucky apartment rentals, and homes for rent by owner Knott Kentucky.
Look up, originate, and relocate Harrison Kentucky short term rentals, Harrison vacation homes for rent by owner, and Harrison for rent by owner homes.
Benton real estate brokers, land owners, third party listing companies, and brokers leasing foreclosures list Benton Kentucky rental houses, short term rentals in Benton Kentucky, and Benton rental properties.
|
|
