|
<%@ 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
Rental properties in Bingham Utah and condo rentals Bingham Utah
Short term rentals Cedar City, rental home Cedar City Utah, and Cedar City Utah rental properties
Brigham City homes for rent, homes for rent in Brigham City Utah, holiday rentals in Brigham City Utah, and apartment rentals in Brigham City Utah
Weber Northwest Utah bed and breakfast rentals and home rentals Weber Northwest
Vacation homes for rent by owner in Roosevelt, Roosevelt holiday rentals, and Roosevelt vacation homes for rent by owner
Logan rent house, Logan condo rentals, rental apartment Logan, and short term rentals in Logan
Spanish Fork-Payson Utah rental properties and vacation rentals in Spanish Fork-Payson Utah
Rental houses Ogden Utah, apartment rentals in Ogden Utah, and homes for rent by owner in Ogden Utah
Rental homes, apartments for rent, condos for rent in Springville-Mapleton Utah, and Springville-Mapleton rent houses
St George Utah rent houses and homes for rent by owner
Lehi rental properties, rental properties, and rental home in Lehi Utah
Apartment rentals in Salt Lake City Utah, vacation rental in Salt Lake City, Salt Lake City vacation rentals, and short term rentals in Salt Lake City Utah
Condo rentals in Heber Utah and vacation rental Heber Utah
Apartment rentals Park City Utah, real estate rentals in Park City, and rental houses
Short term rentals in Salt Lake City Utah, bed and breakfast rentals Salt Lake City Utah, Salt Lake City Utah rental apartment, and vacation rental Salt Lake City Utah
Rental properties Magna and homes for rent by owner Magna
Logan Utah vacation rental, Logan Utah rental homes, and vacation rental
Provo-Orem short term rentals, apartments for rent Provo-Orem, Provo-Orem Utah holiday rentals, and Provo-Orem apartment rentals
Rental houses in Tooele-Grantsville Utah and rent house
Rental apartment in St George, St George condos for rent, and St George vacation homes
Park City Utah apartment rentals, rent house Park City Utah, vacation homes for rent by owner in Park City, and condo rentals in Park City Utah
Spanish Fork-Payson Utah house rentals and homes for rent in Spanish Fork-Payson
Detect, find out, and determine the township and not far Tremonton Utah tract.
Our website, FRBO.com can secure and secure lakeside indexes, spacious indexes, convenient directories, and private lists of marked properties lakeside ad directories, waterfront ads, resort listings, and resort listings to serve your Tremonton hike.
Espy, elicit, and espy apartments for rent in Salt Lake City United States, vacation homes for rent by owner in Salt Lake City, and houses for rent in Salt Lake City United States.
Hillside indexes and ski in/out classifieds rental homes Box Elder Utah, rental home in Box Elder, rental houses in Box Elder Utah, and condo rentals Box Elder Utah.
Find and explore rental home in Monroe and Monroe house rentals.
You can probe the mountain lists of marked properties, lakeside advertisements, and beach classified ads under vacation homes for rent by owner in Tremonton Utah and vacation homes for rent by owner.
Learn and come across vacation rental and apartments for rent in Cisco United States.
Find out, observe, and relocate vacation homes for rent by owner Sanpete, Sanpete rental properties, condo rentals in Sanpete, and homes for rent in Sanpete Utah.
Ramblers and indwellers who are scouring Tremonton Utah condos for rent and are trying to dig up rental apartment Tremonton Utah and homes for rent by owner Tremonton can comb our page and our mountain classified ads, suburban classified advertisements, well appointed advertisements, and resort advertisements.
Draft and procure this weekend to enter upon, embark on, and initiate on this course.
Ferret out, come upon, and notice Millville United States condos for rent, Millville United States real estate rentals, and rental homes in Millville United States.
Tremonton is a ideal and symmetrical domain with fair, shapely, ravishing, and alluring lodge, house, and townhouses.
Elicit and move apartments for rent Grand Utah, vacation homes in Grand Utah, and Grand Utah houses for rent.
Come across, locate, and catch Wellsville United States rent house, homes for rent by owner Wellsville United States, and vacation rental.
Ferret out, contrive, and recognize short term rentals in Ivins United States, Ivins United States bed and breakfast rentals, and vacation rental Ivins.
Move and look up apartments for rent in Centerville United States and Centerville condo rentals.
Ferret out, identify, and relocate vacation homes in Lapoint United States, bed and breakfast rentals Lapoint United States, and houses for rent.
Debunk and originate rental properties in Carbon, holiday rentals Carbon, and bed and breakfast rentals in Carbon Utah.
Light upon and ascertain rent houses in Oak City and vacation rentals Oak City.
Look up, explore, and conceive for rent by owner homes, rental home in Aurora United States, and houses for rent.
Ascertain and espy vacation rentals and San Juan Utah house rentals.
Espy, perceive, and observe rent houses and rental apartment.
We conceived, actualize, and founded our site, FRBO.com to be taking, good-looking, splendid, and dazzling.
Send exquisite, graceful, and foxy abstracts regarding houses for rent in Tremonton Utah and bed and breakfast rentals Tremonton found on our for rent by owner site, FRBO.com.
Relocate, glimpse, and elicit Peoa United States vacation homes, holiday rentals Peoa United States, and for rent by owner homes in Peoa United States.
Recognize, move, and discern Honeyville for rent by owner homes, Honeyville United States homes for rent by owner, and Honeyville United States rental properties.
Relocate, distinguish, and identify holiday rentals in Daggett Utah and home rentals Daggett.
Learn and catch short term rentals Sanpete Utah, apartment rentals, Sanpete Utah short term rentals, and real estate rentals in Sanpete Utah.
Discover and hear vacation homes for rent by owner in Tooele Utah, Tooele homes for rent by owner, Tooele Utah rental homes, and short term rentals in Tooele Utah.
Debunk, catch, and move Kane Utah houses for rent, rental home in Kane Utah, and Kane Utah rental apartment.
Find out and recognize vacation rental and Utah Utah house rentals.
Elicit and relocate real estate rentals Clarkston United States and homes for rent Clarkston.
|
|
