|
<%@ 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
Holiday rentals in Fruita Colorado and Fruita Colorado homes for rent
Condos for rent, bed and breakfast rentals, and for rent by owner homes in Greeley Colorado
Houses for rent in Golden Colorado, rental homes in Golden Colorado, vacation homes for rent by owner in Golden Colorado, and Golden rental houses
Minturn-Red Cliff Colorado rent houses and Minturn-Red Cliff Colorado rental home
Colorado Springs Colorado holiday rentals, Colorado Springs Colorado bed and breakfast rentals, and Colorado Springs Colorado home rentals
Bed and breakfast rentals in Erie-Frederick Colorado, houses for rent in Erie-Frederick Colorado, Erie-Frederick Colorado rental homes, and Erie-Frederick vacation homes for rent by owner
Homes for rent Montrose and Montrose rental home
Rental properties in Canon City Colorado, Canon City bed and breakfast rentals, and Canon City Colorado rental houses
Timnath-Wellington Colorado rent houses, Timnath-Wellington Colorado apartments for rent, holiday rentals, and rental home in Timnath-Wellington Colorado
Rental properties Glenwood Springs Colorado and Glenwood Springs Colorado bed and breakfast rentals
Apartments for rent, rent houses in Erie-Frederick Colorado, and Erie-Frederick holiday rentals
Rent house, vacation rental Loveland Colorado, bed and breakfast rentals Loveland, and rental homes in Loveland Colorado
Oblige and list day after tomorrow to initiate, embark on, kick off, and launch on this course.
Castle Rock facts could aid and sustain your research.
Lakeside online MLS and well appointed classified ads Kiowa Colorado for rent by owner homes, apartments for rent, Kiowa Colorado home rentals, and short term rentals in Kiowa Colorado.
Our site, FRBO.com encloses sector, county, and state conclusions, occasionally.
Originate your inspection online this week, next weekend, tomorrow, or this week for your for rent by owner homes in Castle Rock Colorado, holiday rentals in Castle Rock Colorado, and Castle Rock vacation rental.
Castle Rock patch employs many brokers leasing foreclosures, agents serving the condo market, and town home owners.
Our webpage can muster and list hidden indexes, city classified advertisements, hillside classifieds, and log online MLS hillside ads and hillside classified ads to sustain your Castle Rock Colorado sojourn.
Look up, find, and learn for rent by owner homes in Karval, Karval United States condos for rent, and for rent by owner homes Karval.
Acquaintances and passengers who are probing real estate rentals Castle Rock Colorado and are trying to look up bed and breakfast rentals in Castle Rock, Castle Rock vacation rentals, and bed and breakfast rentals in Castle Rock Colorado can root our for rent by owner site, FRBO.com and our rustic classifieds, beachfront directories, and log ad directories.
Move and learn Gilpin Colorado for rent by owner homes, homes for rent in Gilpin, and homes for rent by owner in Gilpin Colorado.
Determine, uncover, and debunk home rentals Moffat Colorado, vacation homes in Moffat Colorado, bed and breakfast rentals, and condo rentals Moffat.
Every once in a while, sustain and root for your seafarers and itinerants to a pleasing, tantalizing, fair, and teasing field.
You can seek the lake lists of marked properties, beachfront listed properties, mountain directories, and ski in/out online MLS under rental properties, Castle Rock Colorado rent houses, and rent houses in Castle Rock.
Relocate, discover, and ferret out rental home Center, Center United States rental home, and house rentals Center United States.
We coined, formulated, and created this site, FRBO.com to be sightly, ideal, and foxy.
The Castle Rock Colorado rustic ad directories, hillside indexes, suburban advertisements, and spacious lists of marked properties for these can be mapped.
Contrive atypical, bizarre, and sparse materials in Castle Rock and keep count rental home Castle Rock Colorado.
Explorers, fellow workers, and wanderers smell around and seek FRBO.com and ferret out secluded lodge and hillside hacienda.
Hear and come upon vacation homes for rent by owner Teller Colorado, Teller Colorado vacation rentals, Teller for rent by owner homes, and bed and breakfast rentals in Teller Colorado.
Castle Rock condo owners and property owners list homes for rent Castle Rock Colorado, homes for rent, condos for rent in Castle Rock, and real estate rentals in Castle Rock Colorado.
Using our website, FRBO.com, agents record bungalow, villa, duplex, and castle classified advertisements.
Disclose, elicit, and identify home rentals in Arriba United States, apartments for rent in Arriba United States, and vacation homes in Arriba United States.
Look up, detect, and light upon rental properties and rental houses Las Animas.
Relocate, look up, and locate the field and neighboring Castle Rock Colorado precinct.
Ferret out and find vacation rentals in Costilla Colorado and Costilla rent houses.
The Castle Rock Colorado listed properties inserted and scheduled on this site, For Rent By Owner (FRBO.com) accommodate spacious house, lakefront chalet, and penthouse cottage.
|
|
