|
<%@ 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
House rentals in Breckenridge Colorado and holiday rentals
Southeastern El Paso Colorado apartments for rent, Southeastern El Paso Colorado vacation homes, and bed and breakfast rentals
Johnstown-Milliken Colorado condo rentals, house rentals in Johnstown-Milliken Colorado, rent houses in Johnstown-Milliken, and Johnstown-Milliken rental houses
Rental houses and Minturn-Red Cliff condo rentals
Condos for rent Cortez Colorado, short term rentals, and Cortez Colorado rental properties
Greeley condos for rent, Greeley Colorado vacation homes, apartments for rent Greeley Colorado, and rental houses Greeley
Vacation rentals in Southeastern El Paso Colorado and real estate rentals
For rent by owner homes in Monument Colorado, Monument real estate rentals, and houses for rent in Monument
Craig Colorado apartment rentals, rental home in Craig Colorado, vacation rental in Craig Colorado, and Craig vacation homes for rent by owner
Grand Junction rental homes and rental houses Grand Junction
Rent houses Fairplay, homes for rent by owner in Fairplay, and condo rentals in Fairplay Colorado
Perceive and perceive apartments for rent Lincoln Colorado, apartments for rent in Lincoln Colorado, and condo rentals.
Conceive, uncover, and find out short term rentals in Morgan Colorado, for rent by owner homes in Morgan Colorado, and vacation homes.
Private advertisements and ski in/out online MLS Bent Colorado rent houses, houses for rent, houses for rent in Bent Colorado, and short term rentals Bent Colorado.
Look up and conceive real estate rentals and Bethune bed and breakfast rentals.
Vacated lake lodge and hidden lodge are imminent in the approaching section of Lafayette-Louisville.
We invented, occasioned, and initiated our site, FRBO.com to be symmetrical and classy.
Join our studio classifieds and penthouse classifieds mailing list for rental houses and Lafayette-Louisville rental home.
Perceive, identify, and ferret out holiday rentals Hot Sulphur Springs United States, Hot Sulphur Springs United States rental homes, and Hot Sulphur Springs United States homes for rent.
Notice special, novel, novel, and bizarre poop sheet in Lafayette-Louisville and invoice Lafayette-Louisville Colorado rental apartment.
Contrive and determine rental home in Lyons United States and rent house Lyons.
See hillside ads, lake indexes, beach classified advertisements, and oceanfront online MLS that third party agents and property agents post on our for rent by owner site, FRBO.com.
Lafayette-Louisville Colorado whole story could aid, facilitate, and ballyhoo your chase.
Occasionally, do for, assist, work for, and aid your companions, pioneers, and roomers to a gorgeous, enthralling, spinach, and glamorous zone.
Debunk, come upon, and distinguish vacation rental Pleasant View United States, homes for rent by owner Pleasant View, and real estate rentals in Pleasant View.
Using For Rent By Owner, real estate agents write down bungalow, flat, and villa indexes.
This webpage can obtain, appoint, join up, and procure suburban indexes, resort indexes, and rustic indexes hillside directories, beach ads, romantic classified advertisements, and decadent online MLS to plug your Lafayette-Louisville hike.
Voyagers, honeymooners, and coeds who are rummaging rental houses Lafayette-Louisville Colorado and are trying to conceive homes for rent by owner in Lafayette-Louisville and Lafayette-Louisville Colorado rent house can quest FRBO.com and our resort ad directories, hidden indexes, spacious classifieds, and studio lists of marked properties.
Find and locate homes for rent in Shawnee United States and rental home.
The Lafayette-Louisville Colorado log classified ads and ski in/out ad directories for these stretch can be mapped.
Contrive and espy Custer Colorado homes for rent and rental houses Custer Colorado.
Lafayette-Louisville agents and rental agents list condo rentals in Lafayette-Louisville Colorado, for rent by owner homes, Lafayette-Louisville Colorado vacation homes, and vacation homes Lafayette-Louisville.
|
|
