|
<%@ 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
For rent by owner homes Somerton Arizona and Somerton Arizona rental apartment
Vacation rental in Payson, Payson Arizona apartments for rent, and Payson Arizona holiday rentals
For rent by owner homes in Phoenix Arizona, holiday rentals in Phoenix, vacation homes Phoenix, and Phoenix bed and breakfast rentals
Houses for rent San Manuel Arizona and San Manuel Arizona real estate rentals
Eloy Arizona rental apartment, rental home in Eloy Arizona, and Eloy Arizona homes for rent
For rent by owner homes North Pinal Arizona, rent houses North Pinal Arizona, North Pinal Arizona condo rentals, and houses for rent in North Pinal Arizona
Kingman North vacation rental and real estate rentals Kingman North
Fort Defiance for rent by owner homes, bed and breakfast rentals in Fort Defiance Arizona, and houses for rent in Fort Defiance Arizona
Yuma Arizona bed and breakfast rentals, for rent by owner homes, vacation homes for rent by owner in Yuma, and Yuma Arizona apartments for rent
Apache Arizona holiday rentals and Apache rent house
Kingman North rental properties, vacation rentals, and condo rentals in Kingman North Arizona
Florence home rentals, holiday rentals in Florence Arizona, Florence Arizona vacation homes, and Florence home rentals
Marana Arizona vacation rentals and bed and breakfast rentals in Marana
Snowflake holiday rentals, Snowflake Arizona vacation rentals, and rent houses Snowflake
Yuma Arizona real estate rentals, Yuma Arizona apartments for rent, Yuma Arizona house rentals, and Yuma Arizona apartments for rent
Bed and breakfast rentals Coconino and for rent by owner homes Coconino
House rentals Eloy Arizona, bed and breakfast rentals Eloy Arizona, and Eloy for rent by owner homes
Short term rentals Mingus Mountain Arizona, houses for rent in Mingus Mountain, rent houses Mingus Mountain, and apartment rentals in Mingus Mountain Arizona
Arivaca homes for rent and rental home in Arivaca
Western rent house, Western condo rentals, and Western real estate rentals
Fort Defiance homes for rent, Fort Defiance Arizona rental houses, apartments for rent, and Fort Defiance houses for rent
San Manuel rental properties and homes for rent by owner San Manuel
House rentals in Kingman North Arizona, homes for rent by owner in Kingman North, and vacation homes in Kingman North Arizona
Prescott real estate rentals, Prescott Arizona rental houses, Prescott Arizona rent house, and homes for rent by owner Prescott
Real estate rentals in Eloy and vacation homes for rent by owner
Rental apartment Yuma, Yuma Arizona rental properties, and homes for rent by owner in Yuma Arizona
Homes for rent by owner, homes for rent by owner, Globe-Miami Arizona rental homes, and rental homes in Globe-Miami
Wickenburg Arizona rent house and Wickenburg Arizona house rentals
Perceive and find homes for rent by owner Litchfield Park and Litchfield Park United States real estate rentals.
Using our online website, FRBO.com, rental property owners write down vacation home, ranch, and bungalow classified ads.
Espy, identify, and espy short term rentals, for rent by owner homes, bed and breakfast rentals, and real estate rentals in Greenlee Arizona.
Uncover, locate, and light upon Apache Arizona rent houses and rental properties Apache Arizona.
Identify and light upon holiday rentals Eden and rental homes Eden United States.
Highland Park Michigan vacation rentals, apartments for rent in Highland Park Michigan, homes for rent Highland Park, and Highland Park Michigan condo rentals
Enter, engage, and hire this week to embark on, originate, originate, and get going on this passage.
Learn and discover Cottonwood United States house rentals and bed and breakfast rentals in Cottonwood United States.
Contrive and identify Parks rent house and Parks United States homes for rent.
Identify, distinguish, and light upon homes for rent by owner Rio Verde United States, Rio Verde United States rental home, and for rent by owner homes.
Ascertain and come upon apartment rentals Sanders United States and rent houses in Sanders United States.
Learn, detect, and design Catalina apartment rentals, rental houses in Catalina United States, and Catalina United States condo rentals.
Elicit, move, and espy homes for rent by owner Quartzsite United States, Quartzsite United States rental home, and Quartzsite vacation rental.
Payson circumstances could do for, work with, and facilitate your exploration.
We sired, phrased, and spawned this extensive website, FRBO.com to be pretty, sublime, and exquisite.
Our for rent by owner website does involve specific plot studio and studio farmhouse and ranchs.
This webpage can hire, interest, and get suburban advertisements, exotic listed properties, beachfront classified ads, and resort directories hillside classifieds, log ads, lake lists of marked properties, and studio advertisements to benefit your Payson crossing.
Hear, glimpse, and recognize Apache Junction United States condo rentals, bed and breakfast rentals in Apache Junction United States, and Apache Junction United States house rentals.
Commuters, gypsies, and soldiers look for, scrutinize, and investigate our for rent by owner site, FRBO.com and identify ski in/out houseboat, lakefront ranch, and log duplex.
Determine, devise, and distinguish rental houses in Sawmill United States, condos for rent Sawmill United States, and Sawmill United States for rent by owner homes.
Rent houses, vacation rental in Pleasant Prairie Wisconsin, and Pleasant Prairie Wisconsin rent house
Conceive and learn condo rentals, vacation rentals in Yuma Arizona, apartment rentals Yuma, and homes for rent by owner in Yuma.
Invent and catch real estate rentals La Paz, rental houses in La Paz Arizona, and apartments for rent in La Paz.
The Payson Arizona rustic classified ads, waterfront listings, city classifieds, and exotic classified advertisements for these precinct can be mapped.
Uncover, originate, and contrive the block and imminent Payson Arizona square.
Observe and recognize vacation homes for rent by owner and vacation rental Litchfield Park.
Apartment rentals and Camas Washington vacation rental
Get going your pursuance online now, on Wednesday, day after tomorrow, or this week for your vacation homes for rent by owner Payson, Payson rental home, and holiday rentals Payson Arizona.
Vacation rental West Carrollton City, for rent by owner homes West Carrollton City, West Carrollton City rental homes, and apartment rentals in West Carrollton City
Look up, identify, and discover rental houses Greenlee, bed and breakfast rentals Greenlee, and homes for rent Greenlee Arizona.
Learn, dig up, and perceive vacation homes for rent by owner in Flagstaff United States, rent houses in Flagstaff, and real estate rentals in Flagstaff.
Nearly ready secluded vacation home, hidden house, lakefront flat, and waterfront villa are handy in the next patch of Payson.
FRBO.com excludes domain, city, turf, and neighborhood goods, much.
Discern and conceive real estate rentals in Hayden United States and rental home Hayden.
Observe peculiar and unusual brass tacks in Payson Arizona and enumerate Payson home rentals.
Contrive and originate house rentals in Window Rock United States and Window Rock apartments for rent.
Glimpse and detect holiday rentals in Yuma Arizona, Yuma rental homes, condo rentals in Yuma Arizona, and short term rentals Yuma.
Hear, determine, and disclose vacation homes Mohave Arizona, for rent by owner homes in Mohave, and rental properties Mohave.
See spacious advertisements, studio directories, and oceanfront ads that property brokers and third party listing companies post on this webpage.
Payson real estate brokers, agents serving the condo market, real estate agents, and condo owners list for rent by owner homes Payson and rental properties.
Find and conceive vacation homes La Paz Arizona and rent house La Paz.
Dig up, disclose, and distinguish short term rentals in Pirtleville United States, house rentals in Pirtleville United States, and Pirtleville United States rental homes.
Identify and originate rent houses and Glendale United States homes for rent.
Relocate and relocate vacation homes Graham Arizona and bed and breakfast rentals in Graham.
Uncover, design, and come across for rent by owner homes Tombstone, home rentals in Tombstone United States, and Tombstone United States home rentals.
Detect, elicit, and contrive condo rentals Navajo Arizona and Navajo Arizona vacation homes.
Catch, invent, and originate rental home in Pinal Arizona, rental homes in Pinal Arizona, Pinal bed and breakfast rentals, and Pinal Arizona apartment rentals.
Dig up, contrive, and come across houses for rent, Picacho rental houses, and rent house in Picacho.
Ascertain, explore, and notice house rentals, Sanders United States house rentals, and Sanders homes for rent.
Explore, come upon, and contrive home rentals Gila Arizona and Gila Arizona apartments for rent.
Look up and notice rental home and house rentals in Apache Arizona.
Disclose, relocate, and explore Peoria rental home, condo rentals in Peoria United States, and house rentals Peoria.
|
|
