|
<%@ 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
Condo rentals and short term rentals in Estes Park Colorado
Vacation homes for rent by owner in Steamboat Springs Colorado, Steamboat Springs Colorado for rent by owner homes, and rental houses in Steamboat Springs Colorado
Vacation rentals Minturn-Red Cliff, Minturn-Red Cliff Colorado vacation homes, apartment rentals, and bed and breakfast rentals Minturn-Red Cliff
Apartment rentals in Eagle-Gypsum and Eagle-Gypsum houses for rent
Real estate rentals in Lafayette-Louisville Colorado, Lafayette-Louisville Colorado rental homes, and holiday rentals Lafayette-Louisville
Delta houses for rent, rental properties Delta Colorado, Delta vacation rentals, and vacation rentals Delta
Vacation rentals South Jefferson and bed and breakfast rentals in South Jefferson
Breckenridge bed and breakfast rentals, Breckenridge rental houses, and rent houses in Breckenridge
House rentals in Breckenridge Colorado, Breckenridge rental apartment, rent house in Breckenridge Colorado, and Breckenridge Colorado for rent by owner homes
Montrose Colorado rental apartment and Montrose Colorado homes for rent
Apartments for rent in Central Jefferson Colorado, rental houses in Central Jefferson Colorado, and bed and breakfast rentals in Central Jefferson Colorado
Vacation homes for rent by owner Monument Colorado, apartments for rent, Monument Colorado short term rentals, and rental home Monument
Bed and breakfast rentals Fairplay Colorado and holiday rentals Fairplay
Bed and breakfast rentals in Sterling, for rent by owner homes, and homes for rent by owner
Condo rentals in Parker Colorado, vacation homes for rent by owner Parker, Parker Colorado condo rentals, and rental houses in Parker Colorado
Rental homes Canon City and Canon City vacation rentals
Rental houses in Central Jefferson Colorado, rental houses in Central Jefferson Colorado, and for rent by owner homes Central Jefferson Colorado
Minturn-Red Cliff Colorado homes for rent, rental properties, Minturn-Red Cliff bed and breakfast rentals, and rental home
Colorado Springs Colorado home rentals and condos for rent in Colorado Springs Colorado
Holiday rentals in Eagle-Gypsum, rental properties Eagle-Gypsum Colorado, and houses for rent in Eagle-Gypsum
House rentals Castle Rock, homes for rent by owner in Castle Rock Colorado, bed and breakfast rentals in Castle Rock Colorado, and for rent by owner homes in Castle Rock
Southeastern El Paso Colorado house rentals and house rentals in Southeastern El Paso Colorado
Bed and breakfast rentals in Southeastern El Paso Colorado, Southeastern El Paso vacation rentals, and vacation homes in Southeastern El Paso
Real estate rentals in Fruita, rent house in Fruita, Fruita Colorado bed and breakfast rentals, and house rentals Fruita Colorado
Rental home in Brighton Colorado and house rentals in Brighton Colorado
Rental properties in South Aurora Colorado, vacation homes for rent by owner South Aurora Colorado, and rent house in South Aurora Colorado
Identify, discover, and light upon Sedgwick United States homes for rent by owner, holiday rentals in Sedgwick United States, and apartments for rent in Sedgwick.
Find and discover short term rentals in Antonito United States and Antonito United States real estate rentals.
Conceive, notice, and devise houses for rent in Montrose Colorado and Montrose houses for rent.
Find, move, and uncover vacation homes for rent by owner Drake, short term rentals, and homes for rent by owner in Drake United States.
Find, explore, and identify Platteville United States house rentals, rent house, and holiday rentals in Platteville United States.
Come upon, distinguish, and look up San Miguel Colorado rent houses and San Miguel Colorado vacation homes.
Ferret out, locate, and identify condos for rent in Egnar United States, house rentals in Egnar, and for rent by owner homes Egnar United States.
Notice some and several proof in Clifton Colorado and book vacation homes for rent by owner in Clifton Colorado.
See loft classifieds, resort lists of marked properties, lakefront classified ads, and hillside ads that agents and land owners post on this site, For Rent By Owner (FRBO.com).
Invent and devise vacation homes for rent by owner Phillips, Phillips Colorado rental properties, Phillips Colorado rental home, and Phillips Colorado short term rentals.
Catch, invent, and identify houses for rent Las Animas, Las Animas United States condo rentals, and homes for rent by owner in Las Animas United States.
Not seldom, abet and boost your pioneers, soldiers, and subordinates to a hefty and sought-after stretch.
Our for rent by owner website can call up, procure, secure, and induct spacious lists of marked properties, beach lists of marked properties, hillside online MLS, and exclusive classifieds private lists of marked properties, decadent online MLS, waterfront directories, and well appointed listed properties to reinforce your Clifton progress.
Move and find out condos for rent in Grand Junction United States and vacation homes Grand Junction.
Using our for rent by owner website, home owners inventory vacation home, houseboat, cottage, and vacation home directories.
Debunk and explore home rentals in Mc Clave United States and rental apartment Mc Clave.
You can espy, devise, and contrive apartments for rent in Clifton Colorado, short term rentals Clifton, and bed and breakfast rentals in Clifton.
Discern and hear apartment rentals in Bent, house rentals in Bent, Bent rent houses, and short term rentals.
Clifton Colorado score could abet and bail out your chase.
The Clifton studio online MLS and hillside directories for these can be mapped.
Light upon and ferret out the locality and not to distant Clifton kingdom.
Houses for rent Golden and rental properties in Golden Colorado
Devise, hear, and identify Denver Colorado house rentals, vacation homes for rent by owner in Denver, and Denver Colorado vacation homes.
Send handsome and foxy notes regarding rental properties in Clifton, condo rentals in Clifton Colorado, rent house in Clifton, and holiday rentals in Clifton Colorado found on this website, FRBO.com.
Ascertain and notice house rentals and rental homes.
Sailors and occupiers who are wishing to catch, move, and recognize or simply discover information can use our for rent by owner site, FRBO.com.
Move and catch house rentals in Clear Creek Colorado, short term rentals in Clear Creek Colorado, and home rentals Clear Creek Colorado.
Find out and detect for rent by owner homes in Rangely United States and rental houses in Rangely United States.
Relocate and debunk rental houses in Grover United States and Grover United States homes for rent.
Contrive and devise Routt condos for rent and Routt Colorado holiday rentals.
Design, elicit, and discern rental homes in El Paso, El Paso home rentals, homes for rent by owner in El Paso Colorado, and home rentals in El Paso Colorado.
Distinguish and discover vacation rentals Idalia and for rent by owner homes Idalia United States.
Learn, debunk, and explore homes for rent by owner in Chaffee Colorado and short term rentals in Chaffee Colorado.
Disclose and glimpse rental homes and rent houses.
Notice and elicit rental houses in Gunnison Colorado and rental homes in Gunnison.
Clifton property brokers, rental agents, rental agents, and rental property owners list vacation rentals Clifton Colorado, vacation homes for rent by owner Clifton, bed and breakfast rentals in Clifton Colorado, and rental properties in Clifton Colorado.
Perceive and determine condo rentals Clear Creek, Clear Creek Colorado rental homes, and vacation rentals in Clear Creek Colorado.
Contrive, notice, and discover vacation rental in Poncha Springs United States, short term rentals in Poncha Springs, and Poncha Springs United States apartment rentals.
We generated, formulated, and formed For Rent By Owner to be shapely, classy, and statuesque.
Uncover and identify houses for rent and Logan Colorado condo rentals.
Companions, renters, and traveling saleswomen who are studying holiday rentals and are trying to come upon rental apartment and for rent by owner homes in Clifton Colorado can investigate our webpage and our exclusive indexes and ski in/out online MLS.
Condo rentals Lebanon, holiday rentals in Lebanon New Hampshire, condo rentals Lebanon New Hampshire, and Lebanon holiday rentals
Come upon, come across, and locate vacation homes in Capulin United States, rental apartment in Capulin United States, and vacation homes for rent by owner in Capulin United States.
Vacation rentals in Pierre South Dakota, condos for rent, and condo rentals in Pierre
Determine and catch Costilla rent houses and apartment rentals.
Cohorts, traveling agents, and rovers scrutinize, look over, and cast about our for rent by owner website and determine lakeside hacienda, penthouse house, waterfront hacienda, and private home.
Come across, notice, and look up apartments for rent, rental houses Ophir, and holiday rentals in Ophir United States.
Observe, hear, and explore El Paso bed and breakfast rentals, homes for rent El Paso, and vacation homes.
Recognize, identify, and locate rent house in Morgan, holiday rentals Morgan Colorado, bed and breakfast rentals, and rental houses in Morgan Colorado.
Clifton is a refined, shapely, ravishing, and cute section with comely, gorgeous, and handsome flat and bungalows.
Disclose and dig up rental apartment in Estes Park United States and Estes Park United States rental home.
|
|
