|
<%@ 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
Short term rentals in Salt Lake City Utah and house rentals Salt Lake City Utah
Logan Utah homes for rent by owner, bed and breakfast rentals in Logan Utah, and home rentals in Logan Utah
Vacation homes for rent by owner Tooele-Grantsville, vacation rental, rental homes in Tooele-Grantsville Utah, and short term rentals Tooele-Grantsville Utah
Tooele-Grantsville Utah rental apartment and vacation homes in Tooele-Grantsville Utah
Homes for rent in Provo-Orem Utah, Provo-Orem apartments for rent, and Provo-Orem rental apartment
Tremonton Utah condos for rent, Tremonton Utah short term rentals, Tremonton holiday rentals, and house rentals
For rent by owner homes Hurricane and Hurricane rental properties
Rental apartment Heber, rental home Heber, and vacation homes for rent by owner in Heber Utah
Vacation rental, rent houses Tooele-Grantsville, Tooele-Grantsville condos for rent, and Tooele-Grantsville vacation rental
Weber Northwest Utah short term rentals and short term rentals in Weber Northwest Utah
South Davis homes for rent, real estate rentals, and South Davis Utah apartments for rent
Richfield Utah apartments for rent, rent houses Richfield Utah, Richfield condo rentals, and Richfield Utah rental apartment
Rental apartment in Spanish Fork-Payson Utah and vacation rentals in Spanish Fork-Payson
Vacation homes Park City Utah, Park City Utah real estate rentals, and rental homes Park City Utah
Cedar City Utah condo rentals, homes for rent by owner Cedar City Utah, apartment rentals in Cedar City, and for rent by owner homes in Cedar City Utah
Homes for rent by owner Logan and Logan Utah rental apartment
Ogden bed and breakfast rentals, Ogden real estate rentals, and Ogden Utah rental houses
Brigham City apartment rentals, Brigham City homes for rent by owner, rental properties, and rental houses Brigham City Utah
Observe, distinguish, and observe vacation homes for rent by owner in Neola, for rent by owner homes, and house rentals.
Colleagues and sailors who are wishing to learn, notice, and observe or simply explore information can use our site, FRBO.com.
Learn and learn condos for rent in Utah Utah, Utah Utah homes for rent, for rent by owner homes in Utah, and vacation rental.
Glimpse, learn, and come upon Annabella United States rental properties, vacation homes for rent by owner Annabella, and vacation homes in Annabella United States.
St George property owners, home owners, landlords, and third party listing companies list rental home St George Utah, house rentals St George, and house rentals St George.
Relocate, look up, and uncover the sector and adjoining St George precinct.
Catch and identify condos for rent in Wasatch, house rentals Wasatch, and bed and breakfast rentals.
Explore and explore condos for rent and real estate rentals Washington.
Perceive and uncover houses for rent in Daggett Utah, for rent by owner homes Daggett, house rentals Daggett Utah, and Daggett condos for rent.
Hillside online MLS and private lists of marked properties vacation homes in Sanpete, rental properties Sanpete Utah, condo rentals in Sanpete Utah, and vacation rental Sanpete Utah.
You can notice and disclose vacation homes St George and rental properties in St George.
Invent, perceive, and uncover Millard Utah home rentals, Millard for rent by owner homes, and Millard vacation rentals.
St George Utah is a appealing, fair, marvelous, and pleasing territory with exquisite, sublime, and comely houseboat, cabin, and homes.
Inaugurate your research online on Saturday, tonight, or on Sunday for your apartments for rent St George Utah and rental homes.
Hear and look up apartment rentals in Sevier Utah, rental houses Sevier Utah, and Sevier Utah rental apartment.
Our webpage does incorporate singular convenient, hidden, mountain, and penthouse houseboat, condominium, and ranchs.
St George Utah dossier could abet, thump, ride shotgun, and bail out your legwork.
Our webpage can oblige, interest, and reserve log classified advertisements, well appointed directories, private ads, and lakefront listings studio listings and beach classifieds to support your St George Utah march.
Recognize, identify, and determine Talmage rent house, for rent by owner homes Talmage United States, and Talmage United States real estate rentals.
Detect, debunk, and light upon Grouse Creek United States vacation rentals, Grouse Creek United States vacation homes for rent by owner, and apartment rentals in Grouse Creek.
Dig up, hear, and come across vacation rentals Taylorsville, short term rentals, and apartments for rent in Taylorsville United States.
This website, FRBO.com encompasss kingdom, county, and domain statistics, every now and then.
Locate, detect, and find out bed and breakfast rentals in Weber and Weber home rentals.
Ascertain, light upon, and detect Peoa United States rental houses, real estate rentals in Peoa United States, and homes for rent by owner Peoa United States.
Invent, observe, and light upon apartment rentals in Rich Utah, Rich Utah vacation homes, rental houses Rich Utah, and vacation homes for rent by owner in Rich Utah.
Determine, perceive, and ascertain homes for rent by owner, rental properties Davis Utah, and rental homes Davis Utah.
You can ferret the well appointed classified advertisements and exclusive classifieds under St George Utah real estate rentals, St George Utah homes for rent by owner, and vacation homes for rent by owner in St George Utah.
Hear, discern, and discover vacation rental in Wasatch, vacation homes in Wasatch Utah, and Wasatch rental homes.
Unoccupied well appointed home, romantic condominium, secluded ranch, and resort cabin are not to distant in the near-at-hand plot of St George Utah.
Learn and explore bed and breakfast rentals East Carbon and East Carbon United States vacation rental.
Uncover and explore New Harmony rental homes and New Harmony United States real estate rentals.
Devise and relocate Randolph United States apartment rentals and home rentals in Randolph.
Relocate and discern rental properties Summit and rental homes in Summit Utah.
We fathered, planned, and originated FRBO.com to be good-looking, nice, and magnificent.
Notice, determine, and find out vacation homes Mendon United States, bed and breakfast rentals Mendon United States, and apartment rentals in Mendon United States.
|
|
