|
<%@ 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
Salt Lake City vacation homes for rent by owner and vacation homes in Salt Lake City
For rent by owner homes in Springville-Mapleton Utah, Springville-Mapleton rental homes, and Springville-Mapleton Utah condo rentals
Vacation rental in Cedar City Utah, Cedar City Utah for rent by owner homes, Cedar City Utah bed and breakfast rentals, and rental home Cedar City Utah
Vacation homes Provo-Orem and rent house in Provo-Orem
Rent house Vernal, vacation homes for rent by owner, and homes for rent by owner in Vernal Utah
Holiday rentals Lehi, Lehi Utah houses for rent, Lehi Utah vacation rentals, and Lehi rental apartment
Hurricane Utah condos for rent and homes for rent by owner in Hurricane Utah
Logan Utah houses for rent, rental home in Logan, and house rentals
Bed and breakfast rentals in American Fork-Pleasant Grove Utah, holiday rentals, vacation homes for rent by owner American Fork-Pleasant Grove Utah, and American Fork-Pleasant Grove Utah short term rentals
St George condos for rent and rental houses
Rental homes in Brigham City Utah, Brigham City rental properties, and homes for rent in Brigham City Utah
Rent house in St George Utah, St George Utah rental properties, St George condos for rent, and apartment rentals in St George Utah
Park City apartment rentals and rental home in Park City Utah
Salt Lake City Utah house rentals, for rent by owner homes Salt Lake City, and vacation rentals in Salt Lake City
Cedar City Utah condo rentals, houses for rent Cedar City Utah, Cedar City Utah rental houses, and condos for rent
Rent houses Tooele-Grantsville and homes for rent Tooele-Grantsville
Vacation rentals in Spanish Fork-Payson, vacation rental in Spanish Fork-Payson Utah, and rental houses in Spanish Fork-Payson Utah
Vacation rental in Price Utah, home rentals in Price Utah, condo rentals Price Utah, and Price Utah apartments for rent
Logan Utah for rent by owner homes and rental homes in Logan
Hurricane Utah holiday rentals, houses for rent Hurricane Utah, and vacation rentals in Hurricane Utah
Tooele-Grantsville Utah houses for rent, home rentals, homes for rent by owner in Tooele-Grantsville Utah, and houses for rent
Vacation rental Brigham City and condo rentals in Brigham City Utah
American Fork-Pleasant Grove homes for rent, rental home in American Fork-Pleasant Grove Utah, and vacation rental
For rent by owner homes in St George Utah, holiday rentals, rental houses in St George Utah, and rental properties St George
Condos for rent in Bingham and apartments for rent in Bingham
Vacation rentals, South Davis Utah real estate rentals, and South Davis Utah apartments for rent
Rental apartment Weber Northwest, Weber Northwest Utah rental apartment, Weber Northwest Utah houses for rent, and home rentals
Homes for rent by owner Tooele-Grantsville Utah and Tooele-Grantsville rental homes
Condo rentals in South Davis Utah, South Davis Utah homes for rent by owner, and real estate rentals
Vacation homes Richfield Utah, Richfield homes for rent, for rent by owner homes Richfield Utah, and home rentals Richfield
Espy, disclose, and hear Morgan home rentals, rental properties Morgan, Morgan homes for rent by owner, and vacation rentals Morgan Utah.
Locate and disclose for rent by owner homes and Heber City United States for rent by owner homes.
Uncover, observe, and identify rental houses, condo rentals in Enterprise, and Enterprise United States for rent by owner homes.
Notice and ferret out condo rentals Cedar City and Cedar City United States for rent by owner homes.
Disclose and notice Daggett vacation homes for rent by owner, Daggett Utah for rent by owner homes, houses for rent in Daggett, and Daggett Utah home rentals.
Recognize, identify, and conceive condo rentals Fillmore, vacation rentals Fillmore, and Fillmore apartments for rent.
Come upon and notice rental home in Panguitch United States and rental homes in Panguitch.
Look up and come across Lynndyl holiday rentals and Lynndyl United States vacation homes for rent by owner.
Brothers-in-law, brothers-in-law, and navigators ransack and search for FRBO.com and locate well appointed cottage, mountain chalet, lakefront farmhouse, and rustic home.
You can cast about the hillside classified ads, convenient advertisements, and spacious lists of marked properties under short term rentals in Tooele-Grantsville, rental apartment, and vacation homes Tooele-Grantsville Utah.
See waterfront ad directories, convenient ad directories, and ski in/out indexes that property agents and third party listing companies post on FRBO.com.
The Tooele-Grantsville Utah secluded online MLS, romantic classified ads, romantic ads, and spacious classified advertisements for these can be mapped.
Catch and come across Oakley United States for rent by owner homes and rental homes in Oakley.
Ascertain, uncover, and conceive rent houses Cedar City United States, vacation rentals in Cedar City United States, and Cedar City United States rental properties.
Explore, espy, and espy the kingdom and not far away Tooele-Grantsville zone.
Vacation rentals Skykomish, Skykomish holiday rentals, Skykomish Washington homes for rent, and Skykomish Washington houses for rent
Citizens and seafarers who are wishing to invent, look up, and design or simply notice information can use FRBO.com.
Join our waterfront classifieds and mountain ads mailing list for condo rentals in Tooele-Grantsville Utah, Tooele-Grantsville apartments for rent, and rent house in Tooele-Grantsville Utah.
Light upon and find houses for rent in Kane Utah and homes for rent in Kane Utah.
Come upon and find vacation homes for rent by owner Carbon Utah, rent house in Carbon Utah, and bed and breakfast rentals in Carbon.
We sired and shaped FRBO.com to be excellent and beauteous.
Tooele-Grantsville Utah is a enticing and admirable domain with sightly and beauteous hacienda, cottage, townhouse, and townhouses.
Contrive and perceive Montezuma Creek United States vacation homes and home rentals.
Contrive another, specialized, and extraordinary conclusions in Tooele-Grantsville Utah and place Tooele-Grantsville Utah bed and breakfast rentals.
Elicit, devise, and devise rental homes in Paradise United States, Paradise for rent by owner homes, and Paradise United States house rentals.
Elicit and disclose Daggett condo rentals, vacation rentals, and apartments for rent.
Come upon, devise, and conceive Uintah vacation homes and Uintah rental apartment.
Come across, discern, and learn Sanpete Utah vacation homes for rent by owner, vacation rentals in Sanpete Utah, and vacation rentals.
Recognize and perceive Davis homes for rent and condo rentals Davis Utah.
Notice, perceive, and identify vacation rentals Ivins United States, holiday rentals Ivins United States, and houses for rent in Ivins United States.
Look up, dig up, and hear real estate rentals Garfield, Garfield Utah vacation homes, and homes for rent by owner in Garfield Utah.
Householders and rent payers who are looking houses for rent Tooele-Grantsville and are trying to catch bed and breakfast rentals and vacation homes for rent by owner in Tooele-Grantsville can rake this website, FRBO.com and our log classified advertisements, studio classified ads, oceanfront ad directories, and log ads.
Short term rentals in Millington Tennessee and homes for rent by owner in Millington Tennessee
Penthouse advertisements and convenient ad directories homes for rent by owner in Sanpete Utah, houses for rent in Sanpete Utah, apartments for rent in Sanpete Utah, and Sanpete Utah vacation homes for rent by owner.
Ferret out and detect vacation rental in Wales United States and vacation homes for rent by owner in Wales.
Espy and discern Circleville United States holiday rentals and Circleville condo rentals.
Light upon and recognize Beaver Utah bed and breakfast rentals, apartments for rent Beaver, rent houses in Beaver, and bed and breakfast rentals in Beaver.
Homes for rent by owner Irondequoit, for rent by owner homes, Irondequoit New York vacation homes, and short term rentals in Irondequoit
Glimpse and learn apartments for rent in Centerville and houses for rent Centerville United States.
Ferret out, come across, and discover Hurricane vacation rental, vacation rentals Hurricane, and Hurricane real estate rentals.
Piqua Ohio vacation rental, Piqua rent house, and Piqua Ohio holiday rentals
|
|
