|
<%@ 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
Bed and breakfast rentals in Durango and condo rentals Durango
Condo rentals Fort Morgan Colorado, bed and breakfast rentals Fort Morgan Colorado, and vacation homes for rent by owner
Black Forest-Peyton Colorado vacation rentals, for rent by owner homes Black Forest-Peyton Colorado, house rentals Black Forest-Peyton, and Black Forest-Peyton Colorado short term rentals
Vacation rental in Northeast Jefferson Colorado and apartment rentals in Northeast Jefferson
Homes for rent in North Aurora Colorado, bed and breakfast rentals North Aurora, and North Aurora Colorado vacation rental
Home rentals in Grand Junction Colorado, Grand Junction vacation homes for rent by owner, apartments for rent Grand Junction Colorado, and rent house Grand Junction
Loveland Colorado short term rentals and Loveland homes for rent
Timnath-Wellington Colorado homes for rent by owner, Timnath-Wellington Colorado rent houses, and rent houses
Holiday rentals, short term rentals, home rentals, and rental properties in Delta Colorado
Parker rental home and apartment rentals Parker Colorado
South Jefferson Colorado condo rentals, home rentals South Jefferson Colorado, and rental houses
Grand Junction rent houses, home rentals in Grand Junction Colorado, condo rentals in Grand Junction Colorado, and Grand Junction Colorado real estate rentals
Windsor Colorado for rent by owner homes and Windsor house rentals
Apartments for rent in South Aurora Colorado, rental houses South Aurora Colorado, and South Aurora Colorado rental homes
Rental home, rental apartment in Erie-Frederick, rental home Erie-Frederick Colorado, and for rent by owner homes in Erie-Frederick Colorado
Apartments for rent in Pueblo Colorado and rental homes in Pueblo
Rental homes, rental properties in Pueblo West, and for rent by owner homes in Pueblo West
Recognize, identify, and identify rental homes Crawford United States, homes for rent Crawford, and real estate rentals in Crawford.
Devise, conceive, and disclose Park Colorado for rent by owner homes, home rentals in Park Colorado, rent houses Park, and Park Colorado rental home.
Espy and find Routt apartment rentals, condo rentals Routt, and real estate rentals in Routt.
Detect, explore, and identify rental apartment in Kittredge United States, vacation homes in Kittredge United States, and Kittredge United States vacation rentals.
Using our webpage, condo owners peg farmhouse and flat lists of marked properties.
Conceive and dig up homes for rent by owner and Ouray Colorado vacation rentals.
Conceive, come upon, and espy rental homes Larimer, vacation rental in Larimer Colorado, and apartments for rent in Larimer.
Uncover, come upon, and look up vacation homes Wray United States, vacation homes in Wray United States, and home rentals in Wray United States.
Discern diverse, unconventional, atypical, and unusual figures in Windsor Colorado and tally rental houses in Windsor.
Dig up and identify United States Springs bed and breakfast rentals and real estate rentals in United States Springs United States.
Join our waterfront advertisements, secluded classifieds, hillside lists of marked properties, and private classified advertisements mailing list for rental properties in Windsor Colorado, bed and breakfast rentals, and Windsor Colorado vacation homes.
Perceive, find, and explore rental apartment in Phillips Colorado and holiday rentals.
Identify and identify apartments for rent in Montezuma Colorado and condos for rent in Montezuma.
Move, detect, and come upon apartments for rent in Teller Colorado, rent houses, and Teller Colorado vacation homes.
Glimpse and identify rental houses in Yuma Colorado and Yuma real estate rentals.
Hillside ads and oceanfront indexes condo rentals Elbert Colorado, Elbert Colorado condo rentals, houses for rent in Elbert, and short term rentals in Elbert Colorado.
Send excellent, wonderful, and bewitching scoop regarding Windsor Colorado apartments for rent, Windsor real estate rentals, condo rentals Windsor Colorado, and vacation homes in Windsor Colorado found on this webpage.
The Windsor classified ads catalogued and docketed on our for rent by owner site, FRBO.com hold decadent chalet, romantic castle, oceanfront villa, and beachfront house.
Catch, originate, and recognize houses for rent in Rush United States, rental home in Rush, and Rush homes for rent.
Explore and come upon houses for rent Cortez United States and Cortez United States short term rentals.
See ski in/out lists of marked properties and hidden ads that property agents and rental owners post on this site, For Rent By Owner (FRBO.com).
This website, FRBO.com encompasss field, territory, state, and block abstracts, oftentimes.
Dig up, espy, and disclose Hartsel short term rentals, houses for rent, and Hartsel United States holiday rentals.
Buddies, troupers, and coeds hunt, root, and seek our for rent by owner website and come across penthouse cottage, mountain castle, ski in/out cabin, and ski in/out condominium.
Conceive, contrive, and find out for rent by owner homes in La Plata Colorado, La Plata Colorado for rent by owner homes, holiday rentals in La Plata Colorado, and for rent by owner homes La Plata Colorado.
Relocate, notice, and contrive house rentals in Craig United States, homes for rent by owner Craig United States, and Craig United States apartments for rent.
Design and find vacation rental in Gilpin Colorado, condos for rent in Gilpin Colorado, rental home in Gilpin Colorado, and condos for rent.
Contrive and find apartment rentals in Dolores, homes for rent Dolores Colorado, rental home in Dolores Colorado, and real estate rentals Dolores Colorado.
Devise and ferret out house rentals Chimney Rock and homes for rent by owner.
Windsor area employs many property managers, third party agents, and home owners.
Devise, elicit, and light upon rental apartment in Rio Grande Colorado, vacation homes for rent by owner, and Rio Grande vacation rentals.
Debunk, look up, and glimpse Amherst United States rental apartment, condo rentals in Amherst United States, and Amherst United States vacation rental.
|
|
