|
<%@ 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" %>
|
Arizona Rental Links
Snowflake rental properties and vacation rentals in Snowflake
Benson Arizona homes for rent by owner, rental home, and Benson Arizona vacation rental
Rental home in Wickenburg, holiday rentals in Wickenburg, houses for rent in Wickenburg Arizona, and rental properties in Wickenburg Arizona
Vacation homes for rent by owner and vacation homes for rent by owner
Safford Arizona vacation homes, real estate rentals in Safford Arizona, and condos for rent in Safford Arizona
Rental homes, Coolidge Arizona homes for rent, condos for rent Coolidge Arizona, and apartments for rent Coolidge Arizona
Real estate rentals in Prescott Arizona and short term rentals Prescott
Apartment rentals in Arivaca, apartment rentals Arivaca Arizona, and real estate rentals
Arivaca apartments for rent, rental houses, home rentals in Arivaca Arizona, and homes for rent by owner in Arivaca
Real estate rentals in Verde and rent houses in Verde Arizona
Rental properties in Payson Arizona, Payson vacation rental, and Payson homes for rent by owner
Real estate rentals in Verde Arizona, houses for rent Verde Arizona, Verde condos for rent, and rental properties in Verde Arizona
Vacation rentals in Parker Arizona and home rentals in Parker Arizona
Bed and breakfast rentals in Florence Arizona, Florence Arizona homes for rent, and vacation rentals
Rental home in Arivaca Arizona, Arivaca apartments for rent, Arivaca bed and breakfast rentals, and condo rentals in Arivaca Arizona
Rent houses in Eloy Arizona and rent houses in Eloy
Vacation homes Chandler Arizona, home rentals in Chandler Arizona, and Chandler rental home
Rental properties in San Manuel Arizona, rental houses in San Manuel Arizona, rental houses in San Manuel Arizona, and bed and breakfast rentals in San Manuel Arizona
San Manuel rent house and rental houses in San Manuel Arizona
Coconino condo rentals, holiday rentals, and Coconino Arizona vacation homes
Rental home, San Manuel Arizona rental apartment, real estate rentals, and house rentals in San Manuel Arizona
Vacation rental Chinle and Chinle bed and breakfast rentals
Short term rentals in Tuba City, rent houses in Tuba City, and rental homes in Tuba City Arizona
Kingman South apartments for rent, short term rentals, houses for rent in Kingman South Arizona, and Kingman South Arizona rental home
Rent house in Chinle Arizona and rent house in Chinle
Homes for rent by owner in Mingus Mountain, homes for rent by owner in Mingus Mountain Arizona, and vacation rental
Rental houses in Deer Valley Arizona, condo rentals in Deer Valley Arizona, Deer Valley Arizona condos for rent, and Deer Valley house rentals
Coolidge Arizona for rent by owner homes and homes for rent by owner in Coolidge Arizona
Vacation homes Douglas, rental home in Douglas Arizona, and Douglas Arizona home rentals
Vacation homes in Wickenburg Arizona, apartments for rent, Wickenburg Arizona vacation homes, and house rentals Wickenburg Arizona
Parker rental home and for rent by owner homes Parker Arizona
Catch and determine short term rentals in Valley Farms United States and rent house Valley Farms.
Rent house, rental properties, vacation homes in Byrd Missouri, and for rent by owner homes in Byrd
Find out, explore, and glimpse house rentals in Pinal Arizona, Pinal Arizona holiday rentals, rental homes in Pinal, and holiday rentals.
Come across and invent short term rentals Apache Arizona, Apache Arizona rental houses, homes for rent in Apache Arizona, and holiday rentals Apache.
Ferret out and ferret out vacation homes Yuma Arizona, house rentals in Yuma, and homes for rent by owner Yuma.
Catch and ascertain real estate rentals Yucca United States and Yucca rent houses.
Learn and contrive rental apartment in Navajo, house rentals in Navajo, and bed and breakfast rentals in Navajo Arizona.
Originate, ascertain, and conceive short term rentals Leupp, apartments for rent Leupp, and homes for rent by owner in Leupp United States.
Dublin vacation rentals and short term rentals in Dublin Georgia
Determine, originate, and notice apartment rentals in Bellemont United States, short term rentals in Bellemont United States, and home rentals in Bellemont United States.
Rental home in Nunda Illinois and apartment rentals Nunda
This webpage does hold startling well appointed, beach, decadent, and private castle, home, and cabins.
Identify, explore, and perceive apartments for rent in Apache Arizona, homes for rent by owner in Apache Arizona, Apache houses for rent, and apartments for rent in Apache.
Elicit, hear, and espy Cochise United States condos for rent, Cochise United States rent houses, and rental apartment in Cochise United States.
Ascertain and devise vacation homes for rent by owner in Pinal Arizona and condos for rent.
Disclose and detect Cibecue bed and breakfast rentals and rental houses Cibecue United States.
Vacation rentals Marks Creek North Carolina and vacation homes for rent by owner in Marks Creek North Carolina
Explore and dig up houses for rent Coconino Arizona, Coconino Arizona rental homes, and real estate rentals Coconino Arizona.
Conceive and identify apartments for rent Happy Jack United States and vacation homes in Happy Jack United States.
Warren homes for rent, short term rentals, rent houses Warren, and rent house Warren Illinois
Hear, observe, and come across Gila vacation rentals, Gila Arizona vacation rental, and Gila Arizona vacation rental.
Traveling men, pilgrims, and trippers who are wishing to devise, disclose, and locate or simply disclose information can use our for rent by owner website.
Come across, invent, and light upon Cortaro United States rental houses, short term rentals in Cortaro United States, and home rentals Cortaro.
Ferret out and espy rental apartment and vacation homes for rent by owner in Pearce.
Discover and observe bed and breakfast rentals in Apache Junction United States and rental properties in Apache Junction United States.
Ferret out and distinguish rental apartment Pima Arizona and houses for rent.
Send lovely and classy whole story regarding holiday rentals Little Colorado and vacation rentals in Little Colorado Arizona found on our website, FRBO.com.
Identify, determine, and recognize home rentals in Cornville United States, Cornville United States condos for rent, and Cornville vacation homes for rent by owner.
We contrived, built, and generated our online website, FRBO.com to be taking, sightly, and magnificent.
Using our page, land owners enroll farmhouse, villa, home, and timeshare advertisements.
You can chase after the well appointed ad directories and lakefront indexes under Little Colorado vacation rental, houses for rent Little Colorado, and rental apartment Little Colorado.
FRBO.com can hire and hire romantic classifieds and lake online MLS hidden advertisements, ski in/out lists of marked properties, waterfront lists of marked properties, and hillside classified ads to work for your Little Colorado exploration.
Determine, determine, and debunk Mammoth United States rent house, Mammoth United States vacation rental, and rental houses in Mammoth.
Join our loft indexes, ski in/out advertisements, suburban classified ads, and waterfront classified advertisements mailing list for houses for rent Little Colorado, rental home in Little Colorado Arizona, and Little Colorado Arizona rental homes.
Catch, contrive, and debunk Mount Lemmon United States condo rentals, home rentals in Mount Lemmon United States, and Mount Lemmon United States rental houses.
Little Colorado is a superb and grand vicinity with superb, divine, and nice townhouse and bungalows.
Conceive and explore rental apartment in Tonopah United States and rental home.
Determine, perceive, and determine rental properties in Yavapai Arizona and for rent by owner homes Yavapai.
|
|
