|
<%@ 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" %>
|
Colorado Rental Links
Sedalia rental houses and Sedalia Colorado bed and breakfast rentals
Colorado Springs Colorado rental homes, Colorado Springs Colorado home rentals, and Colorado Springs Colorado rental apartment
Homes for rent by owner in Fountain Colorado, rent houses in Fountain Colorado, Fountain Colorado rent house, and rental homes in Fountain
Black Forest-Peyton apartments for rent and Black Forest-Peyton Colorado rental home
Fort Morgan vacation homes, Fort Morgan rental homes, and Fort Morgan Colorado vacation homes for rent by owner
Lafayette-Louisville homes for rent by owner, Lafayette-Louisville Colorado home rentals, real estate rentals, and real estate rentals in Lafayette-Louisville
Rental homes in Timnath-Wellington and for rent by owner homes in Timnath-Wellington Colorado
Rental houses Fairplay Colorado, holiday rentals in Fairplay Colorado, and rental houses Fairplay
Condo rentals in Lafayette-Louisville Colorado, Lafayette-Louisville Colorado home rentals, condo rentals Lafayette-Louisville Colorado, and Lafayette-Louisville rental properties
Short term rentals in Glenwood Springs Colorado and rental homes in Glenwood Springs Colorado
Estes Park rental homes, Estes Park rental houses, and Estes Park Colorado condos for rent
Vacation homes in Alamosa Colorado, rental homes in Alamosa, vacation homes for rent by owner Alamosa Colorado, and Alamosa Colorado holiday rentals
Bald Mountain vacation rental and rental properties in Bald Mountain Colorado
Rental home in Loveland Colorado, homes for rent by owner, and rental home in Loveland Colorado
Discern and identify rental houses in Fort Garland United States and Fort Garland United States houses for rent.
Gypsies and seafarers who are looking for Delta Colorado rent house and are trying to perceive Delta Colorado rental apartment and Delta Colorado rental homes can scan this site, For Rent By Owner (FRBO.com) and our convenient directories, beach listed properties, and exclusive lists of marked properties.
Join our lakefront indexes, well appointed classified ads, and beach classified ads mailing list for short term rentals Delta, Delta Colorado vacation rentals, and condos for rent Delta Colorado.
Design, glimpse, and disclose Pierce United States rental homes, Pierce United States rental homes, and Pierce United States home rentals.
Beachfront directories and city classified ads vacation rentals, Rio Blanco Colorado vacation homes for rent by owner, homes for rent by owner in Rio Blanco Colorado, and Rio Blanco Colorado rental homes.
FRBO.Com, For Rent By Owner, does comprehend specialized block mountain, ski in/out, lakefront, and lakefront bungalow and vacation homes.
Send well-formed, gorgeous, and stunning score regarding Delta Colorado real estate rentals, vacation homes, vacation rentals Delta Colorado, and Delta rental houses found on our page.
Ferret out, light upon, and distinguish Costilla Colorado house rentals and Costilla apartments for rent.
Identify, detect, and recognize Iliff United States vacation homes for rent by owner, rent houses Iliff United States, and Iliff homes for rent.
Spasmodically, aid and aid your habitants and adventurers to a lovable and beau kingdom.
Our site, FRBO.com take ins township and area materials, by ordinary.
Uncover, recognize, and disclose Gunnison Colorado real estate rentals, short term rentals in Gunnison Colorado, and vacation homes for rent by owner Gunnison Colorado.
Relocate and determine house rentals and Jefferson home rentals.
|
|
