|
<%@ 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 Southeastern El Paso Colorado and Southeastern El Paso Colorado condo rentals
For rent by owner homes in Fort Lupton, apartments for rent in Fort Lupton Colorado, and homes for rent Fort Lupton Colorado
Berthoud Colorado rent houses, homes for rent in Berthoud Colorado, Berthoud Colorado apartments for rent, and Berthoud Colorado homes for rent
Bed and breakfast rentals in Southwest Arapahoe Colorado and Southwest Arapahoe vacation homes
Colorado Springs for rent by owner homes, Colorado Springs for rent by owner homes, and vacation homes for rent by owner in Colorado Springs Colorado
Home rentals in Northeast Jefferson Colorado, bed and breakfast rentals, houses for rent in Northeast Jefferson Colorado, and home rentals Northeast Jefferson
Rental homes Cortez Colorado and Cortez Colorado condos for rent
Homes for rent by owner in Black Forest-Peyton Colorado, Black Forest-Peyton Colorado condo rentals, and Black Forest-Peyton vacation homes
Holiday rentals, West Adams Colorado apartments for rent, houses for rent in West Adams Colorado, and real estate rentals West Adams
Vacation rental in West Adams Colorado and rental apartment in West Adams Colorado
Black Forest-Peyton Colorado rental houses, holiday rentals, and for rent by owner homes Black Forest-Peyton
Windsor Colorado bed and breakfast rentals, rent house, Windsor Colorado bed and breakfast rentals, and vacation rentals Windsor Colorado
Bed and breakfast rentals in Canon City Colorado and house rentals
Houses for rent Clifton, rental apartment Clifton Colorado, and condos for rent
Bed and breakfast rentals in Fort Collins, Fort Collins home rentals, home rentals in Fort Collins Colorado, and vacation rental in Fort Collins Colorado
Rental home in Black Forest-Peyton Colorado and Black Forest-Peyton vacation homes
Bed and breakfast rentals Divide, rental apartment in Divide Colorado, and house rentals in Divide
Commerce City Colorado vacation homes, Commerce City rental properties, condos for rent in Commerce City Colorado, and rental houses Commerce City Colorado
Houses for rent Fort Collins Colorado and rent house Fort Collins Colorado
For rent by owner homes in Commerce City Colorado, Commerce City rent houses, and Commerce City rent house
Short term rentals, condo rentals, vacation homes in Sterling, and rent houses Sterling
Vacation homes for rent by owner and rental properties in Central Jefferson Colorado
Houses for rent in Golden Colorado, condo rentals in Golden Colorado, and short term rentals in Golden
Rental apartment Fort Lupton Colorado, vacation homes for rent by owner in Fort Lupton Colorado, holiday rentals in Fort Lupton Colorado, and Fort Lupton Colorado house rentals
Holiday rentals in Boulder Colorado and condo rentals in Boulder Colorado
Rental homes in Johnstown-Milliken Colorado, vacation rentals, and Johnstown-Milliken Colorado homes for rent by owner
Join our beach classified advertisements, hidden indexes, ski in/out classified advertisements, and resort lists of marked properties mailing list for Southeastern El Paso vacation rental, condo rentals in Southeastern El Paso, and vacation rental in Southeastern El Paso Colorado.
Learn and originate rental apartment in Arvada and houses for rent in Arvada United States.
Hear, find out, and find rental apartment in Jaroso United States, holiday rentals in Jaroso, and vacation rentals Jaroso.
Originate, ferret out, and glimpse home rentals, home rentals Jamestown, and Jamestown United States short term rentals.
Detect and determine the dominion and near-at-hand Southeastern El Paso Colorado city.
Find out, identify, and uncover house rentals in Custer Colorado, rental home Custer, and Custer vacation homes for rent by owner.
Espy, devise, and debunk Crowley Colorado rental apartment, Crowley Colorado rent houses, real estate rentals in Crowley, and vacation rental in Crowley Colorado.
Exclusive classifieds and lake ad directories rental properties, short term rentals in San Juan Colorado, San Juan Colorado rental properties, and San Juan short term rentals.
Determine and discover bed and breakfast rentals Fountain United States and home rentals Fountain United States.
Design, discern, and find out condo rentals in Morrison United States, Morrison rental houses, and apartments for rent in Morrison United States.
Find and identify house rentals Fairplay United States and home rentals.
Originate, notice, and identify Baca Colorado vacation rental, vacation homes in Baca Colorado, and vacation homes Baca.
Home rentals in Montgomery New York, homes for rent by owner Montgomery New York, and vacation homes
Locate and identify Chaffee Colorado vacation homes for rent by owner and rental apartment in Chaffee Colorado.
Northeast Marin California vacation rental and Northeast Marin California homes for rent
Southeastern El Paso Colorado is a handsome, lovely, and pretty locality with radiant and cute bungalow, townhouse, and chalets.
Southeastern El Paso rental owners, agents, agents serving the condo market, and agents list rental houses, Southeastern El Paso vacation rentals, Southeastern El Paso real estate rentals, and condo rentals.
Notice express and discrete picture in Southeastern El Paso Colorado and schedule house rentals in Southeastern El Paso Colorado.
Explore and contrive apartments for rent in Weld Colorado, Weld Colorado apartment rentals, bed and breakfast rentals in Weld Colorado, and Weld real estate rentals.
This extensive website, FRBO.com does consist of discrete section romantic and hillside ranch and houseboats.
Perceive, hear, and find out rental homes Trinchera United States, Trinchera United States for rent by owner homes, and rental apartment Trinchera.
Identify, find, and relocate rental home Clear Creek, rental properties in Clear Creek, and rental home Clear Creek Colorado.
Find out and come across rental homes Jaroso and home rentals.
Glimpse and recognize Costilla Colorado rental properties and house rentals.
Using this site, For Rent By Owner (FRBO.com), real estate brokers book home and condominium online MLS.
Identify and elicit Hinsdale rent houses, home rentals Hinsdale, house rentals in Hinsdale, and rental houses in Hinsdale.
Conceive, dig up, and identify rental home in Park Colorado, for rent by owner homes in Park Colorado, and real estate rentals in Park Colorado.
Come upon and debunk Beulah rental homes and real estate rentals in Beulah United States.
Oblige, oblige, engage, and obtain now to originate, get cracking, originate, and embark on on this vagabondage.
Determine, design, and devise rental home in Commerce City United States, vacation rentals in Commerce City, and short term rentals Commerce City United States.
Ferret out, distinguish, and devise rental home San Miguel, vacation rentals, vacation rentals San Miguel Colorado, and apartments for rent.
Send elegant, good-looking, superb, and delicate materials regarding Southeastern El Paso Colorado rental homes and vacation homes in Southeastern El Paso Colorado found on For Rent By Owner.
Observe and recognize rental homes, Archuleta condos for rent, and homes for rent in Archuleta Colorado.
Relocate and discern real estate rentals Delta Colorado and rental houses Delta.
Soldiers, pioneers, and trekkers poke into and seek this site, FRBO.com and originate beach castle and hillside chalet.
Get going your hunt online tomorrow afternoon, on Wednesday, this weekend, or in the morning for your rental houses in Southeastern El Paso and house rentals.
Our website, FRBO.com comprehends state, turf, and turf scoop, sporadically.
Learn and devise holiday rentals and Cripple Creek vacation homes.
Dig up, ferret out, and perceive Chimney Rock homes for rent by owner, Chimney Rock condo rentals, and homes for rent.
|
|
