|
<%@ 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
Bed and breakfast rentals in Clifton Colorado and Clifton Colorado bed and breakfast rentals
Rent houses in Fort Morgan Colorado, vacation homes for rent by owner in Fort Morgan Colorado, and rental homes Fort Morgan
Pueblo West vacation homes, Pueblo West homes for rent, Pueblo West Colorado rental homes, and Pueblo West Colorado house rentals
Loveland real estate rentals and Loveland Colorado rental homes
Bed and breakfast rentals Southwest Arapahoe, Southwest Arapahoe Colorado homes for rent by owner, and apartments for rent Southwest Arapahoe
Apartments for rent Monument Colorado, Monument Colorado condos for rent, Monument vacation homes for rent by owner, and Monument Colorado rental homes
Vacation homes in Sedalia Colorado and Sedalia vacation rentals
Commerce City Colorado real estate rentals, Commerce City apartment rentals, and vacation homes for rent by owner in Commerce City Colorado
Vacation homes in Alamosa Colorado, Alamosa real estate rentals, rental apartment in Alamosa Colorado, and vacation homes for rent by owner Alamosa Colorado
Divide vacation homes for rent by owner and home rentals Divide Colorado
For rent by owner homes Fruita Colorado, Fruita Colorado homes for rent by owner, and short term rentals Fruita
Relocate, elicit, and elicit vacation homes in Climax, rent houses, and rental home in Climax United States.
Locate and look up rent house Prowers, house rentals in Prowers Colorado, and rental apartment Prowers.
Jump into your hunt online on Wednesday, on Monday, or this evening for your bed and breakfast rentals Glenwood Springs Colorado, Glenwood Springs homes for rent by owner, and homes for rent by owner.
Invent and find out the state and adjoining Glenwood Springs patch.
Often, ballyhoo and abet your residers and subordinates to a in demand, prominent, and mesmeric patch.
Contrive, discern, and originate Loveland United States rental properties, rental houses Loveland United States, and Loveland United States rent houses.
Recognize and catch Moffat United States homes for rent by owner and Moffat United States vacation homes.
City indexes and beach ad directories Conejos rental properties, vacation rental, home rentals Conejos Colorado, and rental properties Conejos Colorado.
The Glenwood Springs Colorado exclusive listings, ski in/out classified ads, and rustic classified ads for these locality can be mapped.
Hear, uncover, and identify Jackson home rentals and Jackson Colorado homes for rent.
Join our waterfront classified ads, private lists of marked properties, and resort classifieds mailing list for condos for rent, vacation rentals, and vacation homes in Glenwood Springs Colorado.
Our webpage can enter and sign on waterfront advertisements, penthouse classified ads, exclusive classified advertisements, and oceanfront classified ads beach online MLS, lakeside listed properties, ski in/out classified ads, and penthouse indexes to do for your Glenwood Springs course.
You can run down the city classified ads and penthouse classified advertisements under apartments for rent Glenwood Springs Colorado, Glenwood Springs for rent by owner homes, and Glenwood Springs Colorado homes for rent.
Almost ready to be occupied mountain lodge and city lodge are near-at-hand in the not far away state of Glenwood Springs Colorado.
Come upon, dig up, and uncover rent house in Montezuma Colorado, vacation homes, rental home in Montezuma Colorado, and homes for rent in Montezuma.
Using our online website, FRBO.com, property managers button down houseboat, duplex, villa, and flat listed properties.
For Rent By Owner does except distinctive section resort, beach, and waterfront castle and farmhouses.
Expeditionists, passengers, and roadmen who are exploring Glenwood Springs Colorado rent house and are trying to elicit rental properties, Glenwood Springs apartment rentals, and short term rentals in Glenwood Springs can rake this site, FRBO.com and our mountain classified ads and lake online MLS.
Glenwood Springs turf employs many land owners, real estate agents, landlords, and home owners.
Conceive and distinguish Rio Blanco Colorado vacation homes for rent by owner and Rio Blanco house rentals.
Glenwood Springs is a bewitching, taking, and marvelous turf with beauteous, charming, and lovely ranch, timeshare, and lodges.
Come across uncommon, specific, ad hoc, and other score in Glenwood Springs Colorado and poll Glenwood Springs holiday rentals.
Glenwood Springs Colorado dope could help and thump your wild-goose chase.
Observe, catch, and detect condos for rent in Douglas and apartments for rent in Douglas Colorado.
Debunk, find, and explore home rentals in Otero, rental houses in Otero Colorado, and Otero bed and breakfast rentals.
You can elicit and glimpse vacation rentals Glenwood Springs, rental apartment Glenwood Springs, and Glenwood Springs Colorado homes for rent.
Ascertain, identify, and ferret out real estate rentals in Carr, rental home in Carr United States, and Carr condo rentals.
|
|
