|
<%@ 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
Vacation rental Breckenridge Colorado and condo rentals Breckenridge
Pueblo Colorado vacation rental, apartment rentals, and holiday rentals Pueblo
Apartment rentals, rental properties in Windsor Colorado, Windsor houses for rent, and rental properties Windsor Colorado
Houses for rent and rental home
Fruita apartment rentals, Fruita Colorado vacation rentals, and house rentals in Fruita
Lamar Colorado rental houses, rental home in Lamar Colorado, Lamar vacation rentals, and homes for rent by owner in Lamar Colorado
Vacation rentals in Grand Junction and holiday rentals in Grand Junction
Durango Colorado rent houses, apartment rentals Durango Colorado, and rental homes Durango Colorado
Rental houses in Lafayette-Louisville Colorado, Lafayette-Louisville rental apartment, rental properties Lafayette-Louisville, and Lafayette-Louisville rental properties
Rifle Colorado rent house and for rent by owner homes
Glenwood Springs Colorado rental home, house rentals in Glenwood Springs Colorado, and rent houses Glenwood Springs
Rental houses in Fort Collins Colorado, rental apartment, apartment rentals in Fort Collins Colorado, and condo rentals in Fort Collins Colorado
Lafayette-Louisville vacation rentals and home rentals Lafayette-Louisville
Boulder rental homes, vacation homes for rent by owner Boulder Colorado, and vacation homes for rent by owner in Boulder Colorado
Brighton Colorado for rent by owner homes, Brighton Colorado homes for rent by owner, for rent by owner homes, and Brighton houses for rent
Minturn-Red Cliff condos for rent and real estate rentals in Minturn-Red Cliff Colorado
Vacation rentals, Southeastern El Paso apartment rentals, and homes for rent by owner Southeastern El Paso Colorado
Homes for rent by owner in South Aurora Colorado, vacation rentals in South Aurora, South Aurora Colorado apartment rentals, and South Aurora Colorado bed and breakfast rentals
For rent by owner homes in Pueblo Colorado and rental houses Pueblo Colorado
Holiday rentals in Southeastern El Paso Colorado, Southeastern El Paso Colorado short term rentals, and vacation homes Southeastern El Paso
Pueblo apartment rentals, apartments for rent in Pueblo Colorado, vacation rental in Pueblo Colorado, and homes for rent in Pueblo Colorado
Rental homes in Breckenridge Colorado and vacation homes in Breckenridge Colorado
House rentals Erie-Frederick Colorado, rent houses in Erie-Frederick Colorado, and Erie-Frederick rental home
Short term rentals South Aurora, bed and breakfast rentals in South Aurora, vacation rentals in South Aurora, and South Aurora Colorado rent house
Rent house Greeley Colorado and rental home Greeley Colorado
Rent house in Pueblo, Pueblo rent house, and Pueblo Colorado for rent by owner homes
Cortez holiday rentals, rental home in Cortez, condo rentals Cortez, and condo rentals in Cortez Colorado
Rental houses in Elizabeth and condo rentals in Elizabeth Colorado
South Aurora bed and breakfast rentals, South Aurora Colorado vacation homes, and rental homes in South Aurora
Vacation rental, Montrose Colorado house rentals, vacation homes for rent by owner in Montrose Colorado, and Montrose Colorado rental apartment
Homes for rent by owner in South Aurora Colorado and South Aurora Colorado home rentals
Rent house Northeast Jefferson, vacation rental Northeast Jefferson, and Northeast Jefferson vacation homes for rent by owner
Vacation homes for rent by owner in Central Jefferson Colorado and vacation homes Central Jefferson
Ascertain, find, and devise the vicinity and not to distant Elizabeth Colorado city.
Catch, dig up, and design home rentals in Baca Colorado, Baca Colorado home rentals, and homes for rent Baca Colorado.
Notice and discern Nederland United States home rentals and homes for rent in Nederland United States.
Vacation homes in Eagle Idaho, house rentals in Eagle, rent houses, and Eagle Idaho short term rentals
Using our site, FRBO.com, land owners docket house, cottage, townhouse, and apartment advertisements.
We reared and spawned this website, FRBO.com to be divine and lovely.
Find out and recognize San Juan Colorado houses for rent, real estate rentals San Juan Colorado, and San Juan rental properties.
Lakeside listings and ski in/out indexes short term rentals Bent Colorado, Bent bed and breakfast rentals, Bent Colorado homes for rent by owner, and real estate rentals in Bent Colorado.
Hear, observe, and design rent houses in Lazear United States, vacation homes for rent by owner in Lazear United States, and for rent by owner homes.
Condo rentals in Piscataway and Piscataway Maryland for rent by owner homes
Notice, discover, and catch rental properties Fountain, rental home Fountain United States, and homes for rent by owner Fountain United States.
For rent by owner homes in Grove City-Rotonda, Grove City-Rotonda homes for rent, short term rentals in Grove City-Rotonda Florida, and home rentals Grove City-Rotonda Florida
The Elizabeth Colorado secluded lists of marked properties, city indexes, and spacious lists of marked properties for these zone can be mapped.
Elizabeth Colorado is a superb, charming, and symmetrical neighborhood with gorgeous, fine, and admirable cabin, cabin, duplex, and lodges.
Identify, conceive, and come across homes for rent Alma, rental properties Alma United States, and for rent by owner homes Alma United States.
Determine and originate rental properties Rockvale United States and vacation homes in Rockvale United States.
Discern and detect homes for rent Hot Sulphur Springs United States and holiday rentals Hot Sulphur Springs.
Ferret out and discern homes for rent in Towaoc and Towaoc United States rental apartment.
Design, identify, and come upon Parker United States apartment rentals, homes for rent by owner in Parker United States, and Parker United States real estate rentals.
Observe and identify vacation homes for rent by owner in Buena Vista and condos for rent in Buena Vista.
Contrive bizarre, ad hoc, peculiar, and especial details in Elizabeth Colorado and tally real estate rentals in Elizabeth.
Get going your examination online tonight, on Sunday, on Monday, or now for your homes for rent in Elizabeth Colorado and homes for rent Elizabeth.
Our site, FRBO.com can muster, levy, conscribe, and reserve studio indexes, log classified advertisements, oceanfront classifieds, and decadent lists of marked properties lake classified ads, beachfront classifieds, and hidden lists of marked properties to plug your Elizabeth Colorado passage.
Design and disclose Greeley United States houses for rent and vacation homes.
Originate and catch Yuma Colorado rental houses, Yuma Colorado rental apartment, and Yuma Colorado vacation homes.
Distinguish, identify, and ferret out homes for rent by owner Mesa Colorado, bed and breakfast rentals, and rent houses in Mesa.
Disclose, design, and invent Montezuma Colorado rent houses and rent houses in Montezuma.
Elizabeth Colorado stretch employs many real estate investors and rental agents.
Rent houses and rental homes
Perceive and move condo rentals in Chimney Rock and short term rentals in Chimney Rock.
Uncover, design, and design Manzanola United States vacation rental, Manzanola rental home, and Manzanola real estate rentals.
Ascertain and identify bed and breakfast rentals in Paradox and homes for rent by owner in Paradox United States.
Originate and design Lyons United States vacation rental and vacation homes for rent by owner Lyons United States.
Discern, explore, and catch Brighton condo rentals, rental home in Brighton, and rental apartment.
Observe, determine, and light upon vacation rental in Hinsdale Colorado, Hinsdale rental home, Hinsdale vacation rental, and Hinsdale Colorado home rentals.
Come across and catch for rent by owner homes in Logan Colorado, Logan Colorado bed and breakfast rentals, holiday rentals Logan, and apartments for rent Logan.
Perceive, move, and dig up Carbondale United States houses for rent, house rentals in Carbondale United States, and Carbondale houses for rent.
Intermittently, plug and do for your traveling men and globetrotters to a huge and seductive turf.
Send elegant and fine goods regarding rental houses Elizabeth and vacation homes in Elizabeth found on FRBO.Com, For Rent By Owner,.
Distinguish, espy, and conceive home rentals Maher, real estate rentals Maher United States, and Maher United States homes for rent by owner.
Condos for rent, Crossville rental apartment, and short term rentals in Crossville Tennessee
Recognize, design, and come across rental home Hartsel, Hartsel condos for rent, and homes for rent in Hartsel.
|
|
