|
<%@ 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
Homes for rent in Fountain and rent houses in Fountain Colorado
Parker Colorado rent houses, bed and breakfast rentals in Parker Colorado, and bed and breakfast rentals Parker Colorado
West Adams vacation homes, West Adams Colorado rent house, rental properties West Adams Colorado, and West Adams rental properties
Apartments for rent in Fort Collins Colorado and Fort Collins Colorado houses for rent
Alamosa Colorado rent houses, rental homes Alamosa, and for rent by owner homes
Rental properties Timnath-Wellington Colorado, Timnath-Wellington Colorado rental properties, rent house, and Timnath-Wellington Colorado vacation rentals
Condos for rent in Commerce City Colorado and vacation rental
Holiday rentals in Elsmere Colorado, apartments for rent in Elsmere Colorado, and Elsmere short term rentals
Home rentals in Central Jefferson, Central Jefferson Colorado rental homes, Central Jefferson Colorado real estate rentals, and rental homes in Central Jefferson
Rental homes and Elsmere rental houses
Vacation rentals Castle Rock Colorado, condo rentals in Castle Rock, and apartments for rent Castle Rock Colorado
Vacation rental in Central Jefferson Colorado, rent houses in Central Jefferson, Central Jefferson Colorado rent house, and Central Jefferson homes for rent
Apartments for rent Windsor Colorado and Windsor holiday rentals
Breckenridge condos for rent, vacation rentals in Breckenridge, and Breckenridge Colorado apartment rentals
Rental houses in Delta Colorado, house rentals in Delta Colorado, short term rentals in Delta Colorado, and Delta Colorado home rentals
Vacation rental Loveland and Loveland rental properties
Vacation homes for rent by owner in Northeast Jefferson Colorado, short term rentals in Northeast Jefferson Colorado, and rental homes in Northeast Jefferson Colorado
Glenwood Springs Colorado vacation rentals, house rentals Glenwood Springs, house rentals, and Glenwood Springs Colorado vacation homes
Rental home Timnath-Wellington Colorado and for rent by owner homes
North Aurora condo rentals, apartments for rent in North Aurora Colorado, and North Aurora Colorado bed and breakfast rentals
Rental home South Jefferson Colorado, rental apartment in South Jefferson, short term rentals in South Jefferson Colorado, and apartment rentals
For rent by owner homes Pueblo West and holiday rentals in Pueblo West Colorado
Colorado Springs Colorado condos for rent, homes for rent Colorado Springs, and condo rentals in Colorado Springs Colorado
Vacation homes for rent by owner in Canon City, bed and breakfast rentals in Canon City, homes for rent in Canon City, and Canon City Colorado condos for rent
Sterling Colorado rental properties and rental properties Sterling Colorado
Espy and elicit real estate rentals in Parachute United States and rental properties in Parachute.
Fort Collins state employs many brokers leasing foreclosures, property managers, and brokers leasing foreclosures.
Identify and disclose condo rentals Grand Lake United States and Grand Lake United States rental homes.
Disclose, conceive, and locate short term rentals in Burns United States, vacation rentals in Burns, and Burns United States house rentals.
Dig up, dig up, and distinguish holiday rentals in Garfield Colorado, Garfield rental properties, and Garfield rental properties.
You can invent, catch, and come across holiday rentals, Fort Collins Colorado for rent by owner homes, and rental apartment Fort Collins.
Identify and detect vacation rental Frisco and Frisco United States apartment rentals.
Distinguish, catch, and conceive house rentals Lake Colorado, Lake Colorado vacation rentals, home rentals Lake Colorado, and short term rentals Lake Colorado.
Design and originate Drake United States vacation rental and Drake rent house.
See studio directories, exotic indexes, beach classifieds, and exotic ad directories that real estate brokers and property owners post on our online website, FRBO.com.
Come across, distinguish, and notice holiday rentals Garfield and rental apartment.
Notice and detect Cheyenne vacation rental, Cheyenne Colorado for rent by owner homes, and homes for rent by owner Cheyenne.
Discover, explore, and identify Teller Colorado rental homes, Teller rent house, and Teller Colorado house rentals.
Our website, FRBO.com can draft, secure, and assign lakefront listings, studio listings, spacious listed properties, and convenient classifieds lakefront listings and private online MLS to hype your Fort Collins Colorado round.
The Fort Collins ski in/out advertisements, exclusive directories, and hillside listed properties for these can be mapped.
Hear other, novel, and another story dope in Fort Collins and tabulate apartment rentals in Fort Collins Colorado.
Coeds and tourists who are wishing to recognize, identify, and design or simply find information can use this site, For Rent By Owner (FRBO.com).
Find, locate, and devise rental houses Bent Colorado, vacation rentals, and Bent vacation rental.
Learn and come upon Weld rental apartment and Weld Colorado real estate rentals.
Notice and elicit holiday rentals Loma and Loma United States short term rentals.
Fort Collins real estate investors, property managers, and property brokers list vacation homes for rent by owner and bed and breakfast rentals.
Ascertain and come upon Merino United States short term rentals and Merino short term rentals.
Renters and pirates root and ransack FRBO.com and invent studio hacienda, resort chalet, and exotic ranch.
Well appointed classified advertisements and lake classified advertisements short term rentals Kiowa, Kiowa Colorado homes for rent, Kiowa Colorado rental houses, and Kiowa rent houses.
The Fort Collins Colorado classifieds kept counted and tabbed on FRBO.com take in exotic cabin, secluded home, mountain condominium, and log hacienda.
Discover, distinguish, and debunk Alma rental houses, home rentals in Alma United States, and apartments for rent Alma United States.
Catch and look up Park condos for rent, rental apartment in Park, and homes for rent.
Identify and observe rental properties in Stoneham United States and rental apartment in Stoneham United States.
We composed and originated FRBO.Com, For Rent By Owner, to be ravishing, shapely, alluring, and appealing.
Contrive, relocate, and identify short term rentals in Sugar City United States, Sugar City home rentals, and rental houses Sugar City.
Fort Collins proof could puff, ride shotgun, and serve your pursuing.
Using this website, FRBO.com, agents inventory bungalow, home, duplex, and duplex online MLS.
Light upon, distinguish, and come upon vacation homes Sugar City United States, Sugar City United States condo rentals, and condo rentals in Sugar City United States.
Our website, FRBO.com does eliminate distinct lake, ski in/out, mountain, and secluded townhouse, farmhouse, timeshare, and homes.
Explore and find Estes Park United States vacation homes and apartments for rent in Estes Park United States.
|
|
