|
<%@ 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 Berthoud Colorado vacation rentals
Rental apartment, house rentals, and apartments for rent in Lafayette-Louisville Colorado
Rental homes in Johnstown-Milliken Colorado, rental apartment in Johnstown-Milliken Colorado, Johnstown-Milliken rental home, and for rent by owner homes in Johnstown-Milliken Colorado
Minturn-Red Cliff Colorado home rentals and rental properties Minturn-Red Cliff
Homes for rent by owner, South Jefferson Colorado for rent by owner homes, and for rent by owner homes South Jefferson Colorado
Alamosa Colorado rental apartment, vacation homes in Alamosa Colorado, homes for rent by owner Alamosa, and rental properties in Alamosa
Apartment rentals and vacation homes in Johnstown-Milliken Colorado
For rent by owner homes Johnstown-Milliken Colorado, rent house in Johnstown-Milliken, and homes for rent
Rent houses Fruita Colorado, homes for rent in Fruita, rental homes in Fruita Colorado, and Fruita Colorado rental properties
Vacation homes for rent by owner in Erie-Frederick Colorado and Erie-Frederick house rentals
Castle Rock homes for rent by owner, rent houses in Castle Rock, and homes for rent in Castle Rock
Rent houses in Pueblo West Colorado, Pueblo West condos for rent, real estate rentals in Pueblo West, and rental houses in Pueblo West
Rent houses Rifle and Rifle rental houses
Houses for rent, real estate rentals in Alamosa Colorado, and apartments for rent Alamosa
Fort Morgan Colorado houses for rent, rental apartment in Fort Morgan Colorado, condo rentals Fort Morgan Colorado, and Fort Morgan Colorado for rent by owner homes
Real estate rentals in Lamar Colorado and Lamar Colorado for rent by owner homes
Relocate and locate Pueblo holiday rentals and vacation homes for rent by owner Pueblo Colorado.
Discover, ferret out, and contrive rental apartment Silverthorne, Silverthorne apartment rentals, and rent houses.
Pueblo Colorado notes could back, thump, and work with your frisking.
Join our secluded ads, city listings, and lake lists of marked properties mailing list for bed and breakfast rentals in Pueblo and homes for rent in Pueblo Colorado.
Dig up, notice, and find out homes for rent, vacation rentals in Alamosa, and house rentals.
Locate and disclose Padroni United States rental apartment and Padroni United States vacation homes for rent by owner.
Send good-looking, alluring, pleasing, and pretty conclusions regarding bed and breakfast rentals in Pueblo Colorado, apartments for rent Pueblo, vacation rentals, and Pueblo rental houses found on our page.
Learn, recognize, and ascertain apartments for rent Broomfield United States, Broomfield United States homes for rent by owner, and Broomfield United States rental homes.
Recently vacated beach bungalow, loft farmhouse, and romantic vacation home are not far away in the neighboring turf of Pueblo.
Uncover, identify, and debunk vacation homes, rental houses, and Lincoln rental properties.
Originate and find out rental houses Lincoln Colorado and Lincoln Colorado house rentals.
Launch your expedition online next weekend or tonight for your Pueblo Colorado apartments for rent, rental homes in Pueblo, and rental houses in Pueblo Colorado.
Look up, locate, and uncover Berthoud vacation homes, Berthoud United States vacation homes for rent by owner, and apartments for rent in Berthoud United States.
See resort online MLS and decadent classified ads that real estate investors and home owners post on FRBO.Com, For Rent By Owner,.
Detect and recognize vacation homes in Cheyenne Colorado, short term rentals in Cheyenne Colorado, and rent house Cheyenne Colorado.
|
|
