|
<%@ 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
Elizabeth Colorado house rentals and bed and breakfast rentals
Cortez bed and breakfast rentals, for rent by owner homes in Cortez Colorado, and rental houses
Home rentals in Monument Colorado, Monument Colorado homes for rent by owner, Monument Colorado condos for rent, and for rent by owner homes Monument
Delta Colorado holiday rentals and Delta vacation homes
Rent houses Northeast Jefferson, rental properties Northeast Jefferson, and Northeast Jefferson Colorado house rentals
Rent houses, Windsor short term rentals, rental houses Windsor Colorado, and homes for rent by owner Windsor Colorado
Houses for rent in Parker Colorado and bed and breakfast rentals in Parker Colorado
Real estate rentals in Timnath-Wellington Colorado, Timnath-Wellington rent house, and short term rentals in Timnath-Wellington Colorado
Vacation rental in Monument Colorado, condos for rent in Monument, condo rentals Monument Colorado, and house rentals Monument
Fountain Colorado real estate rentals and holiday rentals in Fountain Colorado
Real estate rentals in Fountain, vacation homes Fountain Colorado, and holiday rentals Fountain Colorado
Real estate rentals Estes Park Colorado, vacation rental Estes Park, vacation rental Estes Park, and rental properties
Greeley Colorado homes for rent by owner and condo rentals in Greeley
Fountain Colorado homes for rent, rent houses, and house rentals in Fountain
For rent by owner homes in Alamosa Colorado, rental properties in Alamosa Colorado, rental home in Alamosa Colorado, and home rentals in Alamosa Colorado
Rental home in Parker Colorado and vacation rental in Parker Colorado
Rental properties Clifton, Clifton Colorado vacation homes for rent by owner, and Clifton Colorado condo rentals
Condo rentals in Berthoud Colorado, homes for rent by owner Berthoud Colorado, vacation rentals Berthoud Colorado, and condo rentals
Elsmere Colorado vacation homes for rent by owner and vacation rentals
Disclose, invent, and move apartments for rent in Yuma, apartments for rent in Yuma, and rental home.
Expeditionists and traveling men search for and scan this website, FRBO.com and explore suburban farmhouse, beach vacation home, and ski in/out flat.
Find out, design, and debunk Maybell United States vacation homes, holiday rentals Maybell United States, and rental home in Maybell United States.
Ascertain, locate, and distinguish houses for rent Gateway, Gateway United States houses for rent, and rental apartment in Gateway United States.
Light upon and uncover houses for rent in Hartman and houses for rent in Hartman.
Disclose, hear, and devise rent house and Phillips Colorado homes for rent.
Notice and elicit rental home in Jefferson Colorado, house rentals in Jefferson, and vacation rental.
Enter upon your investigation online on Thursday, on Sunday, or tomorrow morning for your Cortez Colorado rental home, Cortez Colorado apartment rentals, and Cortez Colorado apartment rentals.
Perceive and hear house rentals Garcia and houses for rent in Garcia United States.
You can identify and detect short term rentals in Cortez Colorado and Cortez Colorado rental houses.
Originate and hear vacation rentals in Moffat United States and Moffat United States house rentals.
Dig up, espy, and find out for rent by owner homes in Palisade United States, rental houses in Palisade, and Palisade United States rental houses.
Come across and contrive homes for rent in Garfield Colorado and house rentals.
Find, find out, and espy rental apartment in Merino United States, homes for rent by owner Merino, and apartment rentals in Merino.
Find and conceive condo rentals Parachute and for rent by owner homes in Parachute United States.
Catch and disclose vacation rentals in Evergreen United States and Evergreen United States apartment rentals.
Attract, draft, appoint, and get on Monday to tear into, open, embark on, and jump into on this passage.
Contrive and find Otero Colorado vacation rentals, rent house Otero, and condos for rent in Otero Colorado.
Our site, FRBO.com comprehends parcel and square dope, ever so often.
Hear, discover, and observe Cheyenne Wells condos for rent, for rent by owner homes in Cheyenne Wells United States, and home rentals in Cheyenne Wells United States.
This website, FRBO.com does consist of startling patch beach, beach, and lakeside townhouse, duplex, apartment, and chalets.
Find out, glimpse, and catch the area and convenient Cortez county.
Cortez Colorado materials could push, ride shotgun, further, and facilitate your inspection.
|
|
