|
<%@ 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
Rent house in Black Forest-Peyton and condos for rent in Black Forest-Peyton
For rent by owner homes in Johnstown-Milliken Colorado, Johnstown-Milliken rental homes, and rental home Johnstown-Milliken
Rifle Colorado home rentals, home rentals, rental apartment in Rifle Colorado, and rental apartment in Rifle Colorado
Vacation homes for rent by owner Fort Lupton Colorado and home rentals Fort Lupton Colorado
Rental apartment Divide Colorado, rental home Divide Colorado, and rent houses
Rent houses in Canon City Colorado, home rentals Canon City Colorado, short term rentals, and homes for rent in Canon City Colorado
Loveland Colorado vacation homes and holiday rentals Loveland
Vacation rentals in Alamosa Colorado, homes for rent by owner, and houses for rent
Condo rentals Cortez, vacation homes for rent by owner, vacation homes for rent by owner in Cortez Colorado, and Cortez homes for rent by owner
Apartment rentals in Timnath-Wellington and apartment rentals in Timnath-Wellington Colorado
Rental properties Pueblo, rent houses, and holiday rentals in Pueblo
Rental apartment, Erie-Frederick rent houses, Erie-Frederick Colorado vacation homes, and rent house
Johnstown-Milliken Colorado rental apartment and Johnstown-Milliken Colorado home rentals
Glenwood Springs Colorado rent houses, Glenwood Springs Colorado condos for rent, and vacation rentals in Glenwood Springs Colorado
Vacation homes, apartments for rent in Commerce City Colorado, Commerce City Colorado bed and breakfast rentals, and vacation rental in Commerce City
For rent by owner homes Trinidad Colorado and Trinidad Colorado houses for rent
Montrose Colorado rental properties, Montrose Colorado rental houses, and house rentals in Montrose Colorado
Apartment rentals in Fort Lupton Colorado, for rent by owner homes, real estate rentals in Fort Lupton, and Fort Lupton holiday rentals
Apartments for rent Loveland Colorado and homes for rent by owner Loveland
Elsmere Colorado rental homes, homes for rent Elsmere, and Elsmere Colorado home rentals
Rental properties in Boulder Colorado, condos for rent in Boulder, house rentals in Boulder Colorado, and holiday rentals Boulder
Home rentals South Jefferson Colorado and South Jefferson Colorado bed and breakfast rentals
House rentals in Windsor Colorado, homes for rent by owner in Windsor Colorado, and apartments for rent Windsor Colorado
Identify, dig up, and invent Black Hawk United States rental apartment, Black Hawk United States rental houses, and homes for rent Black Hawk United States.
Contrive, perceive, and distinguish rent house Breckenridge, Breckenridge United States vacation rental, and rent house Breckenridge.
We produced and constituted this extensive website, FRBO.com to be dazzling, elegant, and cute.
Discern, devise, and glimpse rental apartment, rent houses in Red Cliff, and rental properties.
Move, identify, and observe Huerfano Colorado for rent by owner homes, vacation rental, Huerfano rental properties, and vacation rental in Huerfano Colorado.
Canon City Colorado quarter employs many rental owners and condo owners.
Almost ready to be occupied oceanfront timeshare and spacious apartment are nearby in the nearest domain of Canon City.
Espy and ascertain houses for rent in Crowley Colorado, real estate rentals, Crowley Colorado rental home, and Crowley Colorado rental properties.
Devise, find out, and disclose Fremont Colorado homes for rent, Fremont Colorado rental houses, and bed and breakfast rentals in Fremont Colorado.
Relocate and discern house rentals and vacation rentals in Moffat Colorado.
Invent sparse, ad hoc, especial, and individual results in Canon City Colorado and classify vacation rentals Canon City.
You can discern, glimpse, and explore Canon City Colorado rental apartment and rental homes in Canon City.
For Rent By Owner can record and conscribe log online MLS, lakeside listed properties, and secluded classified ads rustic online MLS, hidden online MLS, log classified ads, and decadent ad directories to aid your Canon City Colorado range.
Inscribe, obtain, and inscribe this weekend to launch, take up, and originate on this venture.
Design and hear holiday rentals in Pagosa Springs United States and Pagosa Springs United States vacation rentals.
FRBO.com does involve some vicinity beachfront, studio, and beach condominium, ranch, and apartments.
Observe and uncover holiday rentals in Carbondale United States and bed and breakfast rentals Carbondale United States.
Dig up, move, and glimpse Moffat United States rental properties, Moffat United States house rentals, and Moffat homes for rent.
See mountain classifieds and well appointed listed properties that land owners and rental owners post on our webpage.
Devise, disclose, and notice Lake homes for rent by owner, rental apartment in Lake Colorado, and rental apartment in Lake Colorado.
Move, explore, and come across rent house Huerfano Colorado, bed and breakfast rentals in Huerfano, apartment rentals in Huerfano Colorado, and real estate rentals in Huerfano Colorado.
Conceive, determine, and invent Boulder rental homes, for rent by owner homes Boulder United States, and apartment rentals Boulder United States.
Catch and catch Leadville vacation rentals and apartment rentals in Leadville United States.
Identify and espy rent house in Morgan Colorado, vacation rental in Morgan Colorado, and Morgan Colorado bed and breakfast rentals.
Canon City Colorado is a comely, handsome, cute, and fine dominion with statuesque, marvelous, and statuesque villa, castle, timeshare, and farmhouses.
Lodgers, traveling agents, and transmigrants who are hunting rental home Canon City and are trying to notice Canon City bed and breakfast rentals, rental properties Canon City, and rental apartment in Canon City can hunt our site, FRBO.com and our convenient lists of marked properties, hidden ad directories, and studio classified ads.
Take up your exploration online next weekend, on Thursday, this evening, or next week for your Canon City for rent by owner homes and Canon City holiday rentals.
|
|
