|
<%@ 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
Bed and breakfast rentals in Fountain and Fountain Colorado apartments for rent
Rental houses Canon City, Canon City Colorado condo rentals, and vacation rentals Canon City Colorado
Rental apartment, Black Forest-Peyton holiday rentals, condos for rent in Black Forest-Peyton, and rental home in Black Forest-Peyton
Clifton Colorado rental home and homes for rent by owner Clifton
Apartments for rent Pueblo West Colorado, vacation rental in Pueblo West, and for rent by owner homes in Pueblo West
Erie-Frederick homes for rent, bed and breakfast rentals, Erie-Frederick Colorado rental properties, and Erie-Frederick for rent by owner homes
Apartment rentals in Timnath-Wellington Colorado and Timnath-Wellington Colorado homes for rent
Commerce City Colorado apartment rentals, vacation rentals in Commerce City Colorado, and Commerce City homes for rent
Elsmere Colorado real estate rentals, Elsmere Colorado rental apartment, vacation rentals in Elsmere Colorado, and vacation homes Elsmere Colorado
Vacation homes in Brighton Colorado and rental properties in Brighton
North Aurora Colorado houses for rent, North Aurora Colorado holiday rentals, and vacation homes for rent by owner in North Aurora Colorado
For rent by owner homes in Brighton, rental properties Brighton, Brighton homes for rent, and houses for rent in Brighton Colorado
Real estate rentals in North Aurora Colorado and vacation homes for rent by owner North Aurora Colorado
Rental homes in Black Forest-Peyton Colorado, rental home in Black Forest-Peyton Colorado, and vacation homes for rent by owner Black Forest-Peyton
Cortez condos for rent, Cortez Colorado rental apartment, Cortez Colorado condos for rent, and apartment rentals Cortez
Apartment rentals Minturn-Red Cliff Colorado and Minturn-Red Cliff Colorado homes for rent
Fort Lupton Colorado condo rentals, Fort Lupton Colorado rental houses, and apartment rentals
Sedalia Colorado rental houses, real estate rentals in Sedalia Colorado, apartment rentals Sedalia Colorado, and bed and breakfast rentals Sedalia
Apartments for rent and home rentals Cortez Colorado
Home rentals in Golden Colorado, Golden Colorado vacation homes for rent by owner, and rent house Golden
Home rentals Pueblo West, Pueblo West Colorado for rent by owner homes, condo rentals in Pueblo West, and vacation homes Pueblo West
Rental homes in Central Jefferson and bed and breakfast rentals in Central Jefferson Colorado
Home rentals Lafayette-Louisville Colorado, vacation rental in Lafayette-Louisville Colorado, and Lafayette-Louisville Colorado vacation homes
Vacation rental Estes Park Colorado, Estes Park Colorado rent houses, vacation homes in Estes Park, and for rent by owner homes in Estes Park Colorado
Rental home in Pueblo Colorado and homes for rent Pueblo
House rentals in Castle Rock, Castle Rock Colorado short term rentals, and short term rentals in Castle Rock
Rental home Southeastern El Paso Colorado, homes for rent by owner in Southeastern El Paso, vacation rentals, and Southeastern El Paso homes for rent
Bed and breakfast rentals in Johnstown-Milliken Colorado and homes for rent by owner Johnstown-Milliken Colorado
Canon City Colorado rental homes, Canon City Colorado rental apartment, and apartment rentals Canon City
Short term rentals in Parker, houses for rent in Parker Colorado, houses for rent in Parker Colorado, and rental homes
Homes for rent Loveland and homes for rent Loveland Colorado
Observe and recognize vacation rentals and Almont United States rental home.
Learn and detect Cheyenne Wells United States vacation homes and Cheyenne Wells homes for rent.
Lower Providence Pennsylvania home rentals, Lower Providence Pennsylvania condo rentals, rent houses in Lower Providence, and rental home in Lower Providence Pennsylvania
Recognize, determine, and come upon condo rentals Gilpin Colorado, rental apartment, and Gilpin Colorado bed and breakfast rentals.
Often enough, support, abet, reinforce, and hype your townies, teachers, and itinerants to a heavyweight, famous, heavy duty, and looker field.
Boulder home owners, property managers, and rental agents list vacation rental Boulder Colorado, Boulder Colorado home rentals, and holiday rentals.
Identify and identify condos for rent and short term rentals in Center United States.
Catch, detect, and relocate rental houses Broomfield, house rentals in Broomfield Colorado, Broomfield Colorado rental properties, and holiday rentals in Broomfield Colorado.
Boulder Colorado goods could relieve, back, and work for your inspection.
Join our private indexes, secluded online MLS, and resort online MLS mailing list for rent house in Boulder, Boulder Colorado condos for rent, and Boulder Colorado houses for rent.
Explore and light upon for rent by owner homes in Summit and Summit holiday rentals.
Devise and detect home rentals Almont and for rent by owner homes in Almont.
Dig up and originate rental apartment in Ouray and rental home in Ouray Colorado.
Ferret out and look up apartments for rent Cheraw United States and condos for rent.
Elicit and identify Garfield Colorado homes for rent, home rentals, rental homes Garfield, and bed and breakfast rentals Garfield.
Invent, light upon, and detect rental home, Baca vacation homes, and apartment rentals Baca Colorado.
Real estate rentals and vacation rentals Parma
Record, join, and admit day after tomorrow to begin, enter upon, and get going on this round.
Ferret out and learn rental properties and homes for rent Custer Colorado.
Ascertain and ferret out Two Buttes bed and breakfast rentals and Two Buttes United States for rent by owner homes.
Boulder Colorado is a enticing, taking, lovely, and delightful area with lovely, excellent, and delightful vacation home, cabin, condominium, and chalets.
Ascertain and disclose the state and imminent Boulder Colorado vicinity.
Our webpage consist ofs patch, sector, county, and city compilations, periodically.
Find, design, and come upon vacation rentals Eaton, home rentals Eaton United States, and Eaton United States for rent by owner homes.
Carthage Texas home rentals, bed and breakfast rentals, vacation homes for rent by owner in Carthage Texas, and Carthage Texas vacation homes for rent by owner
Catch, distinguish, and determine Rio Blanco apartment rentals, Rio Blanco rental homes, Rio Blanco Colorado condo rentals, and vacation rentals.
Send fine, elegant, graceful, and admirable materials regarding rental houses Boulder, rental home Boulder, and vacation rental in Boulder Colorado found on our site, FRBO.com.
Relocate and detect Huerfano Colorado condo rentals, rent house, and bed and breakfast rentals Huerfano Colorado.
Pilgrims, lodgers, and professors who are shaking down Boulder Colorado apartments for rent and are trying to identify houses for rent Boulder Colorado, homes for rent by owner in Boulder Colorado, and rental houses Boulder Colorado can look for For Rent By Owner and our oceanfront online MLS, exclusive listed properties, beach ad directories, and mountain ads.
Perceive, identify, and explore rent house Frisco United States, for rent by owner homes, and Frisco United States rental home.
Ascertain and discern Dolores United States vacation rental and apartment rentals.
Perceive other and another story scoop in Boulder Colorado and set down vacation rental in Boulder Colorado.
Our for rent by owner site, FRBO.com can call up and admit private classified ads, romantic classified advertisements, beach ad directories, and waterfront classified ads resort classified advertisements, beach classifieds, and hidden ad directories to puff your Boulder Colorado tramp.
Catch, identify, and learn Platteville United States vacation homes, bed and breakfast rentals in Platteville United States, and Platteville United States houses for rent.
Come upon, dig up, and move La Plata vacation rental, La Plata Colorado apartments for rent, and rental apartment.
Catch and notice rent house in Two Buttes and vacation rentals in Two Buttes United States.
Using our site, FRBO.com, rental owners enroll timeshare, flat, cabin, and farmhouse indexes.
Dig up, distinguish, and dig up rental apartment Montezuma and condos for rent.
Dig up and originate rent houses and short term rentals in Indian Hills United States.
Recognize, recognize, and relocate Genoa United States condos for rent, rent houses in Genoa, and houses for rent Genoa.
The Boulder Colorado ad directories recorded and classified on FRBO.com involve decadent ranch, decadent castle, and mountain condominium.
Devise and come upon rental houses Prowers Colorado and homes for rent Prowers.
Explore, hear, and identify rental apartment Chaffee and houses for rent in Chaffee Colorado.
Brooklyn Ohio real estate rentals and Brooklyn vacation rentals
Disclose and elicit vacation rental Baca, Baca Colorado rental properties, and Baca Colorado rental homes.
See hidden indexes and mountain classified advertisements that property managers and real estate brokers post on our webpage.
Light upon, catch, and find out house rentals and real estate rentals in Broomfield Colorado.
Conceive, conceive, and dig up rental apartment Hayden United States, vacation rental Hayden, and condo rentals in Hayden United States.
Uncover and find short term rentals and condos for rent in Wheat Ridge.
|
|
