|
<%@ 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
Condo rentals Southeastern El Paso Colorado and Southeastern El Paso Colorado rental properties
Vacation rental Breckenridge, Breckenridge Colorado condos for rent, and condo rentals in Breckenridge
Vacation homes in Rifle, Rifle Colorado short term rentals, real estate rentals, and bed and breakfast rentals Rifle Colorado
Short term rentals in Erie-Frederick Colorado and apartments for rent in Erie-Frederick
West Adams real estate rentals, West Adams for rent by owner homes, and apartment rentals West Adams
Rent house in Trinidad, Trinidad Colorado vacation rentals, Trinidad condo rentals, and for rent by owner homes Trinidad Colorado
Holiday rentals Parker Colorado and Parker Colorado vacation rentals
Longmont bed and breakfast rentals, rental apartment Longmont, and rent houses Longmont
Short term rentals Trinidad, homes for rent in Trinidad Colorado, Trinidad Colorado short term rentals, and bed and breakfast rentals
Longmont houses for rent and holiday rentals in Longmont Colorado
Rental houses in Trinidad Colorado, Trinidad Colorado rental houses, and Trinidad vacation homes
Castle Rock Colorado vacation rental, vacation rentals Castle Rock, Castle Rock Colorado condos for rent, and Castle Rock Colorado vacation homes for rent by owner
Rental home in Commerce City Colorado and Commerce City homes for rent
Homes for rent, houses for rent in South Jefferson, and South Jefferson rental homes
Northeast Jefferson Colorado rent house, houses for rent Northeast Jefferson, house rentals, and vacation rental in Northeast Jefferson Colorado
Durango Colorado homes for rent and Durango Colorado rental homes
Craig home rentals, rental apartment in Craig Colorado, and Craig Colorado vacation rentals
Rent house Fort Collins, Fort Collins Colorado apartment rentals, Fort Collins Colorado apartments for rent, and houses for rent
Alamosa short term rentals and houses for rent in Alamosa
Move and find Calhan United States rental properties and Calhan homes for rent by owner.
Relocate, notice, and elicit rental home in Cheyenne, rent house Cheyenne Colorado, rent house Cheyenne, and houses for rent Cheyenne Colorado.
Elicit and glimpse vacation homes for rent by owner and Julesburg United States condos for rent.
Displaced persons and hikers scout and cast about this extensive website, FRBO.com and ascertain loft timeshare, beach hacienda, hidden townhouse, and city houseboat.
North Aurora materials could run interference and ride shotgun your fishing expedition.
Our website, FRBO.com haves plot, tract, and square whole story, commonly.
Glimpse, explore, and locate Kremmling house rentals, bed and breakfast rentals in Kremmling United States, and for rent by owner homes Kremmling.
Recognize and catch short term rentals, Delta Colorado condos for rent, and vacation rental in Delta Colorado.
Using our page, third party agents post apartment, farmhouse, bungalow, and castle listings.
North Aurora Colorado locality employs many third party agents, property brokers, and agents.
Expeditionists, honeymooners, and locals who are wishing to disclose, elicit, and invent or simply come upon information can use our page.
Vacated exclusive home and convenient home are convenient in the adjacent domain of North Aurora Colorado.
Locate, relocate, and invent the locality and convenient North Aurora Colorado principality.
Design special, specific, and specific abstracts in North Aurora Colorado and classify North Aurora rent houses.
Our for rent by owner website can admit, enter, and assign waterfront listed properties and beach online MLS loft lists of marked properties, lakefront classifieds, spacious directories, and studio ad directories to work for your North Aurora Colorado promenade.
Send bewitching, pretty, and refined picture regarding North Aurora Colorado apartments for rent and North Aurora Colorado holiday rentals found on our site, FRBO.com.
Our page does incorporate unique romantic, oceanfront, beach, and oceanfront bungalow, house, castle, and condominiums.
You can identify, perceive, and relocate apartment rentals in North Aurora Colorado, for rent by owner homes, and North Aurora Colorado rental home.
North Aurora property owners, rental agents, and property managers list North Aurora vacation homes, North Aurora Colorado apartments for rent, North Aurora Colorado home rentals, and houses for rent.
Detect, recognize, and disclose homes for rent Stoneham United States, Stoneham United States condos for rent, and apartment rentals in Stoneham United States.
You can poke into the decadent ad directories, ski in/out classified advertisements, and hillside listed properties under North Aurora Colorado condo rentals, apartment rentals in North Aurora Colorado, and apartments for rent in North Aurora Colorado.
Distinguish, design, and ascertain home rentals, Mineral Colorado real estate rentals, and houses for rent in Mineral Colorado.
Join our hillside ad directories, lakefront indexes, and city classified advertisements mailing list for vacation homes for rent by owner, houses for rent North Aurora Colorado, and rental properties North Aurora Colorado.
The North Aurora ads enumerated and polled on FRBO.com incorporate mountain chalet, exclusive cabin, rustic condominium, and private timeshare.
North Aurora Colorado is a sublime, lovely, foxy, and superb stretch with excellent, marvelous, and divine flat and bungalows.
Learn, originate, and come upon apartment rentals in Bennett United States, short term rentals, and homes for rent by owner Bennett United States.
Explore, relocate, and detect holiday rentals Mineral and for rent by owner homes.
Invent, discern, and perceive apartment rentals Huerfano Colorado, home rentals in Huerfano Colorado, Huerfano rent house, and rental houses.
Hear and conceive Palisade United States bed and breakfast rentals and vacation homes in Palisade.
Elicit and hear Edwards United States house rentals and rental houses in Edwards.
We reared and performed FRBO.com to be fine and good-looking.
Distinguish and relocate vacation rental in Crowley Colorado and rental homes in Crowley.
Exclusive lists of marked properties and spacious advertisements San Juan Colorado condo rentals, condos for rent San Juan Colorado, house rentals in San Juan Colorado, and home rentals San Juan Colorado.
Espy and determine Parachute rental properties and rent houses in Parachute United States.
Dig up, detect, and contrive homes for rent by owner in Fleming, Fleming rental homes, and Fleming vacation rental.
Glimpse and debunk Kim rental home and Kim United States condo rentals.
Originate, glimpse, and perceive houses for rent, rental houses Silverton, and Silverton United States rental homes.
Trippers, residents, and collegiates who are investigating North Aurora Colorado condo rentals and are trying to contrive condos for rent in North Aurora Colorado and rental apartment in North Aurora Colorado can comb our online website, FRBO.com and our exotic online MLS and oceanfront ads.
Detect and design rental houses Adams Colorado and Adams for rent by owner homes.
|
|
