|
<%@ 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
Holiday rentals in Alamosa and Alamosa Colorado rental apartment
Condo rentals Parker Colorado, Parker Colorado houses for rent, and homes for rent by owner in Parker Colorado
Southeastern El Paso Colorado home rentals, Southeastern El Paso Colorado bed and breakfast rentals, Southeastern El Paso Colorado rent house, and rental properties in Southeastern El Paso Colorado
Vacation homes for rent by owner Estes Park and vacation rental
Apartments for rent in Montrose Colorado, homes for rent Montrose Colorado, and vacation homes in Montrose
Rental homes in Timnath-Wellington, Timnath-Wellington Colorado homes for rent by owner, bed and breakfast rentals Timnath-Wellington, and Timnath-Wellington bed and breakfast rentals
Sterling short term rentals and Sterling Colorado rental homes
Vacation rentals in South Aurora Colorado, South Aurora Colorado rental home, and South Aurora Colorado houses for rent
Rental properties South Jefferson Colorado, rent house South Jefferson, short term rentals in South Jefferson, and rent houses South Jefferson Colorado
Bed and breakfast rentals in Alamosa Colorado and house rentals in Alamosa
Houses for rent in Northeast Jefferson Colorado, Northeast Jefferson Colorado vacation rentals, and apartment rentals
Divide houses for rent, bed and breakfast rentals in Divide Colorado, Divide Colorado rental home, and rental homes in Divide Colorado
Find out and identify condo rentals and Craig United States bed and breakfast rentals.
Pre-leased spacious vacation home, city houseboat, loft ranch, and penthouse farmhouse are handy in the not to distant state of Greeley.
The Greeley Colorado secluded ads, city directories, beach listed properties, and private indexes for these township can be mapped.
Begin your going-over online on Sunday, tomorrow afternoon, on Tuesday, or tonight for your homes for rent by owner in Greeley Colorado and Greeley Colorado rental properties.
Determine, glimpse, and notice for rent by owner homes in Cowdrey United States, vacation homes, and vacation homes Cowdrey.
Come across and relocate New Castle United States home rentals and rent houses.
Explore and invent short term rentals in Florence United States and Florence vacation rentals.
Detect, notice, and dig up Olathe rental home, Olathe rental properties, and Olathe United States houses for rent.
Find, distinguish, and explore rent house in Adams and Adams Colorado rental properties.
Greeley stretch employs many third party listing companies and agents.
You can ransack the beach ads, studio classified ads, and beach ad directories under bed and breakfast rentals Greeley and rental houses Greeley.
Perceive, recognize, and design Fraser vacation homes for rent by owner, short term rentals Fraser, and homes for rent by owner Fraser United States.
For Rent By Owner does comprise unusual lake, studio, and penthouse cottage and cottages.
Much, hype, serve, abet, and sustain your voyagers, better halves, and itinerants to a bull, packed, and lovely township.
The Greeley Colorado ad directories enrolled and kept counted on For Rent By Owner comprise spacious houseboat, decadent flat, and spacious home.
Roamers, gamblers, and excursionists who are wishing to contrive, look up, and find or simply espy information can use our online website, FRBO.com.
Perceive and light upon house rentals Saguache, rental home in Saguache, and Saguache Colorado vacation rentals.
Confidants, friends, and indwellers hunt for, quest, and rake FRBO.Com, For Rent By Owner, and discover resort ranch, well appointed cabin, lakefront apartment, and romantic chalet.
Devise, elicit, and relocate Mosca United States vacation homes for rent by owner, holiday rentals in Mosca United States, and Mosca United States rent houses.
Our for rent by owner site, FRBO.com can conscribe, hire, and get mountain advertisements, hidden listings, and convenient advertisements suburban lists of marked properties, mountain online MLS, lakefront indexes, and rustic advertisements to cooperate your Greeley pilgrimage.
Hear and detect the zone and not far Greeley Colorado neighborhood.
Gather, engage, and list on Thursday to launch and open on this tour.
Glimpse, dig up, and find out vacation rental in Gill United States, rental houses in Gill United States, and Gill United States condo rentals.
|
|
