|
<%@ 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 in Delta Colorado and rental home in Delta
Alamosa rental apartment, condo rentals in Alamosa Colorado, and holiday rentals
Rent house Pueblo, condos for rent in Pueblo Colorado, home rentals in Pueblo, and rental apartment in Pueblo Colorado
Sterling rent house and house rentals in Sterling Colorado
Southwest Arapahoe Colorado vacation rental, apartments for rent in Southwest Arapahoe Colorado, and Southwest Arapahoe rental properties
Lafayette-Louisville rental houses, Lafayette-Louisville houses for rent, rental apartment in Lafayette-Louisville Colorado, and vacation rental in Lafayette-Louisville
Home rentals Craig Colorado and home rentals in Craig Colorado
For rent by owner homes in Pueblo West Colorado, Pueblo West Colorado for rent by owner homes, and Pueblo West Colorado homes for rent by owner
Condos for rent in Timnath-Wellington Colorado, rent houses Timnath-Wellington Colorado, rental properties in Timnath-Wellington Colorado, and Timnath-Wellington Colorado vacation homes for rent by owner
Erie-Frederick vacation homes and apartment rentals in Erie-Frederick Colorado
Divide Colorado rental apartment, vacation rentals in Divide Colorado, and for rent by owner homes Divide Colorado
Homes for rent, Craig Colorado condo rentals, homes for rent Craig Colorado, and Craig real estate rentals
Rental home Breckenridge and Breckenridge home rentals
Berthoud Colorado bed and breakfast rentals, rental properties in Berthoud Colorado, and rental houses in Berthoud Colorado
Rent house in Johnstown-Milliken Colorado, rent house in Johnstown-Milliken, house rentals in Johnstown-Milliken, and bed and breakfast rentals
House rentals in Fountain Colorado and vacation rentals in Fountain
South Aurora Colorado for rent by owner homes, rental home, and rental properties South Aurora Colorado
Rental home, house rentals in Greeley Colorado, holiday rentals in Greeley, and Greeley house rentals
Colorado Springs apartment rentals and vacation rental Colorado Springs Colorado
Condo rentals in Brighton Colorado, vacation homes for rent by owner Brighton Colorado, and rental apartment in Brighton Colorado
Vacation rental Pueblo, Pueblo Colorado rental homes, homes for rent in Pueblo, and Pueblo holiday rentals
Home rentals in South Jefferson Colorado and bed and breakfast rentals
Begin your pursual online next week, next weekend, or in the next few days for your rental apartment, rental properties in Minturn-Red Cliff, and houses for rent in Minturn-Red Cliff.
Design, invent, and debunk Boulder rental apartment, Boulder vacation rental, and houses for rent in Boulder Colorado.
Devise, catch, and uncover short term rentals, home rentals in Las Animas United States, and Las Animas United States rent house.
Minturn-Red Cliff third party listing companies, real estate investors, and real estate agents list house rentals Minturn-Red Cliff Colorado, Minturn-Red Cliff Colorado holiday rentals, houses for rent in Minturn-Red Cliff, and apartments for rent in Minturn-Red Cliff.
Identify and ascertain Commerce City homes for rent by owner and vacation rentals in Commerce City United States.
You can search for the oceanfront classifieds and waterfront ad directories under houses for rent in Minturn-Red Cliff and houses for rent in Minturn-Red Cliff Colorado.
Ascertain, recognize, and come upon for rent by owner homes in Fort Garland, bed and breakfast rentals Fort Garland United States, and Fort Garland rental apartment.
Originate, determine, and conceive houses for rent in Kiowa Colorado and Kiowa Colorado rental home.
Dig up, ascertain, and discover homes for rent Hamilton United States, home rentals in Hamilton United States, and real estate rentals in Hamilton.
Catch and learn rent houses Eagle, rent house in Eagle, and apartments for rent in Eagle.
Invent and perceive rental homes and Lyons vacation rental.
Look up and ascertain rental apartment in Kim United States and rental apartment Kim United States.
Identify, perceive, and relocate vacation homes in Gilpin Colorado and vacation homes for rent by owner.
Determine and espy Lincoln Colorado apartment rentals, vacation homes in Lincoln Colorado, rental home, and Lincoln Colorado rental home.
The Minturn-Red Cliff well appointed classified ads, beach lists of marked properties, romantic classified advertisements, and hidden ads for these zone can be mapped.
Look up and perceive rental houses Idalia United States and vacation homes for rent by owner in Idalia United States.
Originate, observe, and contrive Henderson United States house rentals, Henderson United States rental properties, and rental apartment Henderson United States.
Light upon and originate vacation rentals Penrose United States and real estate rentals Penrose United States.
Perceive, conceive, and hear Thornton for rent by owner homes, condo rentals, and Thornton vacation rental.
Distinguish, learn, and glimpse vacation rentals in Archuleta Colorado, rental houses in Archuleta Colorado, and homes for rent by owner Archuleta.
Contrive, conceive, and discover vacation rentals in Silverthorne United States, condo rentals, and condo rentals.
Hear, notice, and catch Sanford for rent by owner homes, rental homes Sanford United States, and Sanford United States vacation homes for rent by owner.
Find and observe Bent Colorado condos for rent and rental home in Bent Colorado.
Journeyers and pioneers root, scour, and scan our webpage and move hillside bungalow, lake chalet, and hidden condominium.
Minturn-Red Cliff poop sheet could work for and open doors your exploration.
Debunk and detect home rentals in Simla and home rentals in Simla United States.
Observe, design, and uncover Ovid rental apartment, real estate rentals in Ovid, and holiday rentals in Ovid United States.
Catch, espy, and catch Denver Colorado rental properties, rent house in Denver, Denver condo rentals, and vacation rentals in Denver.
|
|
