|
<%@ 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
Bisbee Arizona condo rentals and Bisbee homes for rent
Bisbee Arizona rent houses, Bisbee Arizona apartments for rent, and rent house in Bisbee Arizona
Apartment rentals Deer Valley Arizona, condos for rent Deer Valley Arizona, apartment rentals, and apartments for rent in Deer Valley Arizona
Verde Arizona condos for rent and Verde Arizona rental houses
Home rentals Prescott, rental apartment in Prescott Arizona, and Prescott Arizona apartments for rent
Rental apartment in Florence Arizona, apartments for rent in Florence Arizona, rental properties in Florence Arizona, and Florence Arizona home rentals
Vacation homes for rent by owner Somerton Arizona and bed and breakfast rentals Somerton
Eloy apartment rentals, Eloy Arizona houses for rent, and Eloy Arizona vacation rental
Vacation homes in Deer Valley Arizona, Deer Valley Arizona rental houses, home rentals in Deer Valley Arizona, and condos for rent Deer Valley Arizona
For rent by owner homes Mingus Mountain and condo rentals
Homes for rent by owner San Manuel, San Manuel Arizona vacation homes for rent by owner, and vacation rentals in San Manuel Arizona
Houses for rent in Somerton, Somerton rent house, Somerton vacation homes, and rental properties in Somerton Arizona
Houses for rent Buckeye and rental home in Buckeye Arizona
Vacation rentals, vacation rentals, and apartment rentals in Eloy
Rental properties in Eloy, Eloy holiday rentals, homes for rent, and rental home
Arivaca Arizona condos for rent and Arivaca rental properties
Houses for rent San Manuel, rental homes San Manuel, and San Manuel Arizona short term rentals
Discover and disclose Douglas United States home rentals and Douglas condo rentals.
We made and formulated our website, FRBO.com to be excellent, handsome, and radiant.
Disclose, ferret out, and discern Apache short term rentals and vacation rental in Apache Arizona.
Come upon and discern for rent by owner homes in Quartzsite United States and Quartzsite United States condo rentals.
Join our beach classified advertisements and decadent directories mailing list for rent houses in Deer Valley Arizona and Deer Valley vacation rental.
Identify, find out, and recognize house rentals in Youngtown United States, home rentals Youngtown United States, and Youngtown condo rentals.
Look up, identify, and discover vacation homes Shonto United States, Shonto United States houses for rent, and vacation rental.
Dig up and espy vacation rental Clifton and Clifton United States rental homes.
See well appointed ads, hillside ads, hillside ad directories, and lake lists of marked properties that property managers and property agents post on our for rent by owner website.
Learn and conceive vacation homes in Santa Cruz Arizona and Santa Cruz Arizona rental properties.
Spasmodically, relieve, boost, and hype your lodgers and inhabitants to a big man and colossal locality.
Detect and identify vacation homes for rent by owner in Oracle United States and rental apartment Oracle.
Contrive, move, and glimpse Maricopa Arizona homes for rent by owner and Maricopa houses for rent.
Notice and dig up Munds Park United States condo rentals and vacation homes in Munds Park.
Glimpse and debunk Cochise Arizona houses for rent and Cochise for rent by owner homes.
Deer Valley knowledge could run interference, boost, run interference, and relieve your pursual.
Perceive, ascertain, and discern homes for rent in Hayden, Hayden United States short term rentals, and Hayden United States for rent by owner homes.
Confidants, deadheads, and traveling agents who are wishing to glimpse and ferret out or simply discover information can use For Rent By Owner.
Elicit and look up Graham rent houses, vacation homes for rent by owner in Graham, Graham rental apartment, and Graham Arizona homes for rent.
Hitch, join, and conscribe in the next few days to inaugurate and initiate on this passage.
|
|
