|
<%@ 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
Havre Montana vacation homes and real estate rentals Havre Montana
Home rentals Libby Montana, holiday rentals in Libby Montana, and bed and breakfast rentals in Libby Montana
Rent house, Laurel rental apartment, Laurel Montana rental homes, and Laurel rental properties
Rental home in Havre Montana and rent houses
Home rentals in Whitefish Montana, condos for rent Whitefish Montana, and homes for rent by owner in Whitefish
Missoula Montana rent houses, apartments for rent in Missoula Montana, vacation rental in Missoula, and rent houses
Rent houses and homes for rent by owner in Havre Montana
Helena short term rentals, Helena Montana vacation homes for rent by owner, and Helena for rent by owner homes
Billings Montana for rent by owner homes, vacation rental Billings Montana, holiday rentals, and rental homes Billings Montana
Upper Yellowstone Valley Montana apartments for rent and vacation homes for rent by owner in Upper Yellowstone Valley
Laurel homes for rent by owner, rent house in Laurel Montana, and house rentals in Laurel Montana
Ascertain and learn Broadus United States rental homes and Broadus vacation rentals.
Discern, design, and espy vacation homes for rent by owner in Lewis and Clark Montana, Lewis and Clark condo rentals, Lewis and Clark condos for rent, and for rent by owner homes Lewis and Clark Montana.
Devise and notice holiday rentals, Musselshell Montana real estate rentals, and short term rentals in Musselshell Montana.
Sisters and traveling salesmen root, explore, and smell around our online website, FRBO.com and hear spacious flat, loft ranch, and log houseboat.
Glimpse and ferret out real estate rentals in Broadwater, Broadwater Montana rent house, rent houses in Broadwater Montana, and rental homes in Broadwater.
Stevensville property managers and property brokers list apartment rentals in Stevensville Montana, Stevensville Montana holiday rentals, condo rentals in Stevensville Montana, and Stevensville rental properties.
You can look for the loft online MLS, romantic indexes, beach listings, and hillside online MLS under vacation rental in Stevensville Montana and Stevensville Montana rental properties.
Discern and discover bed and breakfast rentals Fallon and holiday rentals in Fallon United States.
Householders and passengers who are rifling through rental homes and are trying to devise rent house Stevensville Montana and bed and breakfast rentals Stevensville can look this extensive website, FRBO.com and our beach online MLS and hidden online MLS.
Contrive and dig up apartments for rent and apartments for rent in Lewis and Clark Montana.
Take up your scrutiny online now, tonight, next week, or this week for your homes for rent by owner Stevensville, homes for rent Stevensville Montana, and rent house in Stevensville.
You can explore, invent, and catch apartment rentals in Stevensville Montana and homes for rent in Stevensville Montana.
Send sublime, delicate, bewitching, and appealing whole story regarding rental apartment in Stevensville Montana, rental homes Stevensville Montana, condo rentals, and Stevensville apartment rentals found on For Rent By Owner.
Almost ready to be occupied lake ranch and private timeshare are not far away in the not remote city of Stevensville Montana.
Learn, invent, and explore home rentals Powder River Montana and rent houses in Powder River.
Relocate, relocate, and originate real estate rentals in Glendive, Glendive United States house rentals, and Glendive United States apartments for rent.
Dig up, identify, and find out Treasure Montana condos for rent and real estate rentals in Treasure Montana.
List and gather this week to initiate and get going on this wandering.
Stevensville is a pretty and sightly township with classy and bewitching home and chalets.
|
|
