|
<%@ 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" %>
|
Montana Rental Links
Vacation homes for rent by owner Belgrade Montana and rental apartment Belgrade
Lolo Montana for rent by owner homes, vacation homes for rent by owner Lolo Montana, and homes for rent by owner in Lolo Montana
Missoula Montana vacation homes for rent by owner, holiday rentals in Missoula Montana, Missoula homes for rent, and homes for rent in Missoula Montana
Great Falls condos for rent and vacation rentals Great Falls
Short term rentals Helena Montana, Helena Montana vacation rental, and Helena Montana rental homes
Home rentals Libby, Libby Montana condos for rent, homes for rent in Libby, and vacation homes for rent by owner in Libby Montana
Apartment rentals and rental apartment Upper Yellowstone Valley
Vacation homes, rental apartment Missoula Montana, and bed and breakfast rentals in Missoula
Great Falls Montana rental apartment, for rent by owner homes in Great Falls, short term rentals Great Falls Montana, and homes for rent by owner
Holiday rentals in Butte Montana and Butte real estate rentals
Rental home Stevensville Montana, apartment rentals in Stevensville, and short term rentals in Stevensville Montana
Home rentals in Belgrade Montana, rental home in Belgrade Montana, Belgrade houses for rent, and Belgrade Montana rental houses
Helena Montana dope could plug and work for your investigation.
Send refined, radiant, and fine poop regarding bed and breakfast rentals in Helena Montana, vacation rentals, Helena short term rentals, and Helena houses for rent found on our website, FRBO.com.
Identify uncommon, diverse, original, and individual documents in Helena Montana and tabulate apartment rentals in Helena Montana.
Our website, FRBO.com can gather and attract decadent advertisements, decadent advertisements, lakefront indexes, and waterfront listed properties exclusive listings and resort lists of marked properties to ballyhoo your Helena Montana sally.
Pre-leased studio vacation home, romantic castle, well appointed apartment, and hidden duplex are not faraway in the imminent quarter of Helena Montana.
Notice and look up Saint Marie United States rental houses and Saint Marie apartments for rent.
Look up, relocate, and locate houses for rent in Polaris United States, apartments for rent in Polaris United States, and rental houses Polaris United States.
Move, detect, and espy rental home, real estate rentals, and holiday rentals in Floweree.
Hear and conceive homes for rent by owner Teton Montana, vacation homes for rent by owner, and home rentals in Teton Montana.
Better halves, voyagers, and romantics who are ferreting vacation homes for rent by owner and are trying to find out Helena apartment rentals and house rentals Helena can investigate our page and our beachfront listed properties, beach listed properties, and ski in/out indexes.
Helena Montana is a sightly, fine, and shapely city with beauteous, alluring, appealing, and excellent lodge and townhouses.
See romantic ad directories, hillside classified advertisements, lakefront classifieds, and mountain directories that rental agents and rental property owners post on our webpage.
Ferret out and locate Sheridan Montana apartment rentals, vacation rentals Sheridan, and Sheridan Montana apartments for rent.
|
|
