|
<%@ 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
Condos for rent Bozeman Montana and Bozeman Montana apartments for rent
Vacation homes for rent by owner in Libby Montana, Libby Montana homes for rent by owner, and Libby Montana apartment rentals
Billings rent houses, holiday rentals in Billings Montana, real estate rentals in Billings Montana, and apartments for rent in Billings Montana
Stevensville rental houses and holiday rentals
Kalispell Montana condo rentals, rent house in Kalispell, and Kalispell homes for rent by owner
Condos for rent Great Falls Montana, rental home Great Falls, Great Falls Montana homes for rent by owner, and rent house in Great Falls
Missoula Montana rental properties and rental houses in Missoula Montana
Houses for rent in Libby Montana, holiday rentals Libby Montana, and Libby Montana house rentals
Vacation homes for rent by owner, Helena Montana rent houses, holiday rentals, and bed and breakfast rentals
Homes for rent by owner in Libby and houses for rent in Libby
Havre vacation homes for rent by owner, vacation homes in Havre, and vacation homes for rent by owner in Havre
Light upon and determine short term rentals in Carbon, apartments for rent in Carbon Montana, and Carbon Montana home rentals.
You can discern and conceive rental properties Great Falls and house rentals.
We set up and made FRBO.com to be fine, well-formed, and divine.
Our for rent by owner website can mobilize and sign on exotic directories, loft listings, ski in/out classifieds, and beach ads beachfront listed properties, well appointed listings, and penthouse ad directories to collaborate your Great Falls Montana traverse.
Come upon, devise, and design apartment rentals in Powder River and Powder River Montana vacation homes for rent by owner.
Catch, conceive, and elicit Garfield rental home, Garfield Montana bed and breakfast rentals, and rental apartment in Garfield Montana.
Look up, locate, and discover houses for rent Melrose, Melrose United States rental houses, and condos for rent in Melrose.
Notice, distinguish, and come across bed and breakfast rentals, Kevin United States rental apartment, and Kevin United States rental home.
Debunk, find out, and notice Stillwater bed and breakfast rentals, Stillwater Montana rental properties, rental homes, and homes for rent by owner.
Free hidden apartment, city cabin, studio chalet, and city apartment are adjacent in the nearly neighborhood of Great Falls.
Glimpse and detect condo rentals Polson and rental homes in Polson United States.
Great Falls Montana block employs many property owners, property brokers, and landlords.
Glimpse, uncover, and originate condos for rent, Sanders United States home rentals, and vacation rentals in Sanders United States.
Devise, learn, and identify rental houses in Olive United States, vacation rental Olive United States, and Olive United States holiday rentals.
The Great Falls Montana oceanfront classifieds, city lists of marked properties, beach classifieds, and hillside listings for these can be mapped.
Devise, detect, and look up house rentals, home rentals in Powder River, and rental houses.
Uncover and glimpse for rent by owner homes Wilsall and vacation rentals in Wilsall.
Look up and find rent house Mineral Montana and Mineral Montana condos for rent.
|
|
