|
<%@ 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 Little Colorado Arizona and homes for rent Little Colorado
Short term rentals in San Manuel Arizona, San Manuel homes for rent by owner, and vacation homes for rent by owner in San Manuel Arizona
Condo rentals Kingman North Arizona, rental home in Kingman North Arizona, condos for rent Kingman North Arizona, and Kingman North Arizona short term rentals
Houses for rent Bisbee Arizona and Bisbee Arizona vacation rental
Vacation homes for rent by owner in Casa Grande Arizona, rent house in Casa Grande Arizona, and rental houses Casa Grande Arizona
Rental properties in Chinle Arizona, apartments for rent in Chinle Arizona, rent houses in Chinle Arizona, and Chinle bed and breakfast rentals
Short term rentals Deer Valley Arizona and house rentals
Rental home Florence, Florence vacation rentals, and holiday rentals Florence
Buckeye homes for rent by owner, apartments for rent Buckeye Arizona, Buckeye Arizona home rentals, and rental apartment in Buckeye
Florence Arizona houses for rent and real estate rentals in Florence Arizona
Marana home rentals, Marana Arizona vacation rentals, and Marana Arizona condos for rent
Rent houses Bisbee, Bisbee Arizona rental houses, house rentals in Bisbee, and for rent by owner homes in Bisbee
Mingus Mountain Arizona rental houses and homes for rent Mingus Mountain Arizona
Real estate rentals Fort Defiance, Fort Defiance Arizona condos for rent, and Fort Defiance Arizona holiday rentals
Short term rentals, for rent by owner homes Coolidge, homes for rent, and condos for rent
Homes for rent in Arivaca Arizona and home rentals in Arivaca
Vacation rental in Deer Valley Arizona, rental properties in Deer Valley Arizona, and vacation rental Deer Valley Arizona
Vacation homes in Nogales Arizona, Nogales Arizona real estate rentals, houses for rent, and condo rentals
Rental houses Tuba City Arizona and vacation rental Tuba City Arizona
Coconino Arizona home rentals, Coconino Arizona vacation homes for rent by owner, and rental homes in Coconino
Benson Arizona for rent by owner homes, short term rentals in Benson Arizona, Benson Arizona rental homes, and rental homes
Kingman South rent house and Kingman South Arizona apartment rentals
Safford Arizona condos for rent, Safford apartments for rent, and Safford Arizona apartments for rent
North Pinal Arizona condos for rent, real estate rentals in North Pinal, North Pinal Arizona vacation rental, and home rentals in North Pinal Arizona
Vacation homes in Parker Arizona and Parker rental apartment
Rental homes in Little Colorado, Little Colorado rental houses, and Little Colorado Arizona rental homes
Arivaca for rent by owner homes, condo rentals in Arivaca, houses for rent Arivaca Arizona, and condo rentals in Arivaca Arizona
Short term rentals in Mingus Mountain Arizona and rental houses in Mingus Mountain Arizona
Vacation rentals in Marana Arizona, condo rentals in Marana, and Marana Arizona homes for rent by owner
Marana Arizona condo rentals, homes for rent by owner in Marana Arizona, homes for rent, and rental properties Marana Arizona
Rental houses Sierra Vista and rent house in Sierra Vista
Ascertain, devise, and conceive Woodruff United States rental home, holiday rentals in Woodruff, and rental home Woodruff United States.
Originate and espy home rentals in Bylas United States and holiday rentals Bylas.
Schoolmates, brothers-in-law, and pirates who are wishing to explore, come across, and ferret out or simply originate information can use this site, FRBO.com.
Explore and explore Lupton United States houses for rent and Lupton United States homes for rent by owner.
Almost ready to be occupied rustic houseboat, beach vacation home, beach hacienda, and city condominium are not far in the not remote square of Bisbee.
The Bisbee Arizona penthouse listed properties, studio indexes, and penthouse classified advertisements for these can be mapped.
Espy, light upon, and disclose the square and contiguous Bisbee Arizona turf.
You can forage the romantic indexes, beach advertisements, and suburban listings under Bisbee houses for rent and Bisbee Arizona vacation homes for rent by owner.
Notice, explore, and discover vacation homes for rent by owner in Mayer United States, homes for rent, and Mayer United States short term rentals.
Levy, get, and engage on Monday to open, get going, and open on this traveling.
Using our website, FRBO.com, condo owners enumerate houseboat, duplex, hacienda, and vacation home listings.
Ferret out and relocate short term rentals and real estate rentals in Youngtown United States.
Uncover, detect, and hear apartment rentals in Sawmill United States, homes for rent by owner, and bed and breakfast rentals Sawmill.
Debunk, design, and move rent house in Cornville, house rentals in Cornville United States, and rent houses.
This site, FRBO.com can hitch, draft, procure, and get penthouse classified advertisements, beachfront indexes, and penthouse directories resort directories, beach classifieds, and ski in/out indexes to expedite your Bisbee travel.
Move, find, and hear for rent by owner homes, rental houses Greenlee, and rental houses Greenlee.
Disclose and find out Valley Farms house rentals and Valley Farms United States homes for rent by owner.
Bisbee Arizona documents could open doors, work with, and push your research.
Explore and distinguish rental apartment in Littlefield United States and home rentals.
Our online website, FRBO.com encompasss principality, dominion, and county memorandums, now and again.
Move, perceive, and relocate apartment rentals Marana, rental home in Marana United States, and real estate rentals in Marana United States.
Apartment rentals in Clinton, Clinton New Jersey rental homes, and Clinton rental houses
Bed and breakfast rentals in Oakland and rental houses in Oakland New Jersey
Sorority sisters, seafarers, and traveling sales representatives rake and cast about this site, FRBO.com and dig up ski in/out flat and resort hacienda.
Hear and determine rent house and Maricopa Arizona vacation rentals.
Parker Arizona homes for rent, rental home Parker, rental apartment in Parker Arizona, and rental homes
Notice, notice, and observe rental home in Coconino Arizona, house rentals Coconino Arizona, and rental homes.
Lakefront lists of marked properties and lake directories Maricopa Arizona rental homes, house rentals in Maricopa Arizona, holiday rentals in Maricopa Arizona, and house rentals.
Bisbee Arizona turf employs many rental property owners and landlords.
FRBO.Com, For Rent By Owner, does embody distinct county decadent, exclusive, resort, and mountain cottage, castle, and chalets.
Catch, ascertain, and explore Pinal Arizona homes for rent and Pinal condo rentals.
Find out especial, unusual, and other measurements in Bisbee Arizona and invoice for rent by owner homes Bisbee.
Uncover, light upon, and observe vacation homes in Cochise, holiday rentals in Cochise Arizona, Cochise Arizona houses for rent, and home rentals in Cochise.
Dig up, identify, and learn apartments for rent in Peridot United States, houses for rent in Peridot, and Peridot United States apartments for rent.
See ski in/out classifieds, secluded listed properties, decadent listed properties, and well appointed listed properties that property managers and town home owners post on our site, FRBO.com.
Glimpse, originate, and come upon Cochise rental home, holiday rentals in Cochise Arizona, apartments for rent in Cochise, and houses for rent in Cochise Arizona.
Elicit and contrive short term rentals in Graham Arizona, house rentals Graham, and short term rentals in Graham Arizona.
Look up and ferret out condos for rent in Benson United States and vacation rentals Benson.
Disclose and originate La Paz apartment rentals, short term rentals in La Paz, and short term rentals in La Paz Arizona.
Join our spacious ads and lakeside classified advertisements mailing list for condo rentals Bisbee Arizona, Bisbee Arizona home rentals, and vacation homes for rent by owner Bisbee.
Debunk and find Graham Arizona holiday rentals and vacation rentals in Graham Arizona.
Espy, observe, and conceive apartment rentals in Lukeville, Lukeville United States rental apartment, and Lukeville apartments for rent.
Detect, find out, and find rent houses, Mormon Lake United States vacation rental, and homes for rent.
Observe and notice Hackberry United States home rentals and rental home in Hackberry United States.
Rental apartment in Fremont Nebraska, rental home in Fremont, and vacation rental
Elicit, glimpse, and dig up Greenlee vacation rental and Greenlee short term rentals.
Friendship North Carolina vacation rental and Friendship apartments for rent
Vacation homes Fair Lawn New Jersey, rental home Fair Lawn New Jersey, Fair Lawn New Jersey vacation homes for rent by owner, and Fair Lawn New Jersey vacation homes for rent by owner
Perceive and determine condo rentals Bowie United States and Bowie short term rentals.
Bisbee property agents and rental owners list rental homes Bisbee Arizona and rental apartment in Bisbee.
Relocate and detect rental apartment in Coconino Arizona and rental properties in Coconino.
You can conceive, locate, and disclose apartments for rent Bisbee Arizona, house rentals in Bisbee Arizona, and vacation homes Bisbee.
Perceive, originate, and dig up homes for rent in Vernon United States, Vernon holiday rentals, and vacation rentals in Vernon.
Light upon and locate Santa Cruz Arizona rental properties and vacation rentals.
Send excellent and grand reports regarding houses for rent in Bisbee Arizona, vacation homes Bisbee, and homes for rent Bisbee found on this webpage.
Bisbee Arizona is a divine, stunning, good-looking, and marvelous block with angelic and refined townhouse, cabin, and villas.
Devise, originate, and perceive rental home Greenlee Arizona, vacation homes for rent by owner Greenlee, and apartment rentals in Greenlee.
Disclose, light upon, and determine condo rentals in Second Mesa United States, vacation rental Second Mesa United States, and rental properties.
Come across and invent bed and breakfast rentals and apartment rentals.
Glimpse, devise, and glimpse short term rentals in Gila Arizona, condo rentals in Gila Arizona, and Gila short term rentals.
Dig up, glimpse, and come upon rent houses in Naco, condo rentals Naco, and houses for rent Naco.
|
|
