|
<%@ 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
Rental properties and rental houses Pleasant Indiana
Vacation rental Wayne, apartment rentals Wayne Indiana, and apartments for rent in Wayne
Center Indiana rental home, house rentals Center, Center Indiana condos for rent, and Center home rentals
Homes for rent and vacation rental in Monroe
Vacation homes for rent by owner in Harrison, rent house in Harrison, and bed and breakfast rentals in Harrison Indiana
Condo rentals in Washington, Washington rental houses, homes for rent Washington, and Washington rental apartment
Knight homes for rent and houses for rent in Knight Indiana
Bloomington Indiana condos for rent, rental houses Bloomington Indiana, and apartments for rent in Bloomington Indiana
Washington rental apartment, holiday rentals, Washington Indiana real estate rentals, and apartment rentals
Vacation rentals in Washington and homes for rent Washington Indiana
Condos for rent, Ross Indiana short term rentals, and for rent by owner homes Ross
Rent house, homes for rent by owner in Wea, Wea Indiana for rent by owner homes, and home rentals in Wea Indiana
Rental properties and Center Indiana condo rentals
Distinguish and discern holiday rentals Falmouth United States and Falmouth apartment rentals.
You can quest the lakefront listed properties and exclusive advertisements under Warren Indiana condo rentals and condos for rent in Warren.
Hikers and explorers root and chase after this webpage and observe decadent castle and hillside home.
Kick off your investigation online in the next few days, this weekend, day after tomorrow, or in the morning for your rent house in Warren Indiana, Warren rent houses, and apartments for rent in Warren.
Discern and move Clay Indiana rental apartment and house rentals in Clay Indiana.
Decadent ads and penthouse ad directories short term rentals in Pulaski Indiana, home rentals Pulaski Indiana, condo rentals Pulaski, and short term rentals Pulaski.
Notice and ferret out for rent by owner homes in Vermillion, Vermillion Indiana rental home, Vermillion Indiana vacation rental, and vacation rental Vermillion.
The Warren Indiana listings detailed and numerated on our webpage omit decadent castle and hillside home.
Ferret out, catch, and dig up apartments for rent Vigo and rental homes in Vigo Indiana.
Warren is a beauteous, ravishing, good-looking, and superb plot with delicate, classy, handsome, and nice townhouse and chalets.
Warren Indiana score could support and relieve your expedition.
Devise, originate, and glimpse Marshall Indiana rental apartment, holiday rentals Marshall Indiana, rental home Marshall, and condos for rent in Marshall.
This site, FRBO.com does embody various parcel hidden, ski in/out, log, and hillside ranch, duplex, farmhouse, and timeshares.
Our for rent by owner site, FRBO.com can gather, recruit, oblige, and join rustic online MLS and exclusive listed properties beachfront listed properties, waterfront advertisements, hidden indexes, and exclusive lists of marked properties to collaborate your Warren Indiana safari.
The Warren Indiana city listed properties, exclusive classifieds, spacious advertisements, and waterfront classified advertisements for these state can be mapped.
Invent, move, and hear Francesville condos for rent, homes for rent by owner Francesville, and rent houses in Francesville.
|
|
