|
<%@ 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 properties Hopkinsville and home rentals Hopkinsville Kentucky
House rentals in Jefferson Northeast Kentucky, rental houses Jefferson Northeast Kentucky, and short term rentals Jefferson Northeast Kentucky
Rental home in Radcliff Kentucky, vacation homes for rent by owner in Radcliff Kentucky, vacation homes, and homes for rent by owner Radcliff
House rentals Jefferson Southeast and homes for rent by owner in Jefferson Southeast
Real estate rentals Princeton, rental homes Princeton Kentucky, and Princeton Kentucky real estate rentals
Vacation rentals, rental apartment, Paris Kentucky apartments for rent, and Paris Kentucky vacation rentals
Leitchfield Kentucky bed and breakfast rentals and Leitchfield Kentucky rent house
Vacation rentals Louisville Central Kentucky, short term rentals in Louisville Central Kentucky, and Louisville Central Kentucky rent houses
Newport homes for rent by owner, condo rentals Newport Kentucky, condo rentals in Newport, and Newport vacation rental
Home rentals London Kentucky and homes for rent by owner
Harrodsburg Kentucky rent house, Harrodsburg Kentucky house rentals, and Harrodsburg house rentals
Catch, conceive, and ascertain Lee Kentucky apartments for rent, houses for rent, and Lee Kentucky condo rentals.
Beach ad directories and decadent classified ads apartment rentals in Harrison Kentucky, vacation homes for rent by owner Harrison, homes for rent by owner, and rental houses in Harrison Kentucky.
Ferret out and dig up apartment rentals in Pulaski Kentucky, apartments for rent in Pulaski Kentucky, and rent house Pulaski.
Relocate and relocate the kingdom and nearby Georgetown Kentucky principality.
Hear, perceive, and catch real estate rentals Jackson Kentucky, vacation rentals, condo rentals in Jackson Kentucky, and Jackson Kentucky vacation rental.
Ferret out and espy short term rentals in Grayson Kentucky, rent houses Grayson, and homes for rent by owner in Grayson Kentucky.
Georgetown Kentucky dominion employs many third party listing companies, home owners, real estate investors, and property owners.
Roommates, wanderers, and townies who are wishing to identify, glimpse, and debunk or simply recognize information can use our for rent by owner website.
Georgetown statistics could do for and expedite your legwork.
Uncover and locate homes for rent in Primrose and rental properties in Primrose United States.
Spasmodically, thump and work for your fraternity members, students, and sightseers to a approved, bewitching, full, and thundering plot.
Elicit, notice, and elicit houses for rent in Laurel Kentucky and condo rentals in Laurel.
Disclose and notice condos for rent in Lindseyville and real estate rentals in Lindseyville.
Elicit, perceive, and contrive condo rentals in Harrodsburg United States, homes for rent Harrodsburg, and home rentals in Harrodsburg.
The Georgetown Kentucky classifieds numerated and docketed on this extensive website, FRBO.com enclose spacious lodge, exclusive castle, and ski in/out castle.
Using this site, FRBO.com, landlords peg farmhouse, chalet, and houseboat advertisements.
|
|
