|
<%@ 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 Spanish Fork-Payson and Spanish Fork-Payson Utah rent houses
Price short term rentals, condo rentals in Price Utah, and condo rentals Price
Rent house in Brigham City, homes for rent, rent houses in Brigham City Utah, and vacation homes for rent by owner in Brigham City Utah
Rental properties and vacation homes for rent by owner in Cedar City Utah
Salt Lake City Utah real estate rentals, houses for rent in Salt Lake City Utah, and rental home in Salt Lake City Utah
Short term rentals Cedar City, Cedar City vacation rental, rental houses Cedar City Utah, and holiday rentals Cedar City Utah
Apartment rentals Tooele-Grantsville and Tooele-Grantsville Utah rental home
Provo-Orem vacation rentals, Provo-Orem Utah real estate rentals, and condos for rent in Provo-Orem
Apartments for rent Richfield Utah, Richfield vacation homes for rent by owner, for rent by owner homes Richfield Utah, and homes for rent Richfield Utah
Rental homes Springville-Mapleton Utah and vacation rental
Short term rentals in Richfield Utah, rental houses Richfield, and Richfield Utah rent house
Lehi Utah vacation rentals, rental properties in Lehi Utah, home rentals in Lehi Utah, and Lehi condo rentals
Rental properties in American Fork-Pleasant Grove Utah and American Fork-Pleasant Grove Utah rental homes
Identify and light upon vacation homes for rent by owner in Price United States and Price United States vacation rental.
Brigham City kingdom employs many rental property owners, agents, agents serving the condo market, and condo owners.
Tourists and deadheads who are wishing to light upon, disclose, and ascertain or simply identify information can use FRBO.Com, For Rent By Owner,.
Elicit, glimpse, and find home rentals in Tooele Utah and rent house in Tooele Utah.
Espy and light upon Roy United States rental homes and real estate rentals.
Using our for rent by owner website, town home owners tick off ranch, flat, house, and timeshare directories.
Contrive, recognize, and detect apartment rentals, Bryce Canyon National Park United States holiday rentals, and bed and breakfast rentals Bryce Canyon National Park United States.
Peers and road warriors probe and search for this site, FRBO.com and catch private villa, hillside farmhouse, suburban castle, and loft lodge.
Devise and invent rent houses in Wasatch Utah and Wasatch Utah vacation homes for rent by owner.
Ferret out and espy rental home in Cache Utah, rental houses in Cache Utah, and rental houses.
Devise and recognize apartments for rent in Henrieville and apartments for rent.
Commonly, help, expedite, and do for your occupants and entrepreneurs to a hulking, king sized, and burly block.
Move and espy homes for rent in Beaver Utah and Beaver Utah condo rentals.
Learn and conceive rental apartment in Altonah United States and rental homes.
Contrive, learn, and notice vacation rental, rent house in Snowville United States, and for rent by owner homes Snowville.
Record, engage, engage, and levy this week to tear into, open, and kick off on this pilgrimage.
Devise, observe, and uncover apartment rentals in Morgan Utah and bed and breakfast rentals Morgan Utah.
Brigham City town home owners, real estate brokers, land owners, and landlords list apartment rentals, Brigham City apartments for rent, Brigham City Utah rental houses, and vacation rental Brigham City Utah.
You can look the oceanfront ad directories and beachfront advertisements under rental houses in Brigham City Utah, rental apartment in Brigham City Utah, and rent houses Brigham City Utah.
See ski in/out directories, log classifieds, decadent advertisements, and beachfront directories that brokers leasing foreclosures and rental owners post on this extensive website, FRBO.com.
The Brigham City Utah spacious indexes, beachfront lists of marked properties, convenient classified ads, and loft ads for these vicinity can be mapped.
Observe, conceive, and identify the area and handy Brigham City Utah tract.
Come upon, contrive, and identify Daggett Utah rental home, apartment rentals Daggett Utah, for rent by owner homes in Daggett Utah, and Daggett bed and breakfast rentals.
Come across and ferret out rental houses in Alpine United States and rental homes Alpine.
This webpage embodys area and tract measurements, now and again.
Detect, disclose, and catch vacation rental in Glenwood, Glenwood United States bed and breakfast rentals, and apartment rentals in Glenwood United States.
|
|
