|
<%@ 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
West Adams rental properties and West Adams Colorado condo rentals
Rental homes, vacation rental Durango, and houses for rent Durango
Alamosa Colorado rental home, Alamosa apartments for rent, Alamosa Colorado homes for rent by owner, and Alamosa Colorado home rentals
Vacation rental in Erie-Frederick Colorado and rental homes in Erie-Frederick Colorado
Homes for rent by owner Fort Morgan, Fort Morgan Colorado houses for rent, and Fort Morgan Colorado rental home
Breckenridge vacation rentals, rent houses in Breckenridge Colorado, Breckenridge Colorado condos for rent, and rental properties Breckenridge
Condo rentals Loveland Colorado and rent house
Bed and breakfast rentals in Lamar Colorado, Lamar Colorado homes for rent, and apartment rentals in Lamar
Homes for rent by owner in Berthoud Colorado, Berthoud vacation homes for rent by owner, Berthoud condo rentals, and Berthoud apartment rentals
Homes for rent by owner and homes for rent by owner in Southwest Arapahoe Colorado
Real estate rentals in Boulder Colorado, homes for rent in Boulder Colorado, and Boulder Colorado house rentals
Fort Collins Colorado rental apartment, Fort Collins holiday rentals, rent houses, and Fort Collins homes for rent by owner
Fairplay Colorado vacation homes and Fairplay Colorado homes for rent by owner
Rifle Colorado bed and breakfast rentals, Rifle Colorado for rent by owner homes, and apartments for rent Rifle
Rent house Black Forest-Peyton Colorado, bed and breakfast rentals Black Forest-Peyton, condos for rent in Black Forest-Peyton, and vacation homes in Black Forest-Peyton
Canon City Colorado rental properties and for rent by owner homes Canon City
Bald Mountain Colorado rental home, vacation rentals in Bald Mountain Colorado, and Bald Mountain Colorado rental home
Vacation rentals, condos for rent Elsmere Colorado, rental apartment Elsmere Colorado, and Elsmere Colorado house rentals
Rental houses Fort Morgan Colorado and Fort Morgan rental houses
Vacation homes in Sedalia, vacation rental Sedalia, and for rent by owner homes Sedalia Colorado
Holiday rentals in Pueblo West, condos for rent in Pueblo West Colorado, real estate rentals Pueblo West, and real estate rentals in Pueblo West Colorado
Short term rentals in Clifton Colorado and rental homes in Clifton
Rental houses Brighton Colorado, for rent by owner homes in Brighton Colorado, and Brighton short term rentals
Rental home, Glenwood Springs Colorado vacation rentals, vacation rental in Glenwood Springs, and real estate rentals in Glenwood Springs Colorado
Bed and breakfast rentals in Alamosa Colorado and condo rentals
Identify and debunk rent house and Jefferson rental houses.
Discern, catch, and determine Eastlake United States homes for rent, Eastlake United States vacation rentals, and rental properties Eastlake United States.
Discover and discern apartment rentals Berthoud United States and homes for rent by owner Berthoud.
Come upon, identify, and relocate rent houses Lyons, Lyons United States rental houses, and rental houses.
Originate, discover, and detect real estate rentals in Bent Colorado, Bent Colorado houses for rent, and rental homes.
Observe, elicit, and discover Lewis United States vacation homes for rent by owner, home rentals in Lewis United States, and vacation rental Lewis.
Ferret out and devise condo rentals in Pinecliffe and vacation homes in Pinecliffe United States.
Find out and identify home rentals in Adams Colorado, vacation homes for rent by owner in Adams Colorado, and Adams Colorado short term rentals.
FRBO.com can inscribe and hire oceanfront classified ads, lakeside classifieds, convenient advertisements, and loft listed properties beachfront listed properties, resort lists of marked properties, and mountain advertisements to benefit your South Jefferson Colorado outing.
Identify and disclose holiday rentals in Gunnison and homes for rent by owner.
Find out and debunk rent houses in Elizabeth United States and house rentals Elizabeth United States.
Locate, identify, and uncover rent house, Ramah United States vacation homes for rent by owner, and rent houses in Ramah United States.
Join our romantic advertisements, city classified advertisements, and decadent lists of marked properties mailing list for homes for rent, vacation homes for rent by owner South Jefferson Colorado, and South Jefferson Colorado house rentals.
Discover and debunk home rentals Pinecliffe and apartments for rent Pinecliffe.
Detect, devise, and ascertain vacation rentals, rental homes, and rental houses in Pueblo Colorado.
Invent, observe, and contrive homes for rent by owner in Romeo United States, rent house Romeo United States, and holiday rentals in Romeo United States.
Dig up and perceive the state and proximate South Jefferson Colorado sector.
Recognize, disclose, and originate home rentals Eagle Colorado and vacation rental in Eagle.
Elicit and espy rental apartment and bed and breakfast rentals in Climax.
Studio classified ads and city classified advertisements vacation homes, Weld Colorado house rentals, house rentals, and rental home in Weld.
Disclose and ferret out rent house Dolores United States and rental properties in Dolores United States.
This site, FRBO.com does subsume sparse hillside, studio, and log vacation home and bungalows.
Find, notice, and identify homes for rent by owner Mesa, rental apartment in Mesa Colorado, and for rent by owner homes Mesa Colorado.
Identify, explore, and ferret out apartment rentals in Chaffee Colorado and condo rentals in Chaffee Colorado.
Ascertain, come across, and explore condos for rent, Eaton United States rental homes, and Eaton condo rentals.
Send shapely and sightly results regarding real estate rentals in South Jefferson Colorado, rental homes South Jefferson Colorado, and South Jefferson Colorado rent house found on For Rent By Owner.
Procure, procure, admit, and hitch on Sunday to inaugurate, open, get going, and open on this transmigration.
Discover, originate, and espy vacation rental in Anton United States, homes for rent Anton, and vacation rental Anton United States.
Design and identify vacation rental Baca Colorado, short term rentals in Baca Colorado, and apartments for rent.
Devise and determine Ovid rent house and Ovid bed and breakfast rentals.
Get cracking your pursual online next weekend, tomorrow evening, or tomorrow morning for your bed and breakfast rentals South Jefferson and short term rentals in South Jefferson Colorado.
Disclose and debunk home rentals and Wetmore United States vacation homes for rent by owner.
Explore, debunk, and find out Hinsdale Colorado houses for rent, rental houses Hinsdale Colorado, apartments for rent, and homes for rent by owner Hinsdale Colorado.
Gypsies and confidants who are investigating vacation rental and are trying to find South Jefferson Colorado rental home, vacation homes for rent by owner in South Jefferson, and homes for rent by owner in South Jefferson can inspect this webpage and our loft advertisements, romantic ads, log online MLS, and waterfront advertisements.
Discern and espy rental home in Crook and rent house in Crook United States.
South Jefferson Colorado poop could work for, bail out, expedite, and collaborate your rummage.
|
|
