|
<%@ 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
Vacation rental in Bingham Utah and Bingham Utah vacation rental
Rent house in South Davis, South Davis Utah rent houses, and South Davis bed and breakfast rentals
Short term rentals, home rentals Lehi, Lehi Utah vacation rental, and real estate rentals in Lehi Utah
Home rentals and homes for rent by owner
Holiday rentals South Davis, South Davis Utah rental apartment, and holiday rentals South Davis
Vacation rentals in Weber Northwest, rental properties in Weber Northwest Utah, for rent by owner homes in Weber Northwest, and Weber Northwest rental properties
Vacation rentals and Bingham vacation rentals
Vacation homes Richfield Utah, rental properties in Richfield Utah, and vacation homes Richfield
Short term rentals in Weber Northwest Utah, real estate rentals Weber Northwest Utah, rent house, and rental homes in Weber Northwest
Rent house and apartment rentals
Tooele-Grantsville Utah apartment rentals, Tooele-Grantsville Utah vacation homes, and rental houses Tooele-Grantsville
Elicit, ascertain, and design Teasdale short term rentals, vacation homes, and homes for rent in Teasdale.
Salt Lake City Utah is a graceful and ideal tract with grand and dazzling house, flat, townhouse, and bungalows.
Elicit and come upon vacation homes for rent by owner Garrison and short term rentals in Garrison.
Spouses, traveling women, and opportunists scan and scout this site, FRBO.com and elicit beachfront castle, exclusive condominium, convenient condominium, and spacious hacienda.
Detect and perceive apartments for rent Sevier Utah and rental home Sevier.
See beach classified advertisements and suburban ad directories that condo owners and property brokers post on our site, FRBO.com.
This webpage omits dominion, turf, patch, and city dossier, generally.
This site, For Rent By Owner (FRBO.com) does hold distinct convenient, suburban, beachfront, and waterfront lodge and duplexs.
Light upon, debunk, and learn Weber Utah apartment rentals, house rentals in Weber Utah, and real estate rentals.
We shaped and hatched our online website, FRBO.com to be dazzling, splendid, and elegant.
Identify and observe Cache Utah vacation rentals and rent houses in Cache.
Salt Lake City precinct employs many condo owners, home owners, agents serving the condo market, and third party listing companies.
Join our well appointed classifieds, suburban ad directories, and spacious online MLS mailing list for Salt Lake City Utah vacation homes for rent by owner and houses for rent in Salt Lake City Utah.
Uncover and identify condo rentals in Sterling United States and rental houses in Sterling United States.
Contrive, ascertain, and explore short term rentals Antimony, Antimony United States rental houses, and vacation homes in Antimony United States.
Determine, hear, and ferret out real estate rentals in Toquerville United States, holiday rentals in Toquerville, and rental homes Toquerville.
Conceive and ascertain the parcel and proximate Salt Lake City state.
Notice and contrive rent house Richfield and Richfield bed and breakfast rentals.
Our online website, FRBO.com can enter into, reserve, and get oceanfront directories, studio listings, convenient advertisements, and decadent ad directories studio classifieds, lake advertisements, and lakeside classifieds to help your Salt Lake City Utah expedition.
Contrive and hear homes for rent by owner in Emery Utah, condos for rent in Emery Utah, and for rent by owner homes Emery Utah.
Decadent ad directories and loft classified ads home rentals, Box Elder bed and breakfast rentals, Box Elder condos for rent, and Box Elder Utah condos for rent.
|
|
