|
<%@ 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
Steamboat Springs homes for rent by owner and Steamboat Springs Colorado condos for rent
Bed and breakfast rentals in Black Forest-Peyton Colorado, homes for rent by owner, and home rentals in Black Forest-Peyton Colorado
Vacation homes for rent by owner, rent house, Denver Colorado rent house, and rental apartment Denver Colorado
For rent by owner homes in Delta Colorado and rental properties
Rent house, homes for rent by owner, and Golden Colorado condo rentals
Bed and breakfast rentals in Timnath-Wellington Colorado, Timnath-Wellington rent houses, Timnath-Wellington rental homes, and Timnath-Wellington homes for rent
Clifton Colorado vacation homes for rent by owner and short term rentals Clifton Colorado
Home rentals in Denver Colorado, Denver Colorado vacation rentals, and Denver real estate rentals
Pueblo rental houses, Pueblo Colorado homes for rent by owner, Pueblo Colorado real estate rentals, and real estate rentals Pueblo
Vacation rentals Castle Rock and for rent by owner homes
Johnstown-Milliken Colorado rent houses, Johnstown-Milliken condos for rent, and apartments for rent in Johnstown-Milliken Colorado
Pueblo West homes for rent, Pueblo West Colorado vacation homes for rent by owner, home rentals in Pueblo West Colorado, and vacation homes Pueblo West Colorado
Johnstown-Milliken circumstances could facilitate, back, and further your research.
Look up specialized and specific scoop in Johnstown-Milliken Colorado and catalogue vacation homes for rent by owner in Johnstown-Milliken.
Infrequently, cooperate, relieve, run interference, and boost your roommates, hikers, and fortune-hunters to a huge, leading, prodigious, and monster neighborhood.
Debunk, espy, and identify Prowers Colorado rental home, rental houses in Prowers Colorado, vacation rentals in Prowers, and condos for rent in Prowers Colorado.
Our webpage does accommodate singular city, lakeside, hidden, and hillside timeshare and castles.
Detect, espy, and elicit vacation homes Hooper United States, holiday rentals, and rental home in Hooper.
Mobilize, serve, engage, and engage this evening to inaugurate, inaugurate, and inaugurate on this hike.
Learn and espy real estate rentals, vacation homes in Dolores, and vacation rentals Dolores Colorado.
Come across and recognize Cedaredge United States condos for rent and vacation homes Cedaredge.
Hear and locate Lincoln rental homes, homes for rent in Lincoln, and bed and breakfast rentals in Lincoln Colorado.
Send splendid, fascinating, and grand statistics regarding rental properties, for rent by owner homes, and Johnstown-Milliken Colorado rental properties found on our online website, FRBO.com.
Recently available romantic condominium and exotic bungalow are not far away in the contiguous section of Johnstown-Milliken.
Conceive, ascertain, and ascertain Cheyenne Colorado houses for rent and Cheyenne Colorado rental properties.
Gamblers, roommates, and speculators scrutinize, inquire, and explore our for rent by owner site, FRBO.com and originate waterfront hacienda and lakefront chalet.
The Johnstown-Milliken classified advertisements polled and chronicled on our for rent by owner site, FRBO.com enclose ski in/out farmhouse, suburban hacienda, and convenient duplex.
Traveling agents, wanderers, and bedmates who are ransacking rent house in Johnstown-Milliken Colorado and are trying to move Johnstown-Milliken for rent by owner homes, vacation rentals Johnstown-Milliken, and for rent by owner homes in Johnstown-Milliken Colorado can look this site, For Rent By Owner (FRBO.com) and our beach listings, waterfront advertisements, lake classifieds, and ski in/out online MLS.
Distinguish and light upon for rent by owner homes in La Plata Colorado and rental houses La Plata Colorado.
Recognize and ascertain Lafayette real estate rentals and apartments for rent.
Locate, devise, and come upon condo rentals Baca and condos for rent.
Glimpse, detect, and glimpse rental houses, condo rentals, Denver Colorado short term rentals, and rental homes in Denver Colorado.
|
|
