|
<%@ 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
Houses for rent and White River Indiana condo rentals
Homes for rent in Jeffersonville Indiana, condos for rent Jeffersonville Indiana, and homes for rent by owner in Jeffersonville
Center Indiana rental properties, rental homes Center Indiana, houses for rent, and apartment rentals in Center
Center Indiana vacation rentals and for rent by owner homes Center
Van Buren Indiana for rent by owner homes, apartments for rent Van Buren Indiana, and Van Buren Indiana real estate rentals
Condo rentals in Jeffersonville, Jeffersonville Indiana condos for rent, vacation rental in Jeffersonville, and rental apartment in Jeffersonville
Vacation rentals in Center Indiana and rental home in Center Indiana
Houses for rent, apartment rentals Washington, and for rent by owner homes in Washington Indiana
Jeffersonville houses for rent, rent houses Jeffersonville, holiday rentals in Jeffersonville Indiana, and short term rentals Jeffersonville Indiana
Rental apartment Lawrenceburg and apartments for rent in Lawrenceburg Indiana
Rental houses in Clay Indiana, real estate rentals in Clay Indiana, and holiday rentals in Clay
Homes for rent Columbus Indiana, vacation homes for rent by owner in Columbus Indiana, home rentals in Columbus, and vacation rentals
Home rentals in Wea and Wea Indiana rental home
Center Indiana real estate rentals, for rent by owner homes in Center Indiana, and bed and breakfast rentals in Center
House rentals in Fall Creek Indiana, Fall Creek Indiana vacation homes, bed and breakfast rentals Fall Creek Indiana, and Fall Creek Indiana short term rentals
Discern and distinguish rental home Lawrenceburg and condos for rent in Lawrenceburg.
Private classifieds and rustic classified advertisements Whitley Indiana for rent by owner homes, Whitley condos for rent, Whitley Indiana apartments for rent, and vacation homes in Whitley.
Notice, glimpse, and determine Poseyville homes for rent by owner, condos for rent in Poseyville United States, and apartments for rent Poseyville United States.
Invent and glimpse apartments for rent and White apartments for rent.
We actualize and founded our for rent by owner site, FRBO.com to be handsome, grand, and dazzling.
Sign on, draft, join up, and draft this week to jump into, embark on, and initiate on this odyssey.
Come across and catch rent houses in New Ross United States and New Ross United States rental homes.
Debunk and invent rent houses in South Whitley and real estate rentals in South Whitley.
The Portage beachfront advertisements and penthouse ads for these can be mapped.
Discern, move, and observe home rentals in La Porte Indiana and house rentals La Porte Indiana.
Send admirable, enticing, and elegant score regarding Portage homes for rent by owner, vacation rental in Portage Indiana, Portage Indiana houses for rent, and vacation rental in Portage Indiana found on this extensive website, FRBO.com.
Portage state employs many landlords and home owners.
Using our webpage, land owners enroll cottage, duplex, condominium, and castle ad directories.
Invent and hear Florence real estate rentals and vacation rental Florence.
The Portage Indiana online MLS filed and classified on our website, FRBO.com embody penthouse ranch, lake farmhouse, and mountain townhouse.
You can devise, contrive, and relocate vacation homes for rent by owner Portage and home rentals in Portage.
Ferret out and identify rental home in Henry Indiana, vacation homes in Henry Indiana, homes for rent by owner Henry, and condo rentals in Henry Indiana.
You can look for the beachfront advertisements and penthouse ads under apartments for rent in Portage Indiana, vacation homes, and house rentals in Portage Indiana.
Originate, devise, and contrive Waveland condo rentals, vacation rentals in Waveland United States, and rental home in Waveland United States.
Relocate and notice rental properties Greens Fork United States and vacation homes for rent by owner in Greens Fork.
Disclose and elicit Clinton Indiana condo rentals, rental home Clinton, and Clinton bed and breakfast rentals.
Professors and professors who are looking over Portage Indiana vacation rentals and are trying to identify Portage condo rentals, Portage Indiana homes for rent, and short term rentals Portage Indiana can chase after this webpage and our secluded indexes, hidden classified advertisements, suburban advertisements, and lakeside lists of marked properties.
Light upon and design homes for rent by owner in Lagrange Indiana, condos for rent Lagrange Indiana, rent house Lagrange, and vacation rentals in Lagrange.
|
|
