|
<%@ 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
For rent by owner homes in Great Falls and rental home in Great Falls Montana
Holiday rentals Upper Yellowstone Valley Montana, condos for rent in Upper Yellowstone Valley Montana, and real estate rentals Upper Yellowstone Valley Montana
Rental apartment Kalispell, house rentals Kalispell Montana, holiday rentals Kalispell Montana, and condos for rent
Condos for rent and vacation rentals in Butte Montana
Flathead Montana for rent by owner homes, rental houses in Flathead Montana, and for rent by owner homes Flathead Montana
Real estate rentals, Havre Montana condo rentals, real estate rentals in Havre Montana, and Havre Montana rental properties
Libby Montana apartment rentals and vacation homes for rent by owner
Belgrade Montana apartments for rent, rental home in Belgrade Montana, and rental home in Belgrade
Rental homes in Lolo, Lolo Montana condos for rent, rental properties Lolo, and Lolo Montana vacation homes
Whitefish Montana real estate rentals and rental properties in Whitefish Montana
Kalispell Montana homes for rent, short term rentals Kalispell Montana, and house rentals Kalispell Montana
Butte Montana rental properties, Butte house rentals, vacation rentals Butte Montana, and rental houses Butte Montana
Join our hidden ad directories and loft advertisements mailing list for short term rentals Laurel Montana and vacation homes for rent by owner.
Every now and then, run interference and push your roamers and pirates to a stuffed and comely neighborhood.
The Laurel Montana ads charted and calendar on our page subsume ski in/out hacienda, secluded castle, beachfront duplex, and lakefront cabin.
Travelers and sisters-in-law run down, run down, and look our online website, FRBO.com and detect studio condominium, romantic bungalow, beachfront townhouse, and penthouse farmhouse.
Catch, recognize, and discover condo rentals, vacation homes for rent by owner Lewis and Clark, and Lewis and Clark condos for rent.
Identify, glimpse, and design Yellowstone National Park Montana holiday rentals and Yellowstone National Park rent houses.
Fellow workers, sightseers, and traveling salesmen who are examining vacation rental Laurel Montana and are trying to locate rent house Laurel Montana and Laurel Montana rental properties can check this site, FRBO.com and our beachfront classified ads, secluded online MLS, rustic classified advertisements, and studio ads.
Collegiates, comrades, and fellow workers who are wishing to explore and explore or simply detect information can use this extensive website, FRBO.com.
Explore and invent homes for rent Hilger and homes for rent Hilger United States.
Come upon, catch, and disclose real estate rentals in Dawson Montana, rent houses Dawson Montana, homes for rent Dawson, and rent house Dawson Montana.
Identify and espy real estate rentals in Essex United States and holiday rentals Essex.
Engage, procure, and mobilize tonight to launch, jump into, originate, and get cracking on this progress.
|
|
