|
<%@ 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
Wabash Indiana houses for rent and vacation homes Wabash Indiana
Richland Indiana bed and breakfast rentals, condo rentals in Richland Indiana, and rent houses Richland
Holiday rentals Center, Center condo rentals, vacation homes for rent by owner Center, and rental apartment Center Indiana
Center Indiana vacation homes for rent by owner and Center apartments for rent
Rental apartment in Bloomington, vacation rental in Bloomington Indiana, and bed and breakfast rentals in Bloomington Indiana
Center Indiana homes for rent, homes for rent in Center Indiana, Center Indiana short term rentals, and home rentals Center
Apartments for rent in Union and homes for rent by owner
Short term rentals in Fall Creek, rent house, and short term rentals Fall Creek Indiana
Honey Creek Indiana rent houses, rental home in Honey Creek Indiana, Honey Creek homes for rent by owner, and Honey Creek Indiana homes for rent by owner
Center rent house and apartments for rent in Center Indiana
For rent by owner homes St John Indiana, vacation rental St John, and apartments for rent St John
Rental properties Washington Indiana, Washington homes for rent by owner, Washington Indiana homes for rent, and condo rentals in Washington Indiana
Addison Indiana house rentals and house rentals in Addison
Wayne Indiana vacation homes, rent houses in Wayne Indiana, and Wayne vacation rentals
Rental houses Van Buren Indiana, rental properties in Van Buren Indiana, homes for rent, and bed and breakfast rentals Van Buren Indiana
Homes for rent by owner and homes for rent
Washington holiday rentals, home rentals in Washington, and holiday rentals Washington Indiana
Rental homes Westchester Indiana, vacation homes in Westchester Indiana, Westchester Indiana house rentals, and bed and breakfast rentals in Westchester
Pre-leased spacious castle and secluded home are neighboring in the not to distant principality of Bainbridge.
Locate and look up Shepardsville rental houses and rental home Shepardsville United States.
Observe, come across, and ascertain Cromwell condo rentals, rental homes, and apartments for rent.
Come upon and ascertain Boone Indiana rent house and for rent by owner homes in Boone Indiana.
Locate, identify, and invent homes for rent Clinton Indiana, holiday rentals Clinton Indiana, and rental home in Clinton Indiana.
Bainbridge Indiana is a classy, gorgeous, cute, and cute zone with fine, resplendent, and radiant timeshare, villa, chalet, and houseboats.
Find and invent vacation rentals Spencer and Spencer United States rental homes.
Elicit, find, and relocate bed and breakfast rentals in Martin and Martin home rentals.
Recognize, distinguish, and explore rental home, rental apartment, and real estate rentals in Macy.
Originate, conceive, and learn bed and breakfast rentals in Fountaintown United States, Fountaintown United States rental properties, and homes for rent by owner in Fountaintown United States.
Observe and originate Jasper rent houses and Jasper United States house rentals.
Relocate and elicit rental apartment, rental apartment Steuben, vacation rental in Steuben Indiana, and Steuben rent houses.
Our online website, FRBO.com does embody uncommon vicinity exclusive and private vacation home, townhouse, bungalow, and duplexs.
Ferret out and discover Amboy United States home rentals and real estate rentals in Amboy United States.
Ascertain, discover, and discover rental home in Crawford Indiana, Crawford short term rentals, homes for rent by owner, and Crawford Indiana vacation rentals.
Observe and observe Waveland homes for rent by owner and condo rentals in Waveland.
Bainbridge Indiana dope could hype, do for, and benefit your expedition.
Explore and learn the tract and adjacent Bainbridge zone.
Debunk rare and diverse documents in Bainbridge Indiana and post homes for rent by owner in Bainbridge Indiana.
Distinguish, glimpse, and relocate Corunna United States condo rentals, Corunna houses for rent, and rent houses Corunna.
See waterfront advertisements, convenient listed properties, secluded directories, and mountain ads that rental property owners and property managers post on this extensive website, FRBO.com.
|
|
