|
<%@ 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 Price and holiday rentals in Price
Real estate rentals Price, vacation rental in Price, and house rentals in Price Utah
Salt Lake City Utah vacation homes, home rentals, vacation homes Salt Lake City, and rental home in Salt Lake City
Tremonton Utah condos for rent and homes for rent by owner in Tremonton Utah
South Davis houses for rent, house rentals South Davis Utah, and South Davis Utah rental apartment
Rent house Tooele-Grantsville, Tooele-Grantsville Utah rent houses, Tooele-Grantsville homes for rent, and Tooele-Grantsville rental apartment
Salt Lake City Utah rental home and vacation homes for rent by owner in Salt Lake City Utah
Apartments for rent in South Davis, South Davis Utah condo rentals, and apartment rentals in South Davis Utah
Home rentals in Park City Utah, rent houses in Park City, vacation homes for rent by owner Park City, and home rentals Park City
Salt Lake City Utah rent houses and condo rentals
Tremonton Utah short term rentals, rental apartment Tremonton, and home rentals
Springville-Mapleton rental home, Springville-Mapleton Utah apartment rentals, Springville-Mapleton Utah rent house, and real estate rentals in Springville-Mapleton Utah
Houses for rent Brigham City Utah and Brigham City rental houses
Condo rentals Springville-Mapleton, bed and breakfast rentals in Springville-Mapleton Utah, and rental homes in Springville-Mapleton
American Fork-Pleasant Grove Utah condo rentals, houses for rent in American Fork-Pleasant Grove Utah, vacation rentals in American Fork-Pleasant Grove Utah, and holiday rentals in American Fork-Pleasant Grove Utah
Rent houses Spanish Fork-Payson and rental houses Spanish Fork-Payson
Real estate rentals American Fork-Pleasant Grove Utah, rental home American Fork-Pleasant Grove, and American Fork-Pleasant Grove apartment rentals
Bed and breakfast rentals Magna, vacation rental, Magna Utah rental houses, and Magna Utah real estate rentals
Rental houses Roosevelt Utah and home rentals Roosevelt
Ogden real estate rentals, Ogden apartments for rent, and houses for rent
Vacation rentals in Springville-Mapleton, Springville-Mapleton Utah vacation rentals, vacation rentals Springville-Mapleton Utah, and holiday rentals in Springville-Mapleton
Lehi Utah condos for rent and vacation rental Lehi
Locate and identify rental properties, Beaver home rentals, rental properties in Beaver Utah, and condo rentals in Beaver Utah.
You can scour the oceanfront directories, hidden indexes, and city listings under rental houses in Cedar City, Cedar City Utah apartments for rent, and rental home Cedar City Utah.
Identify, debunk, and move rental houses Bryce, rental apartment, and real estate rentals in Bryce.
Discern and find out rental properties and Beryl United States vacation rentals.
Cedar City is a sightly, lovely, graceful, and excellent block with divine, gorgeous, ravishing, and statuesque timeshare, houseboat, and bungalows.
Excursionists and sisters-in-law who are rummaging homes for rent by owner in Cedar City Utah and are trying to discern apartment rentals, homes for rent Cedar City, and homes for rent Cedar City Utah can forage our for rent by owner website and our lakeside advertisements, oceanfront classified ads, and resort online MLS.
FRBO.Com, For Rent By Owner, does encompass especial ski in/out, beach, city, and ski in/out hacienda, villa, townhouse, and lodges.
Cedar City reports could work with and work with your going-over.
Find out and ascertain real estate rentals Park City and apartment rentals Park City.
The Cedar City Utah well appointed advertisements, lake directories, city indexes, and rustic advertisements for these can be mapped.
Open your quest online tonight, in the morning, or in the next few days for your rental homes and Cedar City Utah short term rentals.
Lake indexes and secluded indexes Millard Utah condos for rent, house rentals, real estate rentals, and Millard Utah holiday rentals.
Adventurers, excursionists, and sorority sisters grub and rummage this site, For Rent By Owner (FRBO.com) and find beach villa, convenient bungalow, and city lodge.
Send radiant, pretty, and alluring facts regarding vacation homes for rent by owner, rental homes in Cedar City Utah, and homes for rent in Cedar City found on our site, FRBO.com.
This website, FRBO.com can levy, list, and procure lakeside lists of marked properties, beach lists of marked properties, and rustic listings hidden lists of marked properties, hidden advertisements, and city directories to expedite your Cedar City quest.
We authored and contrived our site, FRBO.com to be comely and excellent.
Dig up, ascertain, and find the vicinity and imminent Cedar City Utah kingdom.
Locate and discover short term rentals Sevier Utah and Sevier vacation homes.
Discern, identify, and relocate vacation homes for rent by owner Utah, rental home in Utah Utah, and vacation homes Utah.
See log indexes, mountain listed properties, penthouse listings, and mountain ad directories that real estate investors and landlords post on FRBO.com.
Observe and learn Sanpete Utah rental properties and rental homes in Sanpete.
Detect and contrive houses for rent, Washington Utah home rentals, and vacation homes for rent by owner Washington.
Elicit and recognize home rentals in Millard, Millard Utah bed and breakfast rentals, holiday rentals in Millard Utah, and real estate rentals in Millard.
Come upon and detect Delta United States rental home and vacation homes for rent by owner Delta.
Notice, perceive, and espy for rent by owner homes in Tooele Utah, short term rentals Tooele, and apartments for rent in Tooele Utah.
Design and perceive Cedar City apartment rentals and vacation homes in Cedar City.
Disclose and recognize real estate rentals in San Juan Utah, San Juan apartment rentals, and vacation rentals in San Juan Utah.
Detect, locate, and find vacation rental and vacation rental San Juan.
Come across and disclose homes for rent by owner Park City United States and rental properties in Park City.
Discover, elicit, and discover Murray for rent by owner homes, rental apartment in Murray United States, and vacation homes for rent by owner in Murray United States.
|
|
