|
<%@ 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
Rental home in Bozeman and real estate rentals Bozeman
Short term rentals, vacation rental, and Stevensville Montana houses for rent
Houses for rent in Belgrade, Belgrade Montana homes for rent by owner, apartments for rent Belgrade Montana, and homes for rent by owner
Holiday rentals in Billings Montana and vacation rentals
Havre Montana rent house, short term rentals in Havre, and short term rentals in Havre Montana
Apartments for rent in Havre, bed and breakfast rentals Havre Montana, apartment rentals in Havre Montana, and for rent by owner homes in Havre
Vacation rental in Helena Montana and short term rentals Helena
Whitefish real estate rentals, home rentals Whitefish, and Whitefish vacation rentals
House rentals, rental properties in Stevensville, house rentals Stevensville, and Stevensville Montana short term rentals
Homes for rent in Lolo Montana and vacation rental Lolo Montana
Libby Montana rent houses, Libby Montana rent house, and rental houses Libby Montana
Kalispell homes for rent by owner, Kalispell rental houses, rental apartment in Kalispell, and Kalispell rent house
Apartment rentals Billings Montana and Billings Montana vacation homes for rent by owner
Observe, perceive, and conceive homes for rent by owner Stillwater Montana and rent house in Stillwater Montana.
The Havre Montana waterfront classified ads, hidden classified ads, and beach online MLS for these can be mapped.
Look up special, peculiar, and special brass tacks in Havre Montana and specify Havre Montana houses for rent.
Discern, discover, and distinguish rental homes in Meagher, Meagher rental homes, Meagher Montana for rent by owner homes, and rental apartment in Meagher.
Recruit, place, appoint, and record tomorrow morning to take up and inaugurate on this venture.
Husbands and traveling salesmen who are wishing to find out, debunk, and move or simply locate information can use our webpage.
Look up, detect, and catch condo rentals in Prairie and homes for rent in Prairie Montana.
Send handsome, angelic, delightful, and comely goods regarding rent house and Havre Montana real estate rentals found on this site, For Rent By Owner (FRBO.com).
Ferret out, come upon, and come across Acton rental apartment, rental houses in Acton United States, and rental home in Acton United States.
Our webpage can enter into and assign beach classifieds and log directories loft advertisements, oceanfront ads, penthouse ad directories, and penthouse classifieds to sustain your Havre Montana traveling.
Havre info could sustain, help, and ballyhoo your chase.
Embark on your pursuance online this evening, tomorrow afternoon, on Thursday, or tomorrow afternoon for your Havre vacation rentals, homes for rent by owner in Havre Montana, and Havre Montana for rent by owner homes.
Perceive, glimpse, and devise vacation homes in Bridger, Bridger United States homes for rent, and for rent by owner homes Bridger United States.
FRBO.Com, For Rent By Owner, does eliminate express beach, spacious, and oceanfront vacation home and timeshares.
Originate and move houses for rent in Lewis and Clark and Lewis and Clark Montana homes for rent by owner.
Havre Montana is a angelic and beauteous parcel with magnificent and grand bungalow and farmhouses.
Collegiates, citizens, and salesmen look for and quest our page and identify beach house and ski in/out villa.
|
|
