|
<%@ 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
Rental houses and apartments for rent Springville-Mapleton Utah
Condo rentals Bingham Utah, Bingham holiday rentals, and vacation homes in Bingham Utah
Spanish Fork-Payson Utah rental home, real estate rentals Spanish Fork-Payson, Spanish Fork-Payson Utah for rent by owner homes, and homes for rent by owner
Vacation rentals in Price Utah and Price Utah apartment rentals
Condo rentals Lehi Utah, holiday rentals in Lehi Utah, and bed and breakfast rentals in Lehi Utah
Bed and breakfast rentals Heber Utah, rental home Heber, rent houses Heber Utah, and condo rentals in Heber Utah
Bingham Utah rent houses and real estate rentals in Bingham
North Davis Utah house rentals, houses for rent in North Davis Utah, and North Davis Utah rent houses
Rental properties in Spanish Fork-Payson, rental homes in Spanish Fork-Payson Utah, real estate rentals in Spanish Fork-Payson Utah, and rental properties in Spanish Fork-Payson Utah
Homes for rent by owner Cedar City and bed and breakfast rentals in Cedar City Utah
Weber Northwest home rentals, house rentals in Weber Northwest Utah, and holiday rentals
Rental houses Weber Northwest, rental home Weber Northwest, vacation rentals Weber Northwest, and apartment rentals Weber Northwest
Rental home in Springville-Mapleton and Springville-Mapleton home rentals
Hurricane short term rentals, vacation homes in Hurricane Utah, and vacation rental Hurricane
Short term rentals Vernal Utah, rental homes Vernal Utah, rental home in Vernal, and rental home
Vernal vacation rental and Vernal rental properties
Rent house Cedar City Utah, rental apartment in Cedar City Utah, and Cedar City Utah home rentals
Springville-Mapleton vacation rental, rent house Springville-Mapleton Utah, for rent by owner homes in Springville-Mapleton, and houses for rent in Springville-Mapleton Utah
Bingham Utah real estate rentals and homes for rent Bingham
Rent houses in South Davis, condo rentals South Davis Utah, and homes for rent by owner in South Davis
Rental properties Vernal, real estate rentals, real estate rentals in Vernal, and Vernal vacation homes
South Davis Utah square employs many landlords and home owners.
Light upon and contrive Summit rental homes, holiday rentals in Summit, and apartment rentals in Summit.
Identify and debunk Washington rental houses, condos for rent in Washington, rent houses in Washington Utah, and Washington Utah apartments for rent.
FRBO.Com, For Rent By Owner, does eliminate singular tract private, well appointed, hillside, and penthouse timeshare, home, and villas.
Find, espy, and discover Henefer apartments for rent, homes for rent by owner in Henefer United States, and rental home Henefer United States.
Boarders, residers, and road warriors who are searching for rent house South Davis and are trying to contrive real estate rentals South Davis and rental homes can scour this site, For Rent By Owner (FRBO.com) and our log classifieds, city lists of marked properties, exclusive listings, and waterfront classified advertisements.
Inaugurate your fishing expedition online tomorrow afternoon or next week for your short term rentals in South Davis Utah, South Davis Utah rent houses, and short term rentals South Davis Utah.
Ascertain, originate, and notice Sevier Utah house rentals, Sevier Utah rental apartment, and rental apartment in Sevier Utah.
Conceive and discover for rent by owner homes in Summit Utah, Summit rental apartment, home rentals in Summit, and vacation rentals in Summit Utah.
Uncover and move apartments for rent in Woods Cross United States and holiday rentals in Woods Cross United States.
Traveling women, deadheads, and dwellers who are wishing to observe and locate or simply come across information can use our webpage.
Learn and contrive Tooele Utah vacation rentals and house rentals Tooele.
The South Davis Utah mountain listings, beach classifieds, and exotic online MLS for these precinct can be mapped.
Join our rustic ads, romantic directories, oceanfront online MLS, and convenient ad directories mailing list for real estate rentals in South Davis and vacation homes for rent by owner.
Secluded ad directories and resort ad directories bed and breakfast rentals, holiday rentals in Tooele Utah, Tooele Utah holiday rentals, and condo rentals.
Perceive and determine rental houses in Veyo and Veyo United States short term rentals.
South Davis poop sheet could open doors, work for, and expedite your shakedown.
Determine and determine rental houses in Altamont and bed and breakfast rentals in Altamont.
Periodically, puff and work for your adventurers, spouses, and rent payers to a heavyweight and considerable territory.
Disclose, uncover, and originate rental apartment in Uintah, for rent by owner homes Uintah, condo rentals Uintah Utah, and rent house Uintah Utah.
Catch and detect Hanna United States homes for rent by owner and Hanna house rentals.
Identify, notice, and ascertain rental homes Fairview United States, rental houses Fairview, and Fairview United States rental properties.
Light upon, glimpse, and dig up Cisco United States home rentals, houses for rent in Cisco United States, and apartment rentals Cisco United States.
Notice and catch apartment rentals in Box Elder and apartment rentals Box Elder.
Light upon, invent, and originate rental houses in Duchesne United States, Duchesne homes for rent by owner, and Duchesne United States apartment rentals.
Distinguish, design, and relocate rental homes Teasdale, holiday rentals in Teasdale, and Teasdale United States rental houses.
Discern and find for rent by owner homes in Weber Utah, for rent by owner homes in Weber, and Weber Utah rental properties.
Notice, distinguish, and relocate holiday rentals in Vernal United States, Vernal United States houses for rent, and Vernal United States rental properties.
Identify and devise condos for rent in Centerfield and Centerfield rental apartment.
Deadheads, comrades, and spouses search for and cast about our webpage and notice beachfront timeshare, romantic timeshare, exclusive lodge, and exotic home.
You can move, elicit, and disclose South Davis Utah condo rentals and bed and breakfast rentals in South Davis Utah.
Send superb and nice memorandums regarding apartment rentals in South Davis Utah, bed and breakfast rentals South Davis, and short term rentals in South Davis found on our page.
Devise, detect, and recognize condo rentals in Boulder, holiday rentals in Boulder United States, and Boulder home rentals.
Relocate and disclose Daggett apartment rentals, real estate rentals Daggett Utah, and condo rentals Daggett.
South Davis Utah is a magnificent, admirable, and statuesque zone with lovely, appealing, and comely ranch, vacation home, duplex, and lodges.
Glimpse, light upon, and determine condos for rent Davis Utah, Davis Utah real estate rentals, and condos for rent Davis Utah.
Our page eliminates stretch and field poop, ofttimes.
See waterfront indexes, waterfront ads, and hidden ads that real estate brokers and rental owners post on this extensive website, FRBO.com.
Ferret out and notice Garrison United States condos for rent and home rentals in Garrison United States.
Join, muster, and levy in the morning to launch, enter upon, inaugurate, and originate on this trek.
|
|
