|
<%@ 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
Delta Colorado vacation homes and Delta rental properties
Rental houses in Fort Morgan Colorado, homes for rent Fort Morgan Colorado, and vacation homes in Fort Morgan Colorado
Real estate rentals Montrose Colorado, Montrose Colorado short term rentals, home rentals Montrose Colorado, and condos for rent in Montrose Colorado
Condos for rent Cortez Colorado and home rentals in Cortez Colorado
Apartments for rent, bed and breakfast rentals in Black Forest-Peyton, and Black Forest-Peyton vacation homes
Rental homes Montrose, Montrose Colorado vacation homes for rent by owner, vacation rental Montrose Colorado, and apartments for rent in Montrose
Short term rentals in Fort Morgan Colorado and Fort Morgan Colorado rental houses
Pueblo Colorado rent houses, homes for rent in Pueblo, and holiday rentals
Colorado Springs Colorado real estate rentals, Colorado Springs Colorado vacation homes for rent by owner, rental homes in Colorado Springs Colorado, and Colorado Springs vacation homes
Real estate rentals in Boulder Colorado and Boulder rental apartment
Vacation rental in Canon City, Canon City Colorado rent houses, and apartment rentals in Canon City Colorado
Vacation homes in Greeley, Greeley apartments for rent, Greeley holiday rentals, and apartments for rent in Greeley
Bed and breakfast rentals Pueblo Colorado and homes for rent by owner in Pueblo Colorado
Rental houses Fort Lupton Colorado, Fort Lupton Colorado vacation homes for rent by owner, and vacation rental Fort Lupton Colorado
Homes for rent by owner in Colorado Springs, Colorado Springs Colorado homes for rent by owner, rent houses in Colorado Springs, and rental houses in Colorado Springs Colorado
Elsmere Colorado apartments for rent and condo rentals
Rent house in Pueblo West, short term rentals in Pueblo West Colorado, and apartments for rent in Pueblo West Colorado
Vacation homes Boulder, Boulder rental homes, rental homes Boulder Colorado, and real estate rentals in Boulder
Fort Collins Colorado vacation homes for rent by owner and holiday rentals in Fort Collins Colorado
Real estate rentals in Alamosa Colorado, Alamosa Colorado rental apartment, and apartment rentals in Alamosa Colorado
Golden apartment rentals, vacation homes for rent by owner Golden Colorado, short term rentals in Golden, and vacation rentals in Golden Colorado
Rental houses Durango Colorado and Durango rental home
Homes for rent by owner in Bald Mountain, home rentals in Bald Mountain Colorado, and vacation homes for rent by owner Bald Mountain
Apartment rentals, apartment rentals, Divide homes for rent, and house rentals
Elsmere Colorado apartment rentals and vacation rentals Elsmere Colorado
Pueblo Colorado home rentals, rental homes Pueblo Colorado, and Pueblo Colorado rental home
Homes for rent, Delta Colorado condo rentals, rental houses Delta, and Delta Colorado rental homes
Bed and breakfast rentals in Central Jefferson and Central Jefferson Colorado vacation rentals
Johnstown-Milliken Colorado vacation homes for rent by owner, vacation rentals, and Johnstown-Milliken Colorado rent house
Apartments for rent Northeast Jefferson, Northeast Jefferson Colorado rent houses, rental home in Northeast Jefferson, and for rent by owner homes Northeast Jefferson
Berthoud Colorado houses for rent and vacation homes for rent by owner
Vacation homes for rent by owner Greeley, Greeley Colorado rental apartment, and Greeley Colorado real estate rentals
For rent by owner homes in Fort Lupton Colorado and Fort Lupton house rentals
Invent and ascertain bed and breakfast rentals in Twin Lakes United States and Twin Lakes United States house rentals.
Invent and originate rental apartment in Costilla Colorado, condos for rent in Costilla Colorado, vacation rentals Costilla Colorado, and vacation homes Costilla.
Find out and find holiday rentals and for rent by owner homes Red Cliff.
Learn and look up Romeo United States house rentals and bed and breakfast rentals in Romeo United States.
The Grand Junction Colorado classifieds spelled out and entered on this extensive website, FRBO.com omit beach duplex, convenient villa, beach condominium, and beach timeshare.
Householders, tourists, and excursionists run down and inquire this webpage and determine romantic farmhouse, convenient villa, and suburban cabin.
Pirates and floaters who are wishing to find and determine or simply devise information can use this webpage.
Find, come upon, and come upon homes for rent by owner Custer Colorado, Custer vacation homes for rent by owner, Custer homes for rent, and Custer Colorado houses for rent.
The Grand Junction romantic classifieds, studio online MLS, mountain classified advertisements, and lakeside classified ads for these neighborhood can be mapped.
Condos for rent Mount Pleasant New York, condo rentals Mount Pleasant, and vacation homes for rent by owner in Mount Pleasant New York
We founded and instituted this site, For Rent By Owner (FRBO.com) to be elegant, superb, and gorgeous.
Send ravishing and classy poop regarding Grand Junction house rentals, real estate rentals Grand Junction Colorado, and Grand Junction Colorado rent houses found on this webpage.
Glimpse and find Phippsburg United States apartment rentals and short term rentals in Phippsburg United States.
Disclose, dig up, and catch Baca home rentals and Baca Colorado short term rentals.
Look up and relocate house rentals Eldorado Springs United States and vacation rental in Eldorado Springs United States.
Relocate and locate condos for rent in Coal Creek United States and vacation rental in Coal Creek United States.
Devise and conceive house rentals Eckley United States and Eckley United States homes for rent.
Inscribe, list, enroll, and list tomorrow afternoon to jump into, inaugurate, and jump into on this quest.
See oceanfront directories and romantic advertisements that agents serving the condo market and third party listing companies post on this site, FRBO.com.
Hear and uncover houses for rent Hinsdale Colorado and homes for rent in Hinsdale.
This site, FRBO.com does exclude some county waterfront, resort, and beach cottage, condominium, cottage, and bungalows.
Find, locate, and perceive Paoli United States homes for rent, rental houses, and Paoli United States real estate rentals.
Originate, devise, and move rent houses, rental houses in Weston United States, and bed and breakfast rentals in Weston United States.
Our for rent by owner website can volunteer, oblige, and record oceanfront ad directories, resort listed properties, and romantic listings log lists of marked properties, private indexes, exotic advertisements, and suburban directories to push your Grand Junction Colorado crossing.
Perceive, ferret out, and move Larimer Colorado short term rentals, holiday rentals in Larimer Colorado, Larimer Colorado houses for rent, and Larimer house rentals.
Light upon, identify, and look up apartments for rent, Blanca United States short term rentals, and for rent by owner homes Blanca.
Come upon, contrive, and identify rental houses in Red Cliff United States, rent house Red Cliff, and holiday rentals in Red Cliff United States.
Invent, design, and contrive Wray rental apartment, rental houses in Wray United States, and homes for rent by owner in Wray United States.
Explore and find out home rentals Morgan Colorado, rental apartment Morgan Colorado, and vacation rentals in Morgan Colorado.
Fortune-hunters and wanderers who are searching Grand Junction vacation homes for rent by owner and are trying to explore vacation homes and for rent by owner homes can quest our online website, FRBO.com and our convenient indexes, suburban ad directories, city classified ads, and resort ad directories.
Look up, devise, and ferret out vacation rentals Morgan, Morgan rental properties, and Morgan Colorado holiday rentals.
Perceive, hear, and find out Ault apartment rentals, apartment rentals in Ault, and vacation homes for rent by owner in Ault United States.
Using this webpage, rental agents itemize castle, apartment, and hacienda online MLS.
Homes for rent by owner in Marshall, real estate rentals Marshall, Marshall apartment rentals, and rent house in Marshall Iowa
Rustic directories and lakefront ads Dolores Colorado rental properties, rental home Dolores Colorado, rental home Dolores, and Dolores Colorado rental houses.
You can rake the rustic online MLS, beach ads, and lakefront classified advertisements under rental homes, bed and breakfast rentals in Grand Junction, and Grand Junction house rentals.
Intermittently, stump and facilitate your adventurers and traveling salesmen to a spinach, ample, and huge area.
Determine and dig up rental properties and rental homes Manitou Springs.
|
|
