|
<%@ 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" %>
|
Utah Rental Links
Vacation rentals and rent houses in Logan
Holiday rentals Magna Utah, vacation homes Magna, and Magna Utah rent house
Vacation homes for rent by owner in Tooele-Grantsville Utah, vacation homes for rent by owner, Tooele-Grantsville Utah holiday rentals, and apartment rentals Tooele-Grantsville Utah
Park City Utah vacation rentals and house rentals in Park City Utah
North Davis vacation rental, North Davis Utah rental properties, and North Davis Utah bed and breakfast rentals
Home rentals, rental home American Fork-Pleasant Grove Utah, for rent by owner homes American Fork-Pleasant Grove Utah, and vacation rentals in American Fork-Pleasant Grove Utah
Rental properties in Vernal Utah and apartments for rent
Apartments for rent Lehi Utah, condos for rent, and holiday rentals
Rent house in Provo-Orem Utah, Provo-Orem vacation homes, rent house in Provo-Orem, and vacation homes for rent by owner in Provo-Orem
Rental homes Springville-Mapleton Utah and rental homes
We constructed and instituted our page to be cute, ideal, and pleasing.
Students, salesmen, and companions who are rooting bed and breakfast rentals in Bingham and are trying to find apartments for rent, condo rentals in Bingham Utah, and vacation homes for rent by owner in Bingham can check our online website, FRBO.com and our well appointed lists of marked properties, lakeside listings, beach classified advertisements, and rustic lists of marked properties.
Notice, devise, and come across Huntsville United States for rent by owner homes, vacation homes for rent by owner in Huntsville, and home rentals in Huntsville.
Lakeside classified ads and hillside listings vacation homes in Grand Utah, Grand short term rentals, for rent by owner homes in Grand Utah, and home rentals in Grand.
Distinguish, discover, and elicit homes for rent by owner in Emery Utah, rent house in Emery, and home rentals.
Our webpage can reserve, incorporate, and secure hillside classifieds and penthouse directories studio lists of marked properties and lake listings to benefit your Bingham Utah run.
The Bingham online MLS tabulated and numerated on this webpage hold beachfront timeshare and loft bungalow.
See loft directories, well appointed ad directories, romantic listings, and convenient classifieds that condo owners and property brokers post on our webpage.
Discern, discover, and find out bed and breakfast rentals in Beaver Utah, apartments for rent in Beaver Utah, and apartments for rent in Beaver.
The Bingham exclusive directories, exotic indexes, city advertisements, and waterfront classified advertisements for these kingdom can be mapped.
Residers and locals who are wishing to come across and debunk or simply espy information can use our webpage.
Unoccupied exotic hacienda, exclusive lodge, loft cabin, and beach cottage are near-at-hand in the near-at-hand principality of Bingham.
Ascertain and observe Green River United States bed and breakfast rentals and rent house in Green River United States.
|
|
