|
<%@ 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" %>
|
Indiana Rental Links
Wayne Indiana apartment rentals and homes for rent in Wayne
Apartments for rent in Clay Indiana, rental houses in Clay, and Clay Indiana rental properties
Rental properties in Guilford, rental apartment, Guilford Indiana condo rentals, and rental properties Guilford
House rentals Center and homes for rent in Center Indiana
Homes for rent by owner, White River Indiana home rentals, and holiday rentals
Knight Indiana short term rentals, vacation homes in Knight Indiana, home rentals Knight, and vacation rental in Knight
Home rentals Washington Indiana and bed and breakfast rentals Washington Indiana
Homes for rent by owner Concord Indiana, holiday rentals Concord Indiana, and Concord apartments for rent
Homes for rent by owner in Washington Indiana, Washington Indiana homes for rent by owner, short term rentals in Washington Indiana, and Washington vacation rentals
Mount Pleasant Indiana apartment rentals and short term rentals Mount Pleasant
Vacation rental, houses for rent in Honey Creek Indiana, and homes for rent by owner
Wayne Indiana rent houses, Wayne Indiana apartments for rent, rental houses in Wayne, and home rentals Wayne Indiana
Washington Indiana for rent by owner homes and rental houses in Washington
House rentals in Peru Indiana, condos for rent Peru Indiana, and for rent by owner homes
Honey Creek Indiana vacation rentals, rental houses, home rentals, and Honey Creek vacation rental
Rental homes White River Indiana and rental apartment
Vacation homes for rent by owner in Delaware Indiana, vacation homes for rent by owner, and Delaware vacation homes
Washington homes for rent by owner, homes for rent Washington, house rentals in Washington, and vacation homes for rent by owner
Union Indiana vacation homes for rent by owner and Union Indiana for rent by owner homes
Notice, uncover, and perceive rental homes in Roanoke, holiday rentals in Roanoke United States, and Roanoke United States real estate rentals.
Debunk and relocate bed and breakfast rentals Bristow United States and rent houses Bristow.
Pre-leased beach cabin and resort bungalow are abutting in the nearly territory of Jeffersonville.
Contrive and notice rent houses Buffalo and apartment rentals Buffalo United States.
The Jeffersonville directories inscribed and buttoned down on this site, FRBO.com hold beach cabin and resort bungalow.
Discover and discover homes for rent by owner in Cromwell and rent houses Cromwell.
Perceive and locate homes for rent and rental homes in Cannelburg.
Disclose and come across vacation homes for rent by owner Jackson, Jackson Indiana rental homes, and Jackson Indiana house rentals.
Dig up, dig up, and elicit vacation homes Elkhart, vacation rental Elkhart, rental apartment, and home rentals in Elkhart Indiana.
Identify and detect vacation homes for rent by owner Losantville and rent house Losantville.
Sign on, hitch, and induct tomorrow evening to jump into and get going on this jaunt.
Dig up, originate, and hear short term rentals Perry Indiana, vacation homes, and rental home in Perry.
Hear and learn Johnson Indiana rent houses, homes for rent by owner in Johnson, and Johnson Indiana rent houses.
Find out and come upon bed and breakfast rentals Cloverdale and homes for rent in Cloverdale United States.
Locate, discern, and identify Whitley Indiana rent house and vacation rental Whitley Indiana.
Originate and espy house rentals, vacation homes in Greene, and Greene Indiana rental home.
Perceive and observe vacation rentals in Tipton Indiana and Tipton Indiana home rentals.
Catch and locate vacation rental Solsberry United States and rental properties Solsberry United States.
Join our well appointed directories, convenient classified ads, exotic listings, and suburban classified advertisements mailing list for short term rentals in Jeffersonville Indiana, rental home in Jeffersonville Indiana, and vacation rental in Jeffersonville Indiana.
Invent, contrive, and light upon Fountain Indiana short term rentals and rental properties Fountain.
Discover and locate Tennyson United States holiday rentals and vacation rental Tennyson United States.
The Jeffersonville Indiana suburban directories, city classified advertisements, beach listed properties, and rustic listings for these can be mapped.
Jeffersonville block employs many property managers, land owners, property managers, and third party agents.
Our webpage arranges state and stretch brass tacks, ordinarily.
Jeffersonville Indiana evidence could open doors and aid your inquiry.
Distinguish, uncover, and find Lake Indiana vacation rentals, rental apartment Lake, and apartment rentals in Lake.
Debunk, come across, and originate real estate rentals in Pekin United States, Pekin vacation homes, and Pekin United States rent house.
Explore and espy Vigo Indiana condo rentals, Vigo Indiana homes for rent, vacation rental Vigo, and rental houses in Vigo Indiana.
Perceive, learn, and hear rental apartment Brookville, homes for rent, and short term rentals.
Explore, invent, and discover vacation homes for rent by owner in Michigantown, Michigantown homes for rent by owner, and Michigantown United States apartments for rent.
|
|
