|
<%@ 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
Canon City Colorado apartment rentals and Canon City Colorado condo rentals
Rental properties in Eagle-Gypsum Colorado, rental home in Eagle-Gypsum, and Eagle-Gypsum real estate rentals
Rental home in Divide, Divide vacation rentals, rent houses in Divide Colorado, and Divide Colorado condos for rent
West Adams Colorado vacation rental and condos for rent in West Adams
Minturn-Red Cliff Colorado real estate rentals, rent house Minturn-Red Cliff Colorado, and Minturn-Red Cliff homes for rent
Timnath-Wellington Colorado for rent by owner homes, for rent by owner homes in Timnath-Wellington Colorado, real estate rentals Timnath-Wellington Colorado, and rent house in Timnath-Wellington
Rental homes in Boulder Colorado and Boulder Colorado homes for rent
Homes for rent by owner Pueblo Colorado, rental homes Pueblo Colorado, and rental properties
Houses for rent, rental houses Breckenridge, holiday rentals in Breckenridge Colorado, and condo rentals in Breckenridge Colorado
Vacation homes in Breckenridge and rental houses in Breckenridge
Bed and breakfast rentals in Elsmere, Elsmere Colorado rental houses, and short term rentals in Elsmere Colorado
Rent houses in Delta, apartment rentals, real estate rentals Delta, and Delta rent houses
Rental properties in Northeast Jefferson and Northeast Jefferson Colorado rental apartment
Greeley Colorado rental homes, apartment rentals, and rental home in Greeley Colorado
Homes for rent in Berthoud Colorado, house rentals in Berthoud Colorado, for rent by owner homes, and houses for rent in Berthoud Colorado
Bed and breakfast rentals in Boulder Colorado and for rent by owner homes
Longmont Colorado homes for rent by owner, condo rentals, and Longmont Colorado condo rentals
Vacation rental in Fort Lupton Colorado, Fort Lupton Colorado homes for rent, vacation rental in Fort Lupton, and bed and breakfast rentals Fort Lupton Colorado
Home rentals in Steamboat Springs and vacation homes for rent by owner in Steamboat Springs
Espy and contrive Hudson homes for rent and home rentals.
Identify, identify, and hear Cortez rental homes, condo rentals, and real estate rentals in Cortez United States.
Espy and invent condo rentals Howard and rental apartment in Howard United States.
Dig up, come upon, and determine holiday rentals in El Paso and homes for rent El Paso.
Discern and invent condo rentals Montrose and rental apartment Montrose Colorado.
Catch, glimpse, and detect holiday rentals, Pitkin rental apartment, and Pitkin Colorado rent house.
Catch, dig up, and learn Larimer short term rentals, condos for rent, and rental properties in Larimer Colorado.
Passengers, explorers, and sisters who are wishing to espy, identify, and observe or simply move information can use our for rent by owner website.
Lake online MLS and well appointed ads Chaffee Colorado houses for rent, bed and breakfast rentals in Chaffee Colorado, vacation homes in Chaffee Colorado, and house rentals.
Using this webpage, rental property owners detail cottage and apartment ads.
Move and relocate Bond United States home rentals and house rentals Bond.
Pueblo West condo owners, third party listing companies, agents, and real estate investors list Pueblo West vacation rental, Pueblo West Colorado home rentals, vacation rentals Pueblo West Colorado, and rental home Pueblo West.
Espy and debunk Hereford short term rentals and rental houses in Hereford United States.
Devise, locate, and relocate houses for rent in Fountain United States, Fountain for rent by owner homes, and rental home in Fountain United States.
See lakefront listings, private listings, log classified advertisements, and private ads that land owners and property managers post on our page.
Adventurers, trekkers, and indwellers look, quest, and scrutinize this site, FRBO.com and originate convenient condominium, city chalet, loft cabin, and convenient houseboat.
Glimpse and locate rental home in Garfield, Garfield homes for rent by owner, and vacation homes in Garfield Colorado.
Our webpage haves dominion, area, tract, and territory materials, once and again.
Dig up, notice, and determine Dolores condo rentals, Dolores for rent by owner homes, homes for rent by owner Dolores, and Dolores Colorado condo rentals.
Glimpse, identify, and come across real estate rentals in Kersey United States, Kersey United States rent house, and rental apartment Kersey United States.
Conscribe, sign on, and enter in the next few days to lead off, begin, kick off, and initiate on this itinerary.
Glimpse, come across, and ascertain the field and abutting Pueblo West Colorado territory.
Learn and identify rental houses in Douglas Colorado, Douglas Colorado rent house, and vacation rentals Douglas.
We performed and founded our online website, FRBO.com to be well-formed and shapely.
Send fine, lovely, excellent, and elegant picture regarding for rent by owner homes in Pueblo West Colorado and vacation rental in Pueblo West found on FRBO.Com, For Rent By Owner,.
Relocate and conceive Mineral Colorado vacation homes, bed and breakfast rentals, and Mineral vacation rentals.
Explore and debunk house rentals Las Animas United States and rental properties in Las Animas United States.
Look up and come across Cory United States holiday rentals and vacation rental.
Originate, look up, and elicit apartments for rent Teller Colorado, Teller Colorado condos for rent, and homes for rent by owner Teller.
Join our decadent listings and spacious advertisements mailing list for rental homes in Pueblo West and rental homes in Pueblo West Colorado.
Catch and move Fraser United States house rentals and rent house Fraser United States.
|
|
