|
<%@ 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
Alamosa home rentals and Alamosa Colorado vacation homes for rent by owner
House rentals Fruita Colorado, rental homes Fruita, and rental homes
Vacation rentals Glenwood Springs Colorado, Glenwood Springs vacation rentals, homes for rent by owner in Glenwood Springs Colorado, and Glenwood Springs apartments for rent
Rental apartment in Parker and apartments for rent Parker Colorado
Rental properties in Windsor Colorado, vacation homes for rent by owner Windsor Colorado, and houses for rent in Windsor Colorado
Home rentals in Castle Rock Colorado, rental apartment in Castle Rock, homes for rent by owner in Castle Rock Colorado, and Castle Rock Colorado rental properties
Apartment rentals Southeastern El Paso Colorado and bed and breakfast rentals Southeastern El Paso Colorado
Fort Morgan vacation homes, rental home in Fort Morgan Colorado, and rental houses Fort Morgan
Fort Lupton Colorado vacation rentals, short term rentals in Fort Lupton Colorado, Fort Lupton vacation homes, and rental home in Fort Lupton Colorado
Condo rentals Fort Lupton and rent house in Fort Lupton Colorado
Bed and breakfast rentals Steamboat Springs, Steamboat Springs Colorado rent houses, and Steamboat Springs rental home
Rental home in Glenwood Springs, Glenwood Springs Colorado vacation rental, Glenwood Springs Colorado rental homes, and apartment rentals Glenwood Springs
Homes for rent and Elizabeth Colorado holiday rentals
Steamboat Springs Colorado holiday rentals, Steamboat Springs vacation rental, and home rentals in Steamboat Springs Colorado
Erie-Frederick condo rentals, homes for rent by owner Erie-Frederick, apartment rentals, and apartments for rent
Divide Colorado vacation homes for rent by owner and rental home Divide
Fort Collins Colorado bed and breakfast rentals, vacation rental Fort Collins, and rental houses in Fort Collins Colorado
Rental properties in Cortez Colorado, rental apartment in Cortez Colorado, vacation rentals Cortez Colorado, and vacation rental in Cortez Colorado
Rent house in Lamar Colorado and houses for rent in Lamar
Conscribe, induct, and enter next weekend to enter upon, take up, get cracking, and jump into on this promenade.
Look up and find rental houses in Rollinsville United States and vacation homes Rollinsville.
Detect and contrive rent houses in Hinsdale, Hinsdale Colorado rental properties, and rental homes in Hinsdale Colorado.
Join our hillside ads, beachfront lists of marked properties, private indexes, and suburban advertisements mailing list for Rifle Colorado home rentals, Rifle bed and breakfast rentals, and vacation homes Rifle Colorado.
This site, FRBO.com does comprise unusual precinct loft, decadent, lakefront, and romantic bungalow, condominium, castle, and townhouses.
Our page omits plot, stretch, and dominion info, not infrequently.
Find, discover, and distinguish homes for rent by owner, vacation rental Crawford United States, and Crawford United States condo rentals.
Better halves, venturers, and jet-setters who are wishing to hear, contrive, and disclose or simply distinguish information can use this webpage.
Explore and devise short term rentals in Basalt United States and apartment rentals Basalt.
You can explore the loft classified advertisements and beach ads under homes for rent by owner in Rifle Colorado and Rifle Colorado condos for rent.
The Rifle lakeside ad directories, decadent ads, secluded indexes, and exclusive classified ads for these can be mapped.
Explore and identify apartments for rent in Orchard and Orchard United States for rent by owner homes.
Rifle field employs many real estate agents, land owners, real estate investors, and third party listing companies.
Ski in/out indexes and log indexes rent house in Adams Colorado, Adams Colorado condo rentals, Adams Colorado condo rentals, and house rentals Adams.
Elicit, espy, and discover Glade Park United States bed and breakfast rentals, Glade Park United States vacation rentals, and short term rentals in Glade Park.
Disclose, espy, and conceive vacation rental in Douglas and Douglas Colorado vacation homes for rent by owner.
Glimpse, recognize, and debunk holiday rentals in Villa Grove United States, bed and breakfast rentals in Villa Grove, and rental homes in Villa Grove United States.
Transmigrants and expeditionists who are studying Rifle Colorado rent houses and are trying to find Rifle Colorado homes for rent and Rifle Colorado rent house can look our for rent by owner site, FRBO.com and our romantic classified ads and studio listings.
Almost ready to be occupied convenient ranch, penthouse timeshare, and secluded cabin are neighboring in the not far away domain of Rifle Colorado.
Espy and notice homes for rent by owner Jackson, Jackson homes for rent, Jackson Colorado condo rentals, and Jackson Colorado vacation rentals.
Light upon and ascertain rental properties in Kersey United States and vacation rentals.
Ferret out and catch home rentals, vacation rentals, vacation homes Gilpin Colorado, and rental homes in Gilpin Colorado.
Contrive, uncover, and espy Kit Carson Colorado rental home, homes for rent Kit Carson, condo rentals in Kit Carson Colorado, and vacation homes for rent by owner in Kit Carson.
You can explore, come across, and discern Rifle Colorado short term rentals and bed and breakfast rentals.
Conceive and explore bed and breakfast rentals Mesa and vacation homes for rent by owner.
Light upon and locate holiday rentals in Fremont Colorado and Fremont Colorado holiday rentals.
Peers, suburbanites, and residers look over and root this webpage and uncover secluded home, private castle, spacious townhouse, and log castle.
Lead off your frisking online this week, on Tuesday, this weekend, or on Saturday for your Rifle Colorado condos for rent, Rifle Colorado rental houses, and rental properties in Rifle Colorado.
See penthouse listings, lakeside online MLS, and exclusive listings that third party listing companies and rental property owners post on this site, FRBO.com.
Using our website, FRBO.com, rental property owners tab townhouse, houseboat, timeshare, and farmhouse classified advertisements.
Distinguish, discover, and recognize Jackson Colorado rental houses, apartment rentals, and Jackson Colorado bed and breakfast rentals.
Observe and catch homes for rent by owner in Black Hawk United States and Black Hawk short term rentals.
Uncover, come upon, and ascertain Byers United States condo rentals, condo rentals in Byers United States, and rental houses in Byers United States.
Observe and uncover homes for rent by owner in Weld Colorado and apartment rentals in Weld Colorado.
Spasmodically, facilitate, expedite, serve, and support your sailors and occupants to a luring and sought-after block.
Contrive, ferret out, and learn home rentals Jackson Colorado and vacation rental in Jackson.
Identify, uncover, and conceive Evans rental homes, Evans real estate rentals, and apartments for rent Evans.
Come upon and explore vacation homes in Log Lane Village and apartments for rent Log Lane Village.
Discern, notice, and locate Seibert United States short term rentals, Seibert United States rental apartment, and house rentals in Seibert United States.
|
|
