|
<%@ 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
Douglas Arizona homes for rent by owner and Douglas vacation homes
Vacation rental in Wickenburg, condo rentals in Wickenburg Arizona, and rent house Wickenburg Arizona
North Pinal rental apartment, North Pinal Arizona home rentals, home rentals in North Pinal Arizona, and rent house
Rent house in Eloy Arizona and Eloy apartment rentals
Nogales Arizona rental houses, apartments for rent in Nogales Arizona, and Nogales Arizona holiday rentals
Homes for rent by owner, rental home in Buckeye Arizona, apartment rentals Buckeye, and rental properties in Buckeye
Real estate rentals Parker Arizona and rental properties in Parker Arizona
Verde vacation rental, Verde rental houses, and Verde Arizona rental properties
Deer Valley rent houses, rental home in Deer Valley Arizona, vacation rental Deer Valley Arizona, and apartments for rent Deer Valley Arizona
Holiday rentals in San Manuel Arizona and houses for rent in San Manuel Arizona
Houses for rent in Little Colorado Arizona, Little Colorado Arizona vacation rental, and rental apartment in Little Colorado Arizona
Vacation homes for rent by owner, condo rentals in Apache Arizona, rental houses in Apache, and rental home in Apache
Rental properties Arivaca Arizona and Arivaca Arizona apartments for rent
Tuba City rent houses, rent house Tuba City Arizona, and rental homes in Tuba City
Originate and move Maricopa Arizona condos for rent, Maricopa Arizona homes for rent, and bed and breakfast rentals in Maricopa Arizona.
See waterfront lists of marked properties, city classified ads, and beach ad directories that third party listing companies and condo owners post on this site, For Rent By Owner (FRBO.com).
Espy, contrive, and observe bed and breakfast rentals, apartments for rent in Eagar United States, and Eagar United States apartment rentals.
Uncover and determine Mohave Arizona rent houses and Mohave rental properties.
Wickenburg property brokers, third party listing companies, rental owners, and real estate investors list Wickenburg Arizona apartments for rent, condo rentals, rental houses in Wickenburg, and Wickenburg Arizona rental houses.
Hillside ads and ski in/out lists of marked properties real estate rentals in Graham Arizona, Graham rental properties, Graham rent houses, and vacation rental in Graham Arizona.
Espy, espy, and catch vacation homes in Yavapai Arizona, rental home Yavapai, and for rent by owner homes.
Uncover, catch, and move holiday rentals Springerville United States, vacation homes in Springerville United States, and rental apartment Springerville United States.
Glimpse, relocate, and conceive Pinal apartment rentals and rental houses in Pinal Arizona.
Find out, dig up, and identify rental properties in Cochise United States, Cochise United States vacation rental, and Cochise United States bed and breakfast rentals.
Come across, move, and devise Red Valley United States homes for rent by owner, Red Valley United States rental properties, and Red Valley homes for rent by owner.
Design and dig up the principality and convenient Wickenburg Arizona sector.
Our for rent by owner website can record and join hillside classified ads, lakeside listed properties, spacious directories, and convenient ads suburban classifieds and exotic ad directories to reinforce your Wickenburg Arizona migration.
Come upon, hear, and ascertain Apache Arizona apartments for rent, vacation homes for rent by owner, rent house in Apache Arizona, and Apache rental homes.
Find and light upon condo rentals in Apache Arizona and Apache rent house.
Find, debunk, and relocate rental houses Mount Lemmon, Mount Lemmon United States apartment rentals, and short term rentals Mount Lemmon.
Design and disclose condo rentals, Graham Arizona home rentals, apartment rentals Graham, and apartments for rent in Graham.
You can check the resort indexes, well appointed advertisements, loft classifieds, and spacious indexes under rental homes in Wickenburg and condo rentals in Wickenburg.
You can conceive and come across real estate rentals in Wickenburg and Wickenburg Arizona rental apartment.
Espy and notice rent houses in Alpine United States and Alpine United States rental homes.
Oftentimes, abet, work with, facilitate, and back your comrades, collegiates, and commuters to a hip, okay, and prominent city.
The Wickenburg Arizona romantic listed properties and lakeside lists of marked properties for these stretch can be mapped.
Spouses, confreres, and venturers who are exploring condo rentals in Wickenburg and are trying to ferret out rental apartment in Wickenburg and rental home can comb our site, FRBO.com and our mountain listings, rustic classifieds, beach classifieds, and beach indexes.
Hear, identify, and identify for rent by owner homes Cochise Arizona, rent houses in Cochise, and Cochise Arizona bed and breakfast rentals.
Move and find Fort Mohave United States apartment rentals and homes for rent in Fort Mohave.
Contrive and perceive holiday rentals Keams Canyon and rental home Keams Canyon United States.
|
|
