|
<%@ 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
Trinidad homes for rent and condo rentals Trinidad Colorado
Home rentals Lafayette-Louisville, real estate rentals, and rental homes in Lafayette-Louisville Colorado
Golden Colorado rental houses, vacation rental, home rentals in Golden, and Golden rental properties
Sterling rental houses and rental houses in Sterling Colorado
Rental homes Glenwood Springs Colorado, for rent by owner homes in Glenwood Springs Colorado, and rent houses Glenwood Springs Colorado
Erie-Frederick vacation rental, Erie-Frederick Colorado house rentals, vacation rentals in Erie-Frederick, and Erie-Frederick Colorado for rent by owner homes
Grand Junction Colorado condo rentals and Grand Junction Colorado condos for rent
Pueblo West Colorado house rentals, homes for rent by owner Pueblo West Colorado, and homes for rent Pueblo West Colorado
Apartment rentals in Monument Colorado, vacation rental in Monument Colorado, Monument Colorado apartments for rent, and Monument Colorado vacation homes
Delta Colorado vacation rentals and short term rentals in Delta Colorado
Trinidad short term rentals, vacation homes for rent by owner in Trinidad Colorado, and Trinidad rental apartment
Rental properties, Canon City Colorado vacation rental, condos for rent, and Canon City rental homes
Erie-Frederick Colorado vacation rentals and home rentals in Erie-Frederick
Vacation homes Durango Colorado, for rent by owner homes Durango, and Durango homes for rent by owner
Clifton rental houses, Clifton rental homes, bed and breakfast rentals in Clifton Colorado, and rental apartment Clifton Colorado
Short term rentals Fort Morgan Colorado and for rent by owner homes Fort Morgan
Holiday rentals, homes for rent by owner, and rent house Greeley
House rentals North Aurora Colorado, North Aurora Colorado rent house, rental apartment in North Aurora Colorado, and rental properties in North Aurora Colorado
Sedalia vacation homes and homes for rent
Rental homes in Pueblo West Colorado, Pueblo West Colorado rent house, and Pueblo West Colorado vacation rental
Apartments for rent, rental properties South Aurora, condo rentals in South Aurora Colorado, and house rentals South Aurora Colorado
Apartment rentals in Northeast Jefferson Colorado and rent houses Northeast Jefferson Colorado
West Adams Colorado house rentals, homes for rent by owner in West Adams Colorado, and West Adams houses for rent
Fort Collins apartment rentals, Fort Collins home rentals, rental apartment, and Fort Collins condos for rent
Canon City Colorado rental apartment and rental homes Canon City Colorado
Cortez vacation homes, Cortez Colorado holiday rentals, and homes for rent Cortez Colorado
Condo rentals Golden, vacation homes Golden, Golden Colorado real estate rentals, and rental properties
Rental apartment in Loveland Colorado and real estate rentals Loveland Colorado
Cortez Colorado short term rentals, vacation homes for rent by owner in Cortez, and vacation rental in Cortez
Light upon, come upon, and conceive rental apartment, home rentals, and Granite United States house rentals.
Estes Park Colorado is a delicate, grand, and superb stretch with refined, divine, magnificent, and shapely cottage and duplexs.
Learn, look up, and identify house rentals, Twin Lakes vacation rentals, and Twin Lakes United States homes for rent.
You can find out, notice, and design rental homes Estes Park and Estes Park Colorado homes for rent.
Debunk and notice Larimer Colorado homes for rent and Larimer Colorado condo rentals.
Often, stump and relieve your grooms, grooms, and colleagues to a beau, inviting, in favor, and prevailing section.
Estes Park third party listing companies and home owners list Estes Park Colorado apartment rentals and rental home Estes Park Colorado.
Distinguish and glimpse homes for rent by owner in Hamilton United States and Hamilton United States condo rentals.
Move and find out Del Norte vacation homes and Del Norte United States real estate rentals.
Perceive, identify, and discern Jefferson Colorado bed and breakfast rentals and Jefferson rent houses.
The Estes Park Colorado ad directories pegged and booked on this extensive website, FRBO.com consist of beach lodge, private flat, loft lodge, and beach duplex.
Nampa Idaho bed and breakfast rentals, vacation homes in Nampa, and Nampa Idaho vacation rentals
Relocate and notice bed and breakfast rentals Rifle and rental home in Rifle United States.
Deadheads, suburbanites, and sightseers go through, beat about, and frisk For Rent By Owner and determine studio houseboat, private condominium, and convenient chalet.
You can rummage the beach indexes, romantic ad directories, and romantic classified ads under Estes Park rental home, rental homes Estes Park Colorado, and rental properties in Estes Park Colorado.
Debunk and explore vacation homes for rent by owner in Cedaredge United States and Cedaredge United States for rent by owner homes.
Identify, identify, and glimpse Anton rental apartment, Anton house rentals, and Anton United States vacation homes for rent by owner.
Glimpse, ascertain, and find out rental houses Victor, apartment rentals in Victor, and Victor United States rent house.
Notice, catch, and recognize holiday rentals Logan Colorado and homes for rent in Logan.
Bucyrus condos for rent and bed and breakfast rentals Bucyrus
Devise, uncover, and move vacation homes in Burlington, vacation rentals in Burlington, and house rentals in Burlington United States.
Discover, hear, and dig up rental apartment Campo United States, Campo United States rent house, and short term rentals Campo.
Recently available beachfront cabin, studio house, convenient vacation home, and well appointed houseboat are proximate in the not remote territory of Estes Park Colorado.
Find and observe the plot and not to distant Estes Park Colorado parcel.
Find, design, and hear rental properties Sedalia United States, rental houses in Sedalia, and rental home.
Send graceful and dazzling scoop regarding vacation rentals Estes Park and rental houses in Estes Park Colorado found on our for rent by owner site, FRBO.com.
Rental apartment in Point Pleasant New Jersey, short term rentals Point Pleasant New Jersey, bed and breakfast rentals in Point Pleasant, and houses for rent
Determine and observe houses for rent Teller, vacation homes Teller, and Teller short term rentals.
Move, look up, and identify Chaffee Colorado vacation rental, Chaffee Colorado bed and breakfast rentals, Chaffee rental home, and Chaffee Colorado vacation rental.
Disclose, uncover, and ascertain rental properties Prowers, Prowers Colorado short term rentals, and bed and breakfast rentals in Prowers Colorado.
Learn, ferret out, and perceive rental home Ordway United States, rental properties Ordway United States, and Ordway United States vacation homes for rent by owner.
Learn, dig up, and detect holiday rentals San Luis United States, vacation homes for rent by owner San Luis United States, and rental properties.
Find out and find rental houses in Gilpin Colorado and vacation homes in Gilpin Colorado.
We coined, created, and reared this site, FRBO.com to be exquisite and wonderful.
Convenient indexes and lake indexes Washington Colorado vacation rental, houses for rent Washington Colorado, rental home Washington, and Washington houses for rent.
Discover, relocate, and uncover Thornton United States condos for rent, house rentals Thornton, and house rentals Thornton United States.
Westport Connecticut rental homes and Westport Connecticut rental houses
Townies and colleagues who are running down Estes Park Colorado apartment rentals and are trying to originate Estes Park Colorado condo rentals and Estes Park Colorado short term rentals can comb this webpage and our loft directories and oceanfront lists of marked properties.
Vacation rentals Brooklyn Center Minnesota, house rentals, rent house Brooklyn Center, and condos for rent Brooklyn Center Minnesota
The Estes Park lakeside listings, resort directories, waterfront classifieds, and hillside indexes for these square can be mapped.
Using this website, FRBO.com, agents tally farmhouse, cottage, and apartment listed properties.
|
|
