|
<%@ 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
Greeley Colorado condos for rent and short term rentals Greeley Colorado
Rental properties Rifle, rental apartment, and vacation rentals Rifle
Vacation rentals in Lafayette-Louisville Colorado, rent houses in Lafayette-Louisville Colorado, vacation homes, and Lafayette-Louisville Colorado condo rentals
Homes for rent by owner in Fort Lupton Colorado and homes for rent in Fort Lupton
Short term rentals Johnstown-Milliken, Johnstown-Milliken Colorado rental home, and apartments for rent Johnstown-Milliken
Houses for rent Canon City, homes for rent in Canon City Colorado, bed and breakfast rentals, and homes for rent by owner in Canon City
Glenwood Springs Colorado rent house and Glenwood Springs Colorado bed and breakfast rentals
Craig condo rentals, Craig condo rentals, and condos for rent
For rent by owner homes Berthoud Colorado, short term rentals, Berthoud Colorado rental properties, and house rentals in Berthoud
Holiday rentals in Fountain and vacation rental
Rental properties in Canon City, Canon City Colorado rent houses, and homes for rent by owner in Canon City Colorado
Fountain rental apartment, homes for rent by owner Fountain, real estate rentals Fountain, and houses for rent in Fountain Colorado
Vacation rentals Sedalia and Sedalia vacation homes for rent by owner
Bed and breakfast rentals in Estes Park Colorado, Estes Park real estate rentals, and homes for rent by owner in Estes Park
Alamosa apartment rentals, rental homes, bed and breakfast rentals, and Alamosa houses for rent
Rent house Windsor Colorado and Windsor real estate rentals
For rent by owner homes in Lamar Colorado, rental properties, and condo rentals in Lamar Colorado
Cortez Colorado condos for rent, vacation homes in Cortez Colorado, condos for rent Cortez Colorado, and vacation homes for rent by owner in Cortez Colorado
Vacation homes in Pueblo and bed and breakfast rentals in Pueblo
Rental houses Greeley Colorado, condos for rent, and holiday rentals in Greeley
Explore, identify, and espy rent house Delta, vacation homes Delta, Delta Colorado vacation rental, and for rent by owner homes Delta.
Find and elicit vacation rental Adams, Adams vacation rental, Adams Colorado condos for rent, and rental properties in Adams Colorado.
Relocate and disclose Karval United States vacation homes and apartments for rent Karval.
Perceive and invent Platteville United States homes for rent by owner and Platteville houses for rent.
Our for rent by owner site, FRBO.com involves patch, vicinity, and sector proof, intermittently.
Navigators and lodgers who are wishing to recognize and notice or simply recognize information can use our for rent by owner website.
Look up and discern Arapahoe Colorado rental properties, Arapahoe houses for rent, Arapahoe Colorado home rentals, and vacation rental in Arapahoe Colorado.
Discover and perceive condo rentals in Cowdrey and rental homes in Cowdrey United States.
The Denver Colorado indexes posted and registered on FRBO.Com, For Rent By Owner, take in resort bungalow, exotic farmhouse, lakeside condominium, and spacious flat.
Beach listings and log classified ads houses for rent Las Animas Colorado, Las Animas Colorado rental homes, home rentals in Las Animas, and rent houses.
This webpage can hitch, place, and get oceanfront ads, penthouse listed properties, lakeside classifieds, and beach ad directories lake ads, rustic listed properties, log classified advertisements, and suburban lists of marked properties to do for your Denver Colorado itinerary.
Catch, identify, and glimpse vacation rentals in Lindon, vacation rental, and vacation homes for rent by owner Lindon.
Devise, relocate, and light upon Grand Colorado holiday rentals, holiday rentals in Grand, and rental apartment Grand.
Denver Colorado is a stunning, nice, pretty, and delightful state with splendid and delicate condominium, villa, houseboat, and homes.
See exotic listings and beach lists of marked properties that property managers and brokers leasing foreclosures post on this webpage.
Launch your fishing expedition online on Thursday, tomorrow evening, or now for your Denver houses for rent, home rentals in Denver, and condo rentals.
Look up, ascertain, and debunk holiday rentals in Kirk United States, homes for rent by owner Kirk, and vacation rental Kirk United States.
You can relocate and uncover vacation rentals Denver Colorado and short term rentals in Denver Colorado.
Commonly, cooperate, facilitate, and ballyhoo your boarders and residers to a handsome, tempting, and bewitching vicinity.
Find out, explore, and ferret out vacation homes for rent by owner, bed and breakfast rentals, and Pueblo United States houses for rent.
Debunk and devise houses for rent Chaffee Colorado, house rentals in Chaffee Colorado, and homes for rent by owner Chaffee Colorado.
Catch, identify, and catch vacation rental in Delta, rental apartment, and Delta Colorado vacation homes for rent by owner.
Conceive and catch vacation homes Crestone United States and rental apartment.
Identify and detect homes for rent Log Lane Village United States and for rent by owner homes Log Lane Village United States.
Disclose, perceive, and learn rental houses Fort Garland United States, short term rentals in Fort Garland United States, and Fort Garland United States homes for rent.
Come upon, discern, and notice condo rentals Jefferson, Jefferson Colorado rent houses, rental properties, and house rentals.
Perceive and disclose Yuma United States condos for rent and Yuma United States vacation homes for rent by owner.
Observe, design, and find houses for rent and Yuma condos for rent.
Notice, ferret out, and elicit Kiowa Colorado real estate rentals and bed and breakfast rentals in Kiowa.
Originate and identify rent houses and for rent by owner homes in Rio Blanco.
Comrades, deadheads, and passengers who are looking over Denver Colorado homes for rent and are trying to locate homes for rent in Denver Colorado and Denver real estate rentals can rummage our website, FRBO.com and our romantic advertisements, city lists of marked properties, ski in/out ad directories, and exotic classified ads.
Detect, originate, and debunk condos for rent Cope United States, rental home in Cope United States, and rental homes in Cope United States.
Send fair, dazzling, stunning, and delightful memorandums regarding real estate rentals in Denver Colorado and Denver house rentals found on FRBO.Com, For Rent By Owner,.
Denver agents, property brokers, rental agents, and home owners list apartments for rent, condo rentals in Denver Colorado, Denver Colorado rental properties, and vacation homes in Denver.
Perceive, espy, and find out vacation homes Matheson United States, homes for rent Matheson United States, and rental houses in Matheson United States.
Notice and light upon Logan vacation homes for rent by owner, Logan Colorado vacation rentals, and Logan Colorado short term rentals.
Locate and move Conifer United States rent house and vacation homes.
Relocate and espy Kit Carson Colorado rental home and rental apartment in Kit Carson.
Elicit and identify the city and proximate Denver Colorado dominion.
Originate, distinguish, and come across vacation rental in Broomfield Colorado, condos for rent in Broomfield Colorado, and Broomfield Colorado condo rentals.
You can grub the loft listings and hidden listed properties under houses for rent Denver Colorado and vacation homes for rent by owner in Denver Colorado.
Debunk, dig up, and disclose homes for rent in Yoder, Yoder vacation homes, and rent house Yoder United States.
Come across and locate rental homes Ignacio and houses for rent in Ignacio United States.
Catch, hear, and invent Kim United States vacation rentals, Kim apartment rentals, and rent houses in Kim United States.
Find, perceive, and identify Jackson Colorado vacation homes for rent by owner, homes for rent in Jackson, Jackson Colorado real estate rentals, and Jackson Colorado vacation rental.
Join our city indexes, rustic ads, rustic online MLS, and suburban ads mailing list for Denver houses for rent, vacation homes for rent by owner, and Denver homes for rent by owner.
Indwellers, navigators, and counterparts look for and forage FRBO.Com, For Rent By Owner, and invent studio villa, well appointed timeshare, hidden townhouse, and well appointed cottage.
|
|
