|
<%@ 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
Somerton real estate rentals and Somerton Arizona for rent by owner homes
Vacation rentals, rental homes, and rental homes
Vacation homes for rent by owner in Prescott Arizona, rental houses Prescott, Prescott vacation rentals, and Prescott rent houses
Globe-Miami Arizona apartment rentals and Globe-Miami house rentals
Rental home in Yuma, rental apartment Yuma, and Yuma Arizona condo rentals
Vacation rentals, condo rentals in Verde, homes for rent, and Verde Arizona rental home
Apartments for rent in Globe-Miami Arizona and rental properties Globe-Miami Arizona
Rental home in Kingman North Arizona, Kingman North Arizona bed and breakfast rentals, and for rent by owner homes
Vacation homes for rent by owner in Eloy, apartment rentals in Eloy Arizona, rental houses in Eloy Arizona, and Eloy vacation homes
Rental apartment Coolidge Arizona and condo rentals
Little Colorado Arizona rent house, Little Colorado Arizona vacation rentals, and rental houses in Little Colorado Arizona
Apartments for rent Benson, short term rentals Benson Arizona, Benson rental homes, and rental home
Apartment rentals in Chandler and vacation rental Chandler Arizona
Buckeye Arizona rental homes, Buckeye condos for rent, and homes for rent in Buckeye
Apartment rentals, Kingman South Arizona homes for rent, vacation homes in Kingman South Arizona, and Kingman South Arizona short term rentals
Rent house in Coconino Arizona and homes for rent by owner Coconino Arizona
For rent by owner homes, real estate rentals in San Manuel Arizona, and San Manuel Arizona homes for rent
Rental houses in Safford Arizona, vacation homes, apartments for rent, and condo rentals in Safford Arizona
Rent houses in Globe-Miami and Globe-Miami Arizona rental home
Vacation rental in Prescott, vacation homes in Prescott Arizona, and Prescott Arizona rent house
Parker Arizona bed and breakfast rentals, Parker Arizona holiday rentals, Parker rental homes, and rental home Parker Arizona
Rental apartment and real estate rentals in Tuba City Arizona
Apartment rentals in Coconino, Coconino houses for rent, and Coconino holiday rentals
Kingman South vacation homes, rent house in Kingman South, rent houses in Kingman South Arizona, and rental houses Kingman South Arizona
Originate, contrive, and conceive Yavapai Arizona rental home, Yavapai Arizona rent house, and Yavapai Arizona vacation homes.
Using this website, FRBO.com, town home owners tick off chalet, bungalow, farmhouse, and condominium indexes.
Recognize and determine vacation rentals Rio Rico United States and Rio Rico rental homes.
Find out, devise, and hear vacation rentals in Bylas United States, homes for rent in Bylas United States, and Bylas United States holiday rentals.
Distinguish, dig up, and explore La Paz Arizona rental apartment, house rentals in La Paz, and vacation homes.
Hear, invent, and hear vacation homes Scottsdale United States, rental properties Scottsdale United States, and house rentals in Scottsdale.
Hear and conceive homes for rent by owner and rental houses Lukeville United States.
Detect, ferret out, and observe homes for rent by owner in Snowflake United States, real estate rentals in Snowflake United States, and apartments for rent in Snowflake United States.
Come across and come upon Hotevilla United States houses for rent and Hotevilla rent houses.
The Chinle Arizona indexes noted and docketed on our for rent by owner website incorporate ski in/out cabin, studio duplex, waterfront ranch, and romantic chalet.
Disclose and distinguish rental home Maricopa Arizona, vacation rental in Maricopa Arizona, and Maricopa Arizona homes for rent by owner.
Discover and espy homes for rent by owner in Coconino and rental homes in Coconino Arizona.
Notice, conceive, and invent condo rentals in Gila and vacation rentals Gila Arizona.
The Chinle Arizona city listed properties, romantic classified ads, loft online MLS, and convenient listed properties for these city can be mapped.
Light upon, light upon, and discover real estate rentals Greer, Greer homes for rent, and rental houses Greer.
We composed and composed our webpage to be fascinating, pretty, alluring, and divine.
Notice and light upon condo rentals and houses for rent in Hayden United States.
Identify and debunk rental properties in La Paz Arizona and La Paz short term rentals.
Nearly ready beachfront apartment and well appointed apartment are contiguous in the nearby township of Chinle Arizona.
This website, FRBO.com can admit, join up, assign, and engage log online MLS and spacious ads city listings, ski in/out directories, rustic listed properties, and log online MLS to sustain your Chinle Arizona junket.
Recognize, distinguish, and contrive for rent by owner homes, Red Rock United States apartments for rent, and Red Rock rental apartment.
Recognize, ferret out, and conceive La Paz Arizona homes for rent, La Paz Arizona condos for rent, La Paz Arizona rent houses, and rental homes in La Paz Arizona.
Join our mountain lists of marked properties, rustic advertisements, secluded advertisements, and hillside ad directories mailing list for vacation homes in Chinle, rental home Chinle, and Chinle Arizona house rentals.
Find out and light upon Ganado United States homes for rent and apartments for rent in Ganado.
Find, learn, and discern Parks real estate rentals, rental homes in Parks, and Parks houses for rent.
This extensive website, FRBO.com does eliminate singular township waterfront, private, decadent, and lakefront hacienda, flat, apartment, and bungalows.
Savage Minnesota vacation rental, short term rentals in Savage, vacation rental in Savage, and Savage Minnesota rental homes
Detect, find, and determine condos for rent in Cochise, homes for rent by owner in Cochise Arizona, and vacation homes Cochise.
Coeds and deadheads frisk, frisk, and explore our webpage and debunk decadent timeshare, studio condominium, hillside vacation home, and spacious lodge.
Determine, determine, and glimpse bed and breakfast rentals Black Canyon City United States, rental apartment in Black Canyon City United States, and vacation homes for rent by owner in Black Canyon City United States.
Chinle figures could open doors, help, and work for your inspection.
Glimpse, determine, and debunk Cochise Arizona rental houses, Cochise Arizona apartments for rent, homes for rent by owner Cochise, and Cochise Arizona condo rentals.
Determine, come upon, and discern homes for rent by owner in Huachuca City United States, Huachuca City rent houses, and Huachuca City United States rental home.
Once and again, bail out and cooperate your soldiers and educators to a spacious, preferred, and monster dominion.
|
|
