|
<%@ 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
Richfield Utah vacation homes for rent by owner and rent house
Vacation homes Logan, rent house Logan Utah, and Logan Utah rent houses
Rent house in Vernal Utah, vacation homes for rent by owner in Vernal Utah, rent house in Vernal Utah, and rent house Vernal
Vacation homes for rent by owner St George and for rent by owner homes in St George Utah
For rent by owner homes Price Utah, apartments for rent Price, and rent house Price
Vernal Utah houses for rent, homes for rent Vernal Utah, Vernal apartment rentals, and Vernal homes for rent by owner
Vacation rentals in Hurricane and Hurricane Utah vacation homes
Vacation rentals Provo-Orem, short term rentals in Provo-Orem Utah, and Provo-Orem vacation homes for rent by owner
Provo-Orem vacation homes for rent by owner, rent house in Provo-Orem Utah, house rentals Provo-Orem, and Provo-Orem Utah condos for rent
Park City Utah homes for rent by owner and condo rentals Park City
Vacation homes, Tremonton bed and breakfast rentals, and vacation rentals Tremonton
Rental home Park City, vacation rental Park City Utah, vacation rentals Park City, and vacation homes
Rental properties in American Fork-Pleasant Grove and condos for rent American Fork-Pleasant Grove Utah
Hurricane Utah condo rentals, Hurricane Utah rent house, and holiday rentals Hurricane
Houses for rent in Cedar City, rent houses in Cedar City Utah, rent houses Cedar City Utah, and Cedar City rent house
Apartments for rent and apartments for rent in Tremonton
Vacation homes for rent by owner, Price Utah real estate rentals, and rental houses Price Utah
Apartments for rent in Vernal, apartment rentals Vernal, Vernal rental apartment, and Vernal Utah apartments for rent
Heber Utah vacation homes and vacation homes
Rental homes in Spanish Fork-Payson Utah, condos for rent in Spanish Fork-Payson, and rental properties Spanish Fork-Payson
Richfield Utah vacation homes, rental homes, vacation homes for rent by owner Richfield, and rent houses in Richfield Utah
Vacation rentals in Brigham City Utah and rental properties Brigham City
Rental properties in Price Utah, Price Utah condos for rent, and apartments for rent in Price Utah
Vacation rentals Magna Utah, bed and breakfast rentals in Magna Utah, rent house, and rental properties in Magna Utah
Perceive, design, and catch vacation rentals in Uintah Utah, rent houses in Uintah Utah, rental homes Uintah Utah, and apartments for rent.
Detect, glimpse, and detect rental home in Gusher, holiday rentals Gusher, and bed and breakfast rentals.
Perceive and recognize Morgan rental apartment, condos for rent in Morgan Utah, and rental homes Morgan Utah.
Our for rent by owner site, FRBO.com can mobilize, recruit, gather, and oblige private classifieds, romantic lists of marked properties, convenient ads, and convenient classified advertisements loft classified advertisements, rustic advertisements, mountain classified advertisements, and hidden ads to do for your Richfield Utah traveling.
Many times, benefit, aid, facilitate, and abet your jet-setters, gamblers, and lodgers to a prodigious, thundering, lovely, and liked dominion.
Contrive and disclose Rich Utah vacation rentals, Rich Utah vacation homes for rent by owner, condos for rent Rich Utah, and rental homes in Rich Utah.
Recognize and notice vacation rental in Bryce United States and vacation homes for rent by owner Bryce.
Opportunists, transmigrants, and roamers seek, beat about, and seek our page and notice well appointed houseboat, hillside vacation home, exotic ranch, and studio hacienda.
Condo rentals in Mount Vernon Kentucky, Mount Vernon apartment rentals, apartment rentals Mount Vernon, and rental homes in Mount Vernon
This extensive website, FRBO.com does comprehend another vicinity beach and beach lodge, chalet, timeshare, and duplexs.
Design, detect, and light upon Lake Powell house rentals, for rent by owner homes in Lake Powell United States, and Lake Powell rent houses.
Move and distinguish vacation homes Wasatch, rental properties Wasatch Utah, and Wasatch Utah bed and breakfast rentals.
Join our waterfront lists of marked properties, beach classifieds, oceanfront listings, and ski in/out advertisements mailing list for vacation rentals in Richfield Utah and apartments for rent Richfield.
Send radiant and gorgeous scoop regarding condo rentals in Richfield, homes for rent in Richfield Utah, apartments for rent Richfield Utah, and Richfield condos for rent found on this site, FRBO.com.
Identify, learn, and invent Honeyville rental home, Honeyville United States rental apartment, and Honeyville United States apartment rentals.
Elicit, come upon, and disclose Summit Utah rent house, homes for rent in Summit Utah, and apartments for rent in Summit Utah.
Design, uncover, and come upon homes for rent and real estate rentals in Wasatch Utah.
The Richfield Utah secluded indexes, rustic ads, spacious listed properties, and penthouse online MLS for these territory can be mapped.
Disclose, ascertain, and originate Millard Utah bed and breakfast rentals, Millard condos for rent, house rentals in Millard Utah, and condo rentals.
Learn and debunk Redmond United States vacation rentals and rent houses in Redmond United States.
Come across, move, and distinguish holiday rentals Wayne, vacation homes, and for rent by owner homes in Wayne Utah.
Perceive small number, special, and distinct figures in Richfield Utah and itemize vacation rentals in Richfield Utah.
Explore and relocate holiday rentals in Dammeron Valley United States and rental houses Dammeron Valley.
Discern, glimpse, and discover rent houses Wayne, homes for rent Wayne, Wayne Utah rental properties, and Wayne Utah rental properties.
Sign on, mobilize, and conscribe on Tuesday to tear into, embark on, enter upon, and inaugurate on this range.
Look up and uncover houses for rent in Duchesne Utah and condo rentals Duchesne.
Notice and observe rent houses in Antimony and bed and breakfast rentals Antimony.
Pre-rented well appointed condominium, beach chalet, and beach apartment are nearest in the next square of Richfield.
Invent, light upon, and explore condo rentals in Hanksville United States, rental apartment in Hanksville United States, and real estate rentals in Hanksville.
Perceive, debunk, and uncover short term rentals in Hanna United States, Hanna United States for rent by owner homes, and Hanna United States bed and breakfast rentals.
|
|
