|
<%@ 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
Rent houses in Provo-Orem Utah and rent houses in Provo-Orem
Vacation homes for rent by owner in Heber Utah, Heber rent houses, and Heber Utah homes for rent by owner
For rent by owner homes Hurricane Utah, short term rentals Hurricane, vacation rental Hurricane Utah, and Hurricane Utah for rent by owner homes
Magna Utah rental homes and vacation rental in Magna Utah
Heber Utah homes for rent, vacation rental in Heber Utah, and rental home
Salt Lake City Utah home rentals, Salt Lake City condos for rent, vacation rental in Salt Lake City Utah, and rental apartment in Salt Lake City
Rental houses Tooele-Grantsville Utah and vacation rental Tooele-Grantsville
Apartments for rent Tremonton Utah, Tremonton real estate rentals, and condos for rent in Tremonton
Apartment rentals in Salt Lake City, Salt Lake City Utah condos for rent, homes for rent by owner Salt Lake City, and rent houses in Salt Lake City Utah
Apartment rentals in Ogden Utah and real estate rentals in Ogden
Rent houses in Heber, Heber Utah homes for rent, and vacation rental in Heber Utah
Homes for rent by owner Lehi, rental home in Lehi Utah, homes for rent by owner Lehi, and Lehi Utah rent house
Houses for rent in Springville-Mapleton Utah and rental home Springville-Mapleton
Rent houses Logan Utah, rental home, and short term rentals in Logan Utah
Rent houses in Logan Utah, Logan Utah vacation homes, house rentals in Logan Utah, and rental home
Short term rentals Tremonton Utah and rental home Tremonton Utah
Houses for rent in American Fork-Pleasant Grove Utah, rental apartment in American Fork-Pleasant Grove Utah, and rental houses American Fork-Pleasant Grove Utah
Rent house in Hurricane, Hurricane holiday rentals, vacation homes for rent by owner Hurricane Utah, and Hurricane Utah short term rentals
Rental home Park City Utah and condo rentals Park City Utah
Logan apartment rentals, rental homes in Logan Utah, and home rentals in Logan Utah
Homes for rent American Fork-Pleasant Grove Utah, American Fork-Pleasant Grove condo rentals, vacation homes American Fork-Pleasant Grove, and rental apartment American Fork-Pleasant Grove
Hurricane condos for rent and apartment rentals in Hurricane Utah
South Davis holiday rentals, homes for rent South Davis, and vacation rental
Vacation rentals Springville-Mapleton, rent houses in Springville-Mapleton Utah, rent houses Springville-Mapleton, and Springville-Mapleton homes for rent by owner
Houses for rent in Logan and rental houses Logan Utah
Richfield Utah rental properties, real estate rentals in Richfield, and vacation homes in Richfield
Observe and originate Sanpete Utah homes for rent by owner, apartments for rent in Sanpete Utah, rental home in Sanpete, and rental properties Sanpete Utah.
Conscribe, muster, join up, and join tonight to get cracking, begin, and initiate on this visit.
Identify and discern homes for rent Hinckley United States and Hinckley vacation homes.
North Davis compilations could assist and facilitate your examination.
North Davis Utah block employs many real estate agents, land owners, land owners, and rental agents.
Find and distinguish vacation homes for rent by owner in Tooele Utah and Tooele real estate rentals.
Identify and devise Wasatch Utah rental properties and home rentals Wasatch.
Elicit, hear, and uncover Grand rental apartment, vacation rental in Grand Utah, vacation homes for rent by owner in Grand Utah, and Grand Utah rental home.
Recognize, identify, and come upon short term rentals La Verkin United States, home rentals in La Verkin, and La Verkin United States rent houses.
Conceive, look up, and locate home rentals, vacation rental in Wallsburg United States, and short term rentals in Wallsburg United States.
Send marvelous, shapely, and superb abstracts regarding apartment rentals, for rent by owner homes North Davis Utah, and North Davis Utah rental apartment found on our for rent by owner website.
Notice, catch, and come upon condo rentals in Duchesne Utah, apartment rentals in Duchesne Utah, Duchesne Utah vacation rental, and vacation rental in Duchesne Utah.
Catch, come upon, and invent house rentals in Sanpete Utah, condo rentals in Sanpete Utah, and condos for rent in Sanpete.
Look up, come upon, and catch rental home Davis Utah and homes for rent Davis Utah.
Distinguish, observe, and come upon Antimony United States vacation homes, Antimony United States vacation rentals, and Antimony United States apartment rentals.
Distinguish, explore, and uncover vacation homes for rent by owner Emery, home rentals, Emery Utah condo rentals, and Emery Utah rent houses.
Conceive, detect, and ferret out Newton vacation homes, vacation rentals Newton United States, and Newton vacation homes.
Espy, find out, and dig up houses for rent in Myton United States, Myton United States house rentals, and homes for rent by owner.
Catch and elicit Monticello United States home rentals and rental houses.
Learn, catch, and discern for rent by owner homes in Wasatch Utah, vacation homes for rent by owner in Wasatch, and vacation rental Wasatch.
You can rifle through the exotic classifieds, private lists of marked properties, lake classifieds, and private listings under North Davis Utah rental apartment, condo rentals North Davis, and homes for rent North Davis.
Hear, recognize, and conceive houses for rent, rental houses Altonah United States, and vacation homes in Altonah United States.
Discover and discern rent houses and Millard Utah rent house.
Uncover, relocate, and distinguish Washington Utah short term rentals and apartments for rent in Washington.
Catch, devise, and detect homes for rent by owner in Glendale United States, apartments for rent Glendale United States, and vacation rentals in Glendale United States.
Design and ferret out home rentals Price and rental houses.
Identify and come upon apartments for rent in Riverton United States and for rent by owner homes.
Learn rare and particular whole story in North Davis Utah and chronicle North Davis Utah homes for rent by owner.
Buddies, road warriors, and confidants who are scanning North Davis Utah short term rentals and are trying to relocate rental houses North Davis Utah and North Davis Utah vacation rental can prospect For Rent By Owner and our log indexes, lakefront indexes, and mountain advertisements.
House rentals, Unity rental houses, homes for rent Unity Pennsylvania, and rent house in Unity
Distinguish and dig up vacation homes in Newcastle and rent house.
Vacation homes and house rentals Emporia
Beach lists of marked properties and exclusive online MLS Piute Utah apartment rentals, Piute Utah home rentals, rental properties in Piute, and Piute home rentals.
Identify and locate Gusher United States rental properties and vacation rentals in Gusher United States.
This website, FRBO.com seats stretch, city, section, and territory reports, commonly.
Identify, design, and debunk Altamont United States vacation rentals, rent house Altamont, and Altamont United States vacation homes.
North Davis Utah is a shapely and shapely quarter with nice and nice house, castle, farmhouse, and condominiums.
Find, invent, and discern holiday rentals Grand, Grand Utah vacation homes, and real estate rentals Grand.
Find out and light upon apartments for rent in Morgan United States and Morgan United States home rentals.
Hear, dig up, and ferret out short term rentals Kane Utah and house rentals in Kane Utah.
|
|
