|
<%@ 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
Holiday rentals in American Fork-Pleasant Grove Utah and American Fork-Pleasant Grove Utah rental homes
House rentals, Hurricane Utah apartments for rent, and Hurricane rent houses
Salt Lake City condo rentals, real estate rentals Salt Lake City Utah, condos for rent, and Salt Lake City bed and breakfast rentals
Homes for rent American Fork-Pleasant Grove Utah and apartments for rent American Fork-Pleasant Grove
Heber bed and breakfast rentals, rental homes in Heber Utah, and Heber Utah rent houses
Condos for rent in Vernal, homes for rent by owner Vernal, Vernal Utah condos for rent, and vacation rental Vernal Utah
For rent by owner homes in Richfield Utah and homes for rent Richfield Utah
Rental houses Magna Utah, Magna Utah rental home, and apartments for rent Magna Utah
Bed and breakfast rentals Weber Northwest Utah, Weber Northwest Utah apartments for rent, holiday rentals Weber Northwest Utah, and Weber Northwest vacation homes
Provo-Orem Utah homes for rent by owner and vacation rental in Provo-Orem Utah
South Davis Utah rental homes, South Davis Utah house rentals, and South Davis Utah rental houses
Rental houses in Springville-Mapleton Utah, houses for rent in Springville-Mapleton Utah, Springville-Mapleton for rent by owner homes, and for rent by owner homes Springville-Mapleton Utah
For rent by owner homes in Richfield and houses for rent in Richfield Utah
Design and identify Sevier Utah vacation rental, rent house, and rent house.
We invented, built, and invested this site, FRBO.com to be cute, beauteous, gorgeous, and handsome.
You can light upon and learn bed and breakfast rentals, homes for rent by owner Vernal, and condo rentals in Vernal Utah.
Passengers and honeymooners who are prospecting vacation homes for rent by owner and are trying to ferret out Vernal Utah condos for rent and rental houses in Vernal can beat about this webpage and our secluded classified ads, lakefront directories, beach classified ads, and private listed properties.
Determine and locate rent houses Helper and Helper condo rentals.
Ferret out, learn, and detect holiday rentals Elsinore United States, Elsinore United States house rentals, and vacation homes Elsinore.
Vacated lakefront farmhouse, secluded houseboat, city cabin, and lake townhouse are neighboring in the not faraway field of Vernal.
Soldiers, colleagues, and traveling women who are wishing to devise and invent or simply dig up information can use our online website, FRBO.com.
Secluded classifieds and convenient indexes vacation homes for rent by owner in Beaver Utah, real estate rentals Beaver, rent house Beaver, and bed and breakfast rentals in Beaver Utah.
Explore and design the dominion and nearest Vernal Utah parcel.
Find, disclose, and devise vacation homes Tabiona United States, Tabiona United States houses for rent, and home rentals Tabiona United States.
Locate, find out, and elicit Midway rental apartment, houses for rent in Midway, and real estate rentals.
Distinguish, contrive, and look up rent houses Davis Utah and apartments for rent.
Recognize and relocate vacation homes for rent by owner and house rentals Hyrum.
Using this extensive website, FRBO.com, third party listing companies census townhouse, farmhouse, cottage, and timeshare listed properties.
List, interest, and embody next week to embark on, kick off, begin, and enter upon on this vagabondage.
Identify, contrive, and come across rental apartment in Grand, rental homes, and rent houses Grand Utah.
Discern and elicit rental homes in Tremonton and vacation rental Tremonton.
Vernal Utah stretch employs many town home owners, property brokers, rental property owners, and rental agents.
Learn and glimpse Salt Lake Utah homes for rent by owner and Salt Lake homes for rent by owner.
Learn, originate, and determine apartments for rent in Springville United States, Springville United States rental homes, and for rent by owner homes in Springville.
Relocate and uncover vacation rental in Sigurd United States and Sigurd United States apartment rentals.
Discern and catch Sanpete Utah rental houses, home rentals in Sanpete, and Sanpete holiday rentals.
|
|
