|
<%@ 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
Magna rent house and homes for rent by owner Magna Utah
St George Utah rental properties, rent house in St George Utah, and St George condo rentals
Heber homes for rent, Heber apartments for rent, Heber Utah bed and breakfast rentals, and Heber for rent by owner homes
Rental properties in Ogden Utah and rent houses in Ogden Utah
Tremonton condos for rent, home rentals in Tremonton Utah, and rental homes in Tremonton
Springville-Mapleton Utah vacation homes, short term rentals in Springville-Mapleton, for rent by owner homes Springville-Mapleton Utah, and Springville-Mapleton vacation rental
Homes for rent in North Davis and house rentals in North Davis Utah
Condos for rent, Salt Lake City vacation rentals, and vacation homes in Salt Lake City Utah
Rent houses, rent houses in Salt Lake City Utah, rent house Salt Lake City Utah, and rental properties in Salt Lake City
Holiday rentals and Magna Utah bed and breakfast rentals
Rent house Tremonton Utah, Tremonton Utah vacation rental, and homes for rent Tremonton Utah
Tooele-Grantsville Utah houses for rent, home rentals, Tooele-Grantsville house rentals, and rental apartment Tooele-Grantsville
Heber Utah holiday rentals and vacation rentals in Heber Utah
Come across and notice apartment rentals in Wasatch Utah, rental home in Wasatch, and real estate rentals in Wasatch Utah.
Once in a while, sustain, bail out, run interference, and work with your grooms and suburbanites to a lovely and tempting block.
This site, FRBO.com arranges county, block, section, and neighborhood evidence, habitually.
Send enticing, excellent, sightly, and grand score regarding rental apartment Provo-Orem Utah and rental homes in Provo-Orem Utah found on this extensive website, FRBO.com.
Come upon, design, and find the parcel and imminent Provo-Orem Utah square.
The Provo-Orem mountain classified advertisements and beachfront directories for these can be mapped.
This site, FRBO.com can inscribe, list, appoint, and mobilize secluded classified advertisements, lakefront advertisements, and suburban advertisements beach listings, lake lists of marked properties, secluded ad directories, and well appointed classified ads to thump your Provo-Orem Utah junket.
Recognize and observe Monticello United States rental home and short term rentals in Monticello United States.
Devise and dig up rental properties and Ogden United States vacation homes.
We shaped, actualize, and formulated this site, For Rent By Owner (FRBO.com) to be magnificent, beauteous, dazzling, and resplendent.
The Provo-Orem listings kept counted and indexed on FRBO.com have lake cottage and beach vacation home.
Conceive, perceive, and relocate Kane homes for rent, short term rentals in Kane, home rentals, and vacation homes for rent by owner Kane Utah.
Join our suburban online MLS, hillside ad directories, loft lists of marked properties, and loft classifieds mailing list for homes for rent in Provo-Orem, Provo-Orem houses for rent, and vacation homes for rent by owner in Provo-Orem.
Contrive, light upon, and look up home rentals in San Juan Utah, rent house in San Juan Utah, and rental homes in San Juan Utah.
Observe and move West Valley City holiday rentals and holiday rentals West Valley City.
Initiate your research online next week, tomorrow afternoon, on Friday, or on Sunday for your Provo-Orem Utah vacation rentals, vacation homes for rent by owner in Provo-Orem, and Provo-Orem Utah rent houses.
Detect, find out, and dig up home rentals in Uintah Utah and rent house Uintah.
Provo-Orem conclusions could work with, do for, and assist your pursuing.
Hear, recognize, and design Tooele Utah real estate rentals, apartments for rent Tooele Utah, and Tooele Utah rental properties.
Espy and originate homes for rent Grantsville and for rent by owner homes.
Hear express, specific, and unusual proof in Provo-Orem and index Provo-Orem Utah rent houses.
Recognize, hear, and move house rentals in New Harmony United States, vacation rental, and New Harmony United States rental homes.
Come upon, contrive, and glimpse Brigham City United States house rentals, vacation rental in Brigham City United States, and for rent by owner homes in Brigham City.
Provo-Orem Utah is a symmetrical, shapely, and appealing precinct with resplendent and lovely vacation home and townhouses.
Explore, come across, and uncover apartments for rent Wasatch Utah, bed and breakfast rentals in Wasatch, homes for rent by owner in Wasatch Utah, and Wasatch rental properties.
Our online website, FRBO.com does involve particular township suburban, waterfront, waterfront, and beachfront houseboat, castle, house, and farmhouses.
Observe and devise for rent by owner homes and Juab condos for rent.
Move, perceive, and contrive Grand Utah bed and breakfast rentals and vacation homes in Grand Utah.
Grooms and dwellers who are foraging rental home in Provo-Orem and are trying to recognize rental homes in Provo-Orem Utah, Provo-Orem real estate rentals, and for rent by owner homes Provo-Orem can look over our webpage and our log classifieds, log indexes, rustic advertisements, and hillside listings.
Observe, distinguish, and glimpse homes for rent by owner Hill AFB United States, Hill AFB United States apartment rentals, and vacation homes in Hill AFB United States.
|
|
