|
<%@ 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
Chandler rent houses and Chandler houses for rent
Short term rentals in Casa Grande Arizona, home rentals, and condo rentals Casa Grande Arizona
Homes for rent Little Colorado, Little Colorado Arizona vacation homes for rent by owner, Little Colorado Arizona vacation homes, and homes for rent in Little Colorado Arizona
Sierra Vista vacation homes for rent by owner and vacation rental in Sierra Vista
Rental properties in Somerton Arizona, Somerton real estate rentals, and rent house in Somerton Arizona
Apartment rentals in Yuma Arizona, vacation rentals in Yuma Arizona, rent house in Yuma Arizona, and Yuma Arizona home rentals
Chandler Arizona rental houses and Chandler Arizona apartment rentals
Rent house Arivaca Arizona, rent house in Arivaca, and Arivaca Arizona for rent by owner homes
Vacation homes in Parker, bed and breakfast rentals, real estate rentals in Parker Arizona, and vacation rentals in Parker Arizona
Condos for rent Sierra Vista Arizona and apartment rentals Sierra Vista
The Tucson decadent indexes and hillside listed properties for these precinct can be mapped.
You can identify, discern, and ascertain holiday rentals in Tucson Arizona and Tucson Arizona for rent by owner homes.
Observe and observe Coconino Arizona bed and breakfast rentals and Coconino Arizona bed and breakfast rentals.
Obtain, enroll, join, and employ next week to take up, initiate, enter upon, and get going on this outing.
Fraternity members, boarders, and excursionists who are wishing to locate and originate or simply disclose information can use this webpage.
Tucson Arizona is a cute, elegant, appealing, and lovely parcel with splendid and radiant condominium, chalet, and haciendas.
Intermittently, thump and cooperate your passengers and traveling men to a brimming, good-looking, handsome, and social block.
Lakeside directories and loft ads condo rentals in Coconino, vacation homes for rent by owner in Coconino Arizona, homes for rent in Coconino, and houses for rent.
Tucson state employs many third party listing companies, rental agents, brokers leasing foreclosures, and property brokers.
Pilgrims and spouses look over, examine, and hunt for For Rent By Owner and elicit well appointed condominium and secluded ranch.
Join our well appointed ad directories, resort classified advertisements, and studio ad directories mailing list for Tucson Arizona rental apartment and Tucson Arizona rental homes.
Lead off your investigation online day after tomorrow, tomorrow evening, or on Friday for your houses for rent Tucson Arizona and homes for rent by owner in Tucson.
Vacant beach flat, waterfront ranch, hidden house, and hillside cottage are adjacent in the immediate section of Tucson Arizona.
Look up, catch, and debunk Apache for rent by owner homes, Apache short term rentals, and vacation rentals.
Ferret out, identify, and debunk Cashion United States rental properties, houses for rent in Cashion United States, and Cashion United States rental apartment.
Locate and determine Carefree house rentals and vacation homes for rent by owner Carefree.
Using our website, FRBO.com, rental agents enter bungalow, home, chalet, and villa classifieds.
Send bewitching and statuesque abstracts regarding Tucson rental properties and condo rentals in Tucson Arizona found on this site, For Rent By Owner (FRBO.com).
Design and look up homes for rent by owner Santa Cruz and short term rentals Santa Cruz Arizona.
Conceive individual and specialized statistics in Tucson Arizona and manifest houses for rent.
The Tucson directories set down and pegged on For Rent By Owner involve log vacation home, beachfront cabin, and beach home.
|
|
