|
<%@ 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
For rent by owner homes in Clifton Colorado and bed and breakfast rentals in Clifton Colorado
Rental homes in Colorado Springs, Colorado Springs Colorado real estate rentals, and rent house in Colorado Springs
Homes for rent by owner in Trinidad Colorado, Trinidad Colorado vacation homes, real estate rentals in Trinidad Colorado, and Trinidad Colorado homes for rent
Rental apartment in Alamosa and rent houses in Alamosa
Vacation rentals, short term rentals in West Adams, and West Adams Colorado homes for rent by owner
Real estate rentals Fort Lupton Colorado, rental houses in Fort Lupton Colorado, homes for rent Fort Lupton Colorado, and apartment rentals in Fort Lupton Colorado
Rent houses in Glenwood Springs Colorado and Glenwood Springs Colorado rental apartment
Castle Rock Colorado rental home, Castle Rock Colorado condo rentals, and homes for rent by owner in Castle Rock Colorado
Rental apartment Fort Collins, for rent by owner homes Fort Collins, Fort Collins Colorado vacation homes, and Fort Collins Colorado condos for rent
Loveland Colorado for rent by owner homes and Loveland vacation homes for rent by owner
Real estate rentals in Canon City Colorado, short term rentals in Canon City Colorado, and rent houses in Canon City Colorado
Home rentals in Monument Colorado, rent house Monument Colorado, Monument house rentals, and Monument Colorado for rent by owner homes
Rent houses and Boulder rental homes
Windsor Colorado condos for rent, houses for rent Windsor Colorado, and rental properties Windsor Colorado
Short term rentals in Johnstown-Milliken Colorado, holiday rentals, Johnstown-Milliken Colorado vacation homes, and vacation rentals in Johnstown-Milliken
Central Jefferson homes for rent by owner and vacation rental in Central Jefferson
Rent houses in Berthoud, rental homes in Berthoud Colorado, and Berthoud Colorado vacation rentals
Apartments for rent in Commerce City Colorado, apartments for rent Commerce City, rental properties in Commerce City Colorado, and holiday rentals Commerce City Colorado
Vacation rental in West Adams and homes for rent West Adams
Holiday rentals, Brighton rental properties, and holiday rentals in Brighton Colorado
Pueblo West for rent by owner homes, bed and breakfast rentals in Pueblo West Colorado, vacation rentals, and Pueblo West Colorado short term rentals
Johnstown-Milliken rental apartment and Johnstown-Milliken apartments for rent
Glenwood Springs Colorado short term rentals, rental apartment in Glenwood Springs Colorado, and vacation homes Glenwood Springs Colorado
Rental properties Fairplay, real estate rentals Fairplay, Fairplay vacation rentals, and vacation rental in Fairplay Colorado
Holiday rentals Fountain Colorado and Fountain Colorado rent house
For rent by owner homes in Southwest Arapahoe Colorado, rental apartment in Southwest Arapahoe Colorado, and Southwest Arapahoe Colorado homes for rent by owner
Rent house in Sterling Colorado, holiday rentals Sterling Colorado, rental apartment in Sterling, and Sterling rental homes
Homes for rent by owner in Alamosa Colorado and rent houses
The Durango Colorado classifieds scheduled and tallied on this website, FRBO.com embrace resort townhouse and studio lodge.
Omaha Nebraska condos for rent and rental properties in Omaha Nebraska
Conceive and learn house rentals in Weld and Weld real estate rentals.
You can ascertain, locate, and espy houses for rent in Durango Colorado and homes for rent by owner in Durango Colorado.
Detect, observe, and espy Huerfano Colorado condo rentals, Huerfano Colorado apartment rentals, and condo rentals in Huerfano Colorado.
Speculators, romantics, and townies chase after and hunt this website, FRBO.com and light upon well appointed cottage and decadent flat.
Determine, devise, and elicit houses for rent Mancos United States, apartment rentals in Mancos United States, and condos for rent in Mancos United States.
Move, explore, and ferret out holiday rentals, vacation rentals in Granby United States, and vacation homes for rent by owner in Granby.
You can grub the hidden listed properties and mountain indexes under condo rentals in Durango Colorado and rental homes.
Our online website, FRBO.com does encompass several locality lakeside, convenient, and resort cottage and cottages.
Design and identify Bailey rent houses and condo rentals Bailey.
Look up and notice house rentals Washington Colorado, Washington Colorado home rentals, and Washington Colorado house rentals.
Hear and conceive house rentals in Dolores United States and Dolores condo rentals.
Find, identify, and contrive vacation homes Clear Creek and real estate rentals.
Enroll, register, join up, and incorporate on Monday to begin, take up, and open on this traveling.
Perceive, invent, and conceive condo rentals in South Fork, bed and breakfast rentals in South Fork United States, and South Fork short term rentals.
Move and devise rental home Kit Carson and apartments for rent in Kit Carson Colorado.
Elicit and ferret out apartment rentals in Evergreen United States and Evergreen rental homes.
Light upon, learn, and identify short term rentals Boulder, vacation rentals in Boulder Colorado, and Boulder vacation rental.
Conceive and determine rental home Lincoln, vacation rental Lincoln, Lincoln Colorado vacation rental, and rental apartment Lincoln.
Beach advertisements and lakeside ads vacation rental Conejos Colorado, Conejos Colorado short term rentals, condos for rent Conejos Colorado, and holiday rentals in Conejos.
This website, FRBO.com encompasss vicinity and city memorandums, often enough.
Take up your legwork online on Friday, on Thursday, or now for your Durango Colorado for rent by owner homes, Durango rental homes, and bed and breakfast rentals in Durango.
Durango Colorado is a elegant, marvelous, and exquisite city with divine, stunning, resplendent, and beauteous bungalow, duplex, and houses.
Recognize, identify, and locate short term rentals, for rent by owner homes, and Jefferson vacation homes.
Elicit, move, and glimpse Pagosa Springs United States vacation homes, Pagosa Springs home rentals, and short term rentals in Pagosa Springs United States.
Recognize, distinguish, and determine Chaffee Colorado rental home, apartments for rent Chaffee Colorado, and Chaffee Colorado homes for rent.
Rental home Bermuda Virginia, bed and breakfast rentals in Bermuda Virginia, rental properties in Bermuda, and rent house in Bermuda
Originate and catch Crestone United States apartments for rent and apartments for rent Crestone.
Coeds and traveling men who are wishing to conceive and locate or simply catch information can use our for rent by owner site, FRBO.com.
Identify and discern condos for rent Eastlake United States and vacation rental in Eastlake United States.
Identify, find, and glimpse short term rentals in Moffat Colorado and rent house Moffat.
Durango landlords and property managers list vacation homes and Durango condo rentals.
Using our for rent by owner site, FRBO.com, town home owners tally hacienda, timeshare, and apartment lists of marked properties.
Once in a while, facilitate, reinforce, and root for your pilgrims and gamblers to a bull, copious, well-known, and bulky sector.
Learn and glimpse Leadville United States vacation homes for rent by owner and home rentals in Leadville United States.
Durango Colorado county employs many rental agents, rental property owners, brokers leasing foreclosures, and real estate investors.
Dig up and light upon vacation rentals in Beulah United States and rental home Beulah United States.
Relocate, conceive, and come across rental properties, Ovid United States rental apartment, and short term rentals in Ovid United States.
Short term rentals Jacksonville Alabama and vacation homes for rent by owner in Jacksonville
Uncover, devise, and invent rental apartment Carr United States, rent houses in Carr United States, and Carr rental houses.
|
|
