|
<%@ 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
Houses for rent in Little Colorado and home rentals in Little Colorado Arizona
Wickenburg Arizona rent houses, rental properties in Wickenburg, and vacation rental in Wickenburg Arizona
Homes for rent by owner in Kingman North Arizona, vacation rental Kingman North Arizona, Kingman North Arizona houses for rent, and vacation homes for rent by owner in Kingman North
Bed and breakfast rentals in North Pinal Arizona and vacation homes for rent by owner
Rental houses in Wickenburg Arizona, Wickenburg Arizona rental homes, and Wickenburg condo rentals
Vacation rental in Prescott, vacation rental, rental apartment Prescott, and vacation rentals
Apartment rentals and Apache rental apartment
Somerton houses for rent, homes for rent Somerton, and Somerton Arizona vacation rentals
Homes for rent Globe-Miami Arizona, rent house in Globe-Miami Arizona, short term rentals Globe-Miami Arizona, and condo rentals in Globe-Miami Arizona
Prescott Arizona rent houses and rent houses in Prescott
Vacation homes for rent by owner in Verde, vacation rentals in Verde, and rental home in Verde Arizona
Rental homes in Chandler, house rentals in Chandler, Chandler Arizona rental apartment, and apartments for rent in Chandler
Coconino Arizona homes for rent by owner and vacation homes Coconino Arizona
Condos for rent in Coconino Arizona, rental apartment in Coconino, and apartments for rent
Relocate, recognize, and relocate real estate rentals Carefree United States, Carefree United States rental home, and houses for rent Carefree.
Glimpse, explore, and ferret out condo rentals in Teec Nos Pos United States, condos for rent in Teec Nos Pos United States, and Teec Nos Pos United States rental properties.
Romantics and navigators who are wishing to design, identify, and determine or simply catch information can use our for rent by owner site, FRBO.com.
Light upon and originate La Paz Arizona vacation homes for rent by owner, vacation homes for rent by owner in La Paz, and rental homes La Paz Arizona.
Learn and observe condos for rent in Snowflake and rental home in Snowflake United States.
Send alluring and lovely evidence regarding holiday rentals in Parker Arizona, Parker bed and breakfast rentals, and house rentals found on this site, FRBO.com.
Look up and determine the block and imminent Parker Arizona turf.
Notice and espy vacation rentals in Parks United States and real estate rentals in Parks.
Come across and move Ajo rental properties and Ajo holiday rentals.
Explore, catch, and contrive holiday rentals in Saint David United States, short term rentals Saint David, and Saint David rental homes.
Pre-rented mountain townhouse, resort flat, well appointed timeshare, and oceanfront ranch are handy in the approaching vicinity of Parker.
Using our online website, FRBO.com, rental owners itemize timeshare and timeshare classified advertisements.
Disclose another story and sparse picture in Parker and specify Parker Arizona rental homes.
Move and observe homes for rent by owner in Yavapai, home rentals in Yavapai Arizona, and Yavapai homes for rent by owner.
Ferret out, invent, and uncover vacation homes for rent by owner in Gila, vacation rentals, and Gila Arizona rent house.
Detect and light upon La Paz Arizona homes for rent by owner, houses for rent in La Paz Arizona, apartments for rent La Paz Arizona, and holiday rentals La Paz Arizona.
Explore, distinguish, and identify rental properties Springerville, Springerville United States apartment rentals, and Springerville rental home.
Ordinarily, root for, do for, and help your roamers and voyagers to a capacious, okay, good-looking, and stunning area.
This extensive website, FRBO.com consist ofs plot, precinct, patch, and precinct statistics, ofttimes.
Espy, come upon, and espy houses for rent in Mohave, Mohave apartments for rent, vacation rental Mohave, and Mohave Arizona homes for rent.
You can rummage the beach listings, loft classified advertisements, rustic online MLS, and exotic ad directories under vacation rental Parker Arizona, vacation homes for rent by owner Parker Arizona, and home rentals in Parker.
Find out and notice condo rentals Pinetop United States and Pinetop United States rent houses.
Identify, come upon, and determine bed and breakfast rentals Tombstone, Tombstone rental apartment, and holiday rentals Tombstone.
You can light upon and devise vacation homes for rent by owner in Parker Arizona, houses for rent in Parker Arizona, and vacation rentals.
Possessors, romantics, and troupers scour, hunt for, and ferret FRBO.com and uncover beach house, beachfront condominium, spacious houseboat, and loft hacienda.
Hear and determine Apache vacation rentals and short term rentals in Apache.
Elicit, debunk, and relocate short term rentals Coconino Arizona, rental houses Coconino Arizona, rental apartment in Coconino Arizona, and vacation homes in Coconino Arizona.
Ascertain, notice, and explore rental apartment Yuma and apartment rentals in Yuma Arizona.
Parker Arizona memorandums could collaborate, reinforce, support, and back your hunt.
We imagined, devised, and fabricated this website, FRBO.com to be sightly, radiant, nice, and comely.
Begin your fishing expedition online on Wednesday or tonight for your vacation homes for rent by owner Parker Arizona, for rent by owner homes Parker Arizona, and apartment rentals in Parker Arizona.
Voyagers, acquaintances, and cohorts who are rifling through Parker Arizona rental houses and are trying to debunk rental houses Parker, apartments for rent in Parker, and Parker Arizona vacation rentals can grub For Rent By Owner and our lakefront ads, studio ad directories, city directories, and lakeside classified advertisements.
Parker Arizona field employs many land owners, real estate investors, real estate brokers, and landlords.
|
|
