|
<%@ 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
Homes for rent by owner in Springville-Mapleton Utah and rental homes in Springville-Mapleton Utah
Springville-Mapleton rental home, Springville-Mapleton Utah rental properties, and Springville-Mapleton Utah houses for rent
Houses for rent in Tooele-Grantsville Utah, rent houses in Tooele-Grantsville Utah, condo rentals in Tooele-Grantsville Utah, and holiday rentals
South Davis vacation homes for rent by owner and South Davis vacation rentals
Spanish Fork-Payson vacation homes for rent by owner, Spanish Fork-Payson Utah apartment rentals, and vacation homes in Spanish Fork-Payson Utah
Springville-Mapleton Utah holiday rentals, Springville-Mapleton Utah rental houses, houses for rent Springville-Mapleton Utah, and rental properties in Springville-Mapleton Utah
Provo-Orem Utah vacation rentals and Provo-Orem Utah rental home
Rental houses Hurricane Utah, vacation rental, and rental home Hurricane
Park City home rentals, bed and breakfast rentals Park City Utah, holiday rentals Park City Utah, and Park City Utah vacation homes
Rental homes in Bingham Utah and rental apartment in Bingham Utah
Vacation homes for rent by owner in Provo-Orem Utah, vacation rentals in Provo-Orem Utah, and house rentals in Provo-Orem Utah
Apartments for rent, rent houses in Ogden Utah, Ogden Utah rental houses, and bed and breakfast rentals Ogden
Roosevelt rental properties and condo rentals in Roosevelt Utah
House rentals, rental properties Lehi Utah, and vacation rentals in Lehi Utah
Holiday rentals in South Davis Utah, apartments for rent South Davis Utah, South Davis rental home, and South Davis Utah for rent by owner homes
Park City Utah condos for rent and bed and breakfast rentals
Real estate rentals, Richfield Utah condos for rent, and Richfield Utah rental homes
Roosevelt bed and breakfast rentals, holiday rentals in Roosevelt Utah, Roosevelt rental houses, and rental apartment
Holiday rentals and holiday rentals Brigham City
Uncover, look up, and originate Millard Utah homes for rent by owner and Millard bed and breakfast rentals.
Come across, contrive, and explore rental homes in Ephraim, rental houses Ephraim United States, and Ephraim United States vacation rental.
Light upon and explore Sevier Utah short term rentals, vacation homes for rent by owner in Sevier Utah, rental houses in Sevier Utah, and rental properties in Sevier Utah.
Debunk, catch, and elicit bed and breakfast rentals Uintah and for rent by owner homes in Uintah Utah.
Come across, come upon, and explore San Juan Utah condo rentals, condo rentals in San Juan, rental apartment, and home rentals San Juan Utah.
Originate, design, and locate vacation rental Gunnison United States, bed and breakfast rentals in Gunnison United States, and Gunnison United States rental houses.
Glimpse, relocate, and originate vacation rentals in Sterling, vacation rentals Sterling United States, and real estate rentals in Sterling.
Conceive several, another story, diverse, and specialized goods in American Fork-Pleasant Grove Utah and set down rental homes.
American Fork-Pleasant Grove agents serving the condo market and rental property owners list vacation rental in American Fork-Pleasant Grove, rental home, and apartments for rent American Fork-Pleasant Grove Utah.
Students and troupers run down, scout, and search for this extensive website, FRBO.com and observe exclusive duplex, log lodge, lakeside vacation home, and lakefront vacation home.
Originate and catch house rentals in Roy United States and Roy United States real estate rentals.
Come across, uncover, and move vacation rentals, houses for rent in Oak City United States, and for rent by owner homes in Oak City.
Distinguish and contrive Green River United States rental properties and condos for rent Green River United States.
Conceive and come upon vacation rental, homes for rent by owner in Utah Utah, and rent houses in Utah.
Glimpse and come upon Smithfield rental properties and Smithfield vacation homes for rent by owner.
Espy and perceive rental apartment Washington United States and Washington United States rental homes.
Hear and devise houses for rent and homes for rent by owner in Summit United States.
You can smell around the exotic listings, exclusive ad directories, and convenient classifieds under rent house, bed and breakfast rentals American Fork-Pleasant Grove Utah, and rental homes in American Fork-Pleasant Grove.
Identify and contrive home rentals in Park Valley United States and Park Valley vacation homes for rent by owner.
Explore and observe Rich vacation homes, Rich bed and breakfast rentals, and Rich Utah condos for rent.
Recently available beach flat, lakefront ranch, and beach apartment are adjoining in the nearly principality of American Fork-Pleasant Grove Utah.
This site, For Rent By Owner (FRBO.com) can procure, assign, and hitch beach indexes, lake advertisements, spacious ad directories, and studio listed properties secluded ads, exotic advertisements, ski in/out lists of marked properties, and loft directories to expedite your American Fork-Pleasant Grove Utah hike.
Identify, uncover, and notice Duchesne Utah apartments for rent, condo rentals Duchesne Utah, and rental apartment in Duchesne Utah.
Dig up and ferret out vacation homes for rent by owner Piute Utah, apartments for rent Piute, and for rent by owner homes Piute Utah.
Beachfront classified ads and beachfront online MLS homes for rent by owner, Uintah Utah apartment rentals, Uintah Utah rental properties, and Uintah Utah house rentals.
American Fork-Pleasant Grove parcel employs many agents serving the condo market, property brokers, and landlords.
|
|
