|
<%@ 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
Real estate rentals in Tremonton Utah and homes for rent
Rent house Brigham City Utah, homes for rent by owner, and rental apartment Brigham City Utah
Homes for rent by owner in South Davis Utah, condo rentals in South Davis Utah, South Davis Utah house rentals, and South Davis condos for rent
Rental properties in Logan Utah and vacation rental in Logan
Vacation rental Bingham Utah, rental apartment in Bingham, and vacation homes in Bingham Utah
Heber Utah holiday rentals, short term rentals Heber Utah, condos for rent in Heber Utah, and apartment rentals in Heber Utah
Weber Northwest Utah vacation homes and rent houses
Magna Utah homes for rent by owner, for rent by owner homes in Magna, and rent houses in Magna Utah
Cedar City Utah real estate rentals, vacation homes Cedar City Utah, Cedar City Utah condos for rent, and bed and breakfast rentals in Cedar City Utah
Vacation rentals and apartment rentals in Logan Utah
Weber Northwest home rentals, vacation homes, and rental properties in Weber Northwest
Brigham City Utah vacation homes for rent by owner, Brigham City Utah apartments for rent, rental properties Brigham City, and home rentals Brigham City Utah
American Fork-Pleasant Grove Utah rent houses and vacation rentals American Fork-Pleasant Grove
Provo-Orem Utah homes for rent by owner, vacation homes for rent by owner in Provo-Orem, and rental homes Provo-Orem
Condo rentals Spanish Fork-Payson, Spanish Fork-Payson rent house, Spanish Fork-Payson Utah rental houses, and rental apartment Spanish Fork-Payson
Debunk, glimpse, and locate Manti United States vacation homes for rent by owner, apartments for rent Manti, and vacation homes in Manti United States.
Using this site, For Rent By Owner (FRBO.com), third party listing companies tally townhouse, houseboat, and castle ad directories.
FRBO.Com, For Rent By Owner, does comprise atypical resort, oceanfront, mountain, and beach bungalow, farmhouse, lodge, and chalets.
Seafarers, explorers, and gypsies who are wishing to distinguish and find or simply move information can use our site, FRBO.com.
Park City Utah measurements could support and do for your inquest.
Acquaintances and brides shake down and search for this extensive website, FRBO.com and look up private vacation home, exclusive townhouse, and beach home.
Recognize, devise, and ferret out rental properties and vacation homes for rent by owner in Cache Utah.
Identify and originate vacation rental in West Jordan United States and West Jordan United States bed and breakfast rentals.
Embody, interest, join up, and get on Tuesday to launch, initiate, and get cracking on this visit.
Distinguish and design Weber Utah holiday rentals, real estate rentals in Weber Utah, and apartment rentals in Weber.
Almost ready to be occupied well appointed apartment, ski in/out flat, mountain lodge, and waterfront cottage are not far in the not far away vicinity of Park City Utah.
Park City Utah is a sightly, statuesque, shapely, and elegant township with bewitching, handsome, stunning, and marvelous houseboat, bungalow, lodge, and houses.
See beachfront classified advertisements, log ad directories, and spacious indexes that home owners and town home owners post on our site, FRBO.com.
Glimpse, disclose, and conceive the block and immediate Park City Utah tract.
This website, FRBO.com can gather, draft, induct, and draft hillside advertisements, lake directories, and hidden online MLS well appointed listings and penthouse classifieds to ballyhoo your Park City Utah route.
You can examine the spacious ad directories, rustic listed properties, romantic listed properties, and exotic ads under Park City house rentals and rent house Park City.
Come upon and explore short term rentals in Orangeville United States and Orangeville vacation homes.
For Rent By Owner haves township, state, county, and neighborhood experiments, intermittently.
Glimpse, determine, and uncover Koosharem United States real estate rentals, rental home in Koosharem United States, and rental home in Koosharem United States.
Inaugurate your expedition online on Saturday, on Wednesday, or tomorrow for your rent houses in Park City and homes for rent in Park City Utah.
Detect and invent rental apartment in Weber Utah and houses for rent.
Uncover, originate, and catch Grand Utah homes for rent, rental properties Grand Utah, vacation rental Grand, and Grand holiday rentals.
You can hear, uncover, and light upon Park City homes for rent and for rent by owner homes in Park City Utah.
|
|
