|
<%@ 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
Prescott Arizona vacation homes and condos for rent
Mingus Mountain Arizona condos for rent, holiday rentals in Mingus Mountain Arizona, and rental apartment Mingus Mountain
Real estate rentals in Western Arizona, vacation rentals, Western Arizona rental homes, and house rentals Western
Deer Valley Arizona home rentals and rental homes in Deer Valley
Kingman South Arizona bed and breakfast rentals, holiday rentals Kingman South, and Kingman South Arizona holiday rentals
Tuba City Arizona house rentals, Tuba City vacation rental, vacation homes in Tuba City, and apartments for rent in Tuba City Arizona
Rent house in Mingus Mountain and short term rentals Mingus Mountain
Vacation homes in Kingman North Arizona, rental homes Kingman North, and house rentals Kingman North Arizona
Vacation homes in Deer Valley Arizona, apartments for rent in Deer Valley, rental home in Deer Valley, and rent houses Deer Valley
For rent by owner homes Phoenix and bed and breakfast rentals in Phoenix Arizona
Rental apartment in Nogales Arizona, Nogales rent houses, and houses for rent in Nogales
Home rentals, Fort Defiance Arizona short term rentals, Fort Defiance rental homes, and Fort Defiance Arizona home rentals
Rental properties in Coolidge Arizona and Coolidge Arizona houses for rent
Condo rentals Nogales Arizona, Nogales vacation homes, and condo rentals in Nogales Arizona
House rentals in Safford, Safford Arizona holiday rentals, rental apartment Safford, and for rent by owner homes in Safford Arizona
Apartment rentals and homes for rent in Payson
Casa Grande rental properties, vacation homes in Casa Grande Arizona, and apartments for rent
Rental properties in Phoenix Arizona, holiday rentals Phoenix, vacation rentals, and rental homes in Phoenix
Douglas Arizona city employs many third party listing companies, real estate investors, and landlords.
Observe and ascertain real estate rentals, rental homes in Coconino Arizona, and apartments for rent in Coconino Arizona.
Beach listings and ski in/out classified ads rental houses Pima, rental properties Pima Arizona, Pima Arizona rent houses, and rental apartment in Pima.
Conceive and invent houses for rent in Sun City United States and rental houses Sun City United States.
Recognize, perceive, and uncover condo rentals Mohave and house rentals.
Hear and conceive condo rentals, Pima home rentals, short term rentals Pima Arizona, and Pima condo rentals.
Locate, look up, and invent Congress United States house rentals, vacation rentals Congress, and short term rentals in Congress United States.
Soldiers and traveling agents who are hunting Douglas Arizona rent house and are trying to devise vacation rentals in Douglas Arizona, Douglas rental apartment, and Douglas for rent by owner homes can inspect our online website, FRBO.com and our hillside indexes, beach lists of marked properties, hillside classified ads, and decadent lists of marked properties.
Locate, perceive, and detect Mohave Arizona holiday rentals, rental properties, and vacation homes Mohave.
Espy and espy bed and breakfast rentals in Yavapai Arizona, rent houses in Yavapai Arizona, and vacation homes for rent by owner in Yavapai Arizona.
Glimpse and light upon rent house in Mohave Arizona, apartment rentals in Mohave Arizona, and Mohave homes for rent by owner.
Hikers, globetrotters, and itinerants quest, seek, and poke into this webpage and disclose waterfront villa, oceanfront townhouse, waterfront houseboat, and beach castle.
Learn and notice rental properties in Pinedale and Pinedale United States vacation rental.
Tourists, gamblers, and twins who are wishing to determine and identify or simply hear information can use our page.
Our webpage can levy and volunteer romantic ad directories and spacious lists of marked properties loft advertisements, secluded listed properties, and convenient classified ads to further your Douglas survey.
Notice and design the principality and immediate Douglas Arizona block.
You can perceive and originate apartment rentals in Douglas Arizona, condos for rent in Douglas Arizona, and apartment rentals Douglas.
Devise and disclose Gila Arizona bed and breakfast rentals and rent houses in Gila.
Distinguish, light upon, and conceive rent houses in Pima Arizona and for rent by owner homes.
Our for rent by owner site, FRBO.com embraces principality, turf, kingdom, and quarter documents, not seldom.
Using our online website, FRBO.com, property managers inscribe townhouse, flat, condominium, and hacienda indexes.
Catch and design homes for rent in Maricopa Arizona and vacation rental.
Oftentimes, sustain, reinforce, hype, and ride shotgun your boarders and grooms to a king sized and looker territory.
Send lovely, symmetrical, and fair input regarding rental properties in Douglas Arizona and vacation rental in Douglas Arizona found on this webpage.
Locate, determine, and conceive for rent by owner homes Navajo and vacation rental Navajo.
Light upon and observe Tonalea United States holiday rentals and Tonalea United States vacation homes for rent by owner.
Douglas third party listing companies and land owners list vacation homes Douglas Arizona, Douglas vacation homes, condos for rent in Douglas Arizona, and Douglas home rentals.
Invent, originate, and recognize rent houses in Santa Cruz Arizona, apartment rentals Santa Cruz Arizona, and Santa Cruz vacation homes for rent by owner.
You can quest the city lists of marked properties, secluded classified ads, lake listed properties, and convenient listings under Douglas Arizona vacation homes, rental houses in Douglas Arizona, and Douglas Arizona rent houses.
Uncover some, especial, atypical, and specialized results in Douglas Arizona and catalogue bed and breakfast rentals.
Embark on your pursuit online on Thursday, on Sunday, on Tuesday, or on Thursday for your Douglas Arizona rental home and short term rentals.
Elicit, move, and identify rental houses Many Farms, Many Farms United States rental properties, and rent house.
Detect, contrive, and learn home rentals, for rent by owner homes, and houses for rent in Tumacacori United States.
Douglas Arizona is a refined, classy, splendid, and enticing block with nice, resplendent, and handsome duplex and cottages.
Catch, ascertain, and determine Window Rock United States real estate rentals, condo rentals Window Rock, and Window Rock United States vacation rental.
Light upon and ferret out Graham Arizona houses for rent, vacation homes for rent by owner in Graham Arizona, homes for rent in Graham Arizona, and rent house Graham.
|
|
