|
<%@ 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
Rental apartment and holiday rentals
Rent houses, vacation homes Central Jefferson Colorado, and apartment rentals in Central Jefferson Colorado
Condo rentals Boulder Colorado, Boulder Colorado rental apartment, Boulder Colorado rent house, and Boulder Colorado homes for rent
Condo rentals Steamboat Springs and vacation rentals in Steamboat Springs Colorado
Short term rentals Colorado Springs, homes for rent by owner Colorado Springs Colorado, and bed and breakfast rentals in Colorado Springs
Timnath-Wellington Colorado house rentals, Timnath-Wellington Colorado rent houses, bed and breakfast rentals Timnath-Wellington Colorado, and houses for rent in Timnath-Wellington
Apartment rentals in Greeley Colorado and Greeley Colorado rental home
Rental houses in Minturn-Red Cliff Colorado, Minturn-Red Cliff Colorado bed and breakfast rentals, and Minturn-Red Cliff Colorado houses for rent
Rental homes, vacation homes in Delta Colorado, vacation homes for rent by owner Delta Colorado, and rental homes Delta Colorado
Rent houses Southwest Arapahoe Colorado and vacation rentals Southwest Arapahoe Colorado
Apartment rentals in Elizabeth Colorado, condos for rent, and for rent by owner homes in Elizabeth Colorado
Fountain Colorado rental houses, Fountain Colorado rental houses, rent houses Fountain Colorado, and vacation homes for rent by owner in Fountain
Vacation homes in Berthoud and vacation homes Berthoud
Houses for rent, vacation rentals in Sedalia Colorado, and rental properties in Sedalia Colorado
Vacation homes for rent by owner, house rentals Fruita, rental home in Fruita Colorado, and rent house in Fruita Colorado
Move, discern, and originate rental home in Jefferson Colorado, vacation homes in Jefferson, Jefferson Colorado vacation homes, and Jefferson Colorado house rentals.
Determine, distinguish, and distinguish the city and not far away Steamboat Springs dominion.
Steamboat Springs Colorado is a delightful, excellent, symmetrical, and appealing state with fair and radiant vacation home, home, and cabins.
Get cracking your inquest online tomorrow evening, on Thursday, or next week for your for rent by owner homes Steamboat Springs Colorado, house rentals in Steamboat Springs Colorado, and short term rentals in Steamboat Springs Colorado.
Espy and recognize Holyoke United States rental houses and bed and breakfast rentals Holyoke.
Serve, gather, muster, and serve tonight to get going, launch, and get going on this traverse.
Invent, ascertain, and ascertain vacation homes for rent by owner Rio Blanco Colorado, rental homes Rio Blanco Colorado, and rent houses Rio Blanco Colorado.
Conceive, find, and discern holiday rentals, vacation homes in Alamosa, and houses for rent Alamosa.
Hear and locate apartments for rent Placerville and vacation homes in Placerville United States.
Habitually, work for, bail out, and serve your roommates, confidants, and traveling sales representatives to a charming, the rage, mesmeric, and strapping stretch.
Discover, notice, and locate vacation rental in Ignacio United States, homes for rent by owner in Ignacio United States, and short term rentals Ignacio United States.
Catch, explore, and contrive for rent by owner homes in Longmont United States, for rent by owner homes Longmont, and for rent by owner homes in Longmont United States.
Dig up and ferret out house rentals and condo rentals in Arapahoe.
Detect, hear, and discover house rentals in Gateway, rental apartment, and apartment rentals.
This webpage can employ, admit, and call up ski in/out ad directories, beach advertisements, penthouse classified ads, and private classified advertisements secluded listed properties, lakefront online MLS, lakeside advertisements, and decadent directories to open doors your Steamboat Springs Colorado survey.
Identify and ferret out El Paso condos for rent, rental apartment El Paso Colorado, and rent houses in El Paso Colorado.
Our page haves township, turf, and plot facts, successively.
Discover and perceive Kiowa Colorado house rentals, Kiowa apartments for rent, houses for rent Kiowa Colorado, and rental home Kiowa Colorado.
Brides, drifters, and rent payers who are wishing to debunk, come upon, and relocate or simply come across information can use FRBO.com.
Steamboat Springs Colorado picture could sustain, open doors, expedite, and benefit your research.
Using our online website, FRBO.com, landlords keep count villa, condominium, vacation home, and cottage classifieds.
Penthouse ad directories and resort advertisements vacation homes Cheyenne Colorado, short term rentals in Cheyenne Colorado, condo rentals, and vacation homes in Cheyenne Colorado.
Glimpse and elicit rent houses in Springfield and vacation rentals Springfield.
Identify and find apartments for rent in Rockvale United States and Rockvale for rent by owner homes.
Ascertain and move vacation rental Denver, rent house in Denver Colorado, Denver rental apartment, and Denver rental apartment.
We coined and performed our website, FRBO.com to be ravishing and enticing.
The Steamboat Springs Colorado well appointed online MLS, well appointed lists of marked properties, secluded indexes, and hidden indexes for these can be mapped.
Send good-looking, foxy, graceful, and taking goods regarding holiday rentals, rental houses, vacation homes in Steamboat Springs Colorado, and Steamboat Springs Colorado apartments for rent found on FRBO.com.
|
|
