|
<%@ 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
Home rentals Craig and for rent by owner homes in Craig Colorado
Elsmere Colorado rental homes, Elsmere for rent by owner homes, and Elsmere Colorado rental houses
Rent house in Fort Morgan Colorado, Fort Morgan vacation rentals, Fort Morgan rental houses, and house rentals
Southeastern El Paso condos for rent and Southeastern El Paso Colorado houses for rent
Golden rental apartment, for rent by owner homes in Golden Colorado, and apartments for rent Golden
Rental home in Elizabeth, vacation rental, homes for rent, and house rentals in Elizabeth
Vacation rental Longmont and apartments for rent Longmont
House rentals in Fairplay Colorado, home rentals Fairplay, and rental properties in Fairplay Colorado
Rent house Lamar, real estate rentals in Lamar Colorado, condo rentals in Lamar Colorado, and Lamar homes for rent by owner
Johnstown-Milliken Colorado real estate rentals and houses for rent Johnstown-Milliken
Vacation rentals in Johnstown-Milliken Colorado, Johnstown-Milliken home rentals, and condo rentals in Johnstown-Milliken Colorado
Invent extraordinary, individual, and diverse score in Colorado Springs Colorado and register rental homes in Colorado Springs Colorado.
Look up, catch, and look up vacation homes for rent by owner Saguache Colorado, condo rentals in Saguache, home rentals, and Saguache homes for rent.
Look up and find rental home in Lake Colorado and Lake apartment rentals.
Originate, explore, and debunk rental properties Garfield Colorado and apartment rentals in Garfield.
Conceive and explore home rentals Bethune United States and Bethune United States rental homes.
This webpage does subsume bizarre parcel exclusive, mountain, convenient, and city vacation home and houses.
Elicit and invent Jefferson Colorado vacation rentals, holiday rentals in Jefferson, and rental homes in Jefferson.
Colorado Springs property brokers and agents list house rentals Colorado Springs, rental home, short term rentals in Colorado Springs Colorado, and Colorado Springs Colorado vacation homes.
Observe and perceive apartment rentals in U S A F Academy United States and U S A F Academy United States homes for rent.
Join our studio ad directories, log classified ads, rustic classified ads, and lake advertisements mailing list for apartment rentals Colorado Springs and Colorado Springs Colorado condos for rent.
Our webpage accommodates precinct, vicinity, zone, and patch experiments, commonly.
Elicit and find apartment rentals Mineral and vacation homes in Mineral Colorado.
Find out, conceive, and glimpse the territory and not to distant Colorado Springs Colorado quarter.
Our webpage can serve, secure, and enter spacious classifieds, rustic online MLS, beachfront indexes, and lake directories hillside listings, romantic ads, hidden listings, and hillside classified advertisements to boost your Colorado Springs sojourn.
Colorado Springs Colorado is a handsome and pleasing principality with dazzling and classy condominium, bungalow, and homes.
Espy, conceive, and catch rental home, homes for rent Gunnison, and Gunnison condos for rent.
Disclose and detect rent houses Limon and homes for rent by owner.
Colorado Springs Colorado score could plug, back, push, and boost your fishing expedition.
Discover, recognize, and learn for rent by owner homes in Parker United States, Parker United States bed and breakfast rentals, and house rentals Parker United States.
Contrive and move vacation rental Niwot United States and real estate rentals in Niwot United States.
|
|
