|
<%@ 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" %>
|
Mexico Rental Links
Las Gaviotas for rent by owner homes and Las Gaviotas rental properties
San Antonio del Mar Mexico short term rentals, San Antonio del Mar Mexico apartment rentals, and San Antonio del Mar Mexico rental home
Houses for rent in Valle De Bravo Mexico, rent house in Valle De Bravo Mexico, homes for rent in Valle De Bravo Mexico, and for rent by owner homes in Valle De Bravo
Condo rentals Cancun Mexico and rent house in Cancun
Apartment rentals in Chapala Mexico, rent house Chapala Mexico, and homes for rent by owner in Chapala Mexico
Rental apartment, Montecristo Estates holiday rentals, Montecristo Estates rent houses, and rent house in Montecristo Estates Mexico
Rental home and Huatulco Mexico homes for rent by owner
Bed and breakfast rentals in Playa Paraiso, homes for rent by owner, and Playa Paraiso rental apartment
San Pablo Etla Mexico rent house, San Pablo Etla Mexico apartment rentals, San Pablo Etla short term rentals, and San Pablo Etla Mexico apartment rentals
Rental home Playa del Carmen Mexico and Playa del Carmen Mexico homes for rent by owner
Condo rentals, for rent by owner homes in Guadalajara Mexico, and Guadalajara Mexico rental houses
Loreto Mexico for rent by owner homes, rental properties Loreto, rent houses in Loreto Mexico, and vacation rental
Vacation homes in Todos Santos Mexico and apartments for rent in Todos Santos Mexico
Rental homes, rental houses Jocotepec, and Jocotepec Mexico rental houses
Condos for rent in Todos Santos, apartment rentals Todos Santos, condo rentals in Todos Santos Mexico, and vacation rental in Todos Santos Mexico
Real estate rentals and condos for rent
Vacation homes Oceana Towers, Oceana Towers bed and breakfast rentals, and Oceana Towers apartments for rent
Rent houses La Penita, short term rentals La Penita Mexico, La Penita Mexico condos for rent, and apartment rentals
Rental homes Nuevo Vallarta Mexico and homes for rent by owner in Nuevo Vallarta
San Pablo Etla Mexico rental home, rental apartment in San Pablo Etla Mexico, and San Pablo Etla Mexico rental properties
El Pescadero Mexico rental apartment, homes for rent by owner, El Pescadero home rentals, and El Pescadero Mexico house rentals
Homes for rent by owner Mulege Mexico and rental homes in Mulege
Condo rentals in La Ventana Mexico, rent houses La Ventana, and La Ventana condos for rent
Puerto Aventuras Mexico real estate rentals, houses for rent in Puerto Aventuras Mexico, condos for rent Puerto Aventuras Mexico, and rental home Puerto Aventuras
La Jolla de Rosarito Mexico homes for rent by owner and condo rentals in La Jolla de Rosarito
Vacation homes Punta Banda Mexico, apartments for rent in Punta Banda, and home rentals in Punta Banda Mexico
La Ribera home rentals, apartments for rent, rental apartment in La Ribera, and vacation homes for rent by owner La Ribera
La Manzanilla rental home and vacation homes La Manzanilla
Vacation homes in Playa del Secreto Mexico, homes for rent in Playa del Secreto, and vacation rentals in Playa del Secreto Mexico
Recognize, come across, and uncover homes for rent Tepatitlan Mexico, vacation homes in Tepatitlan, and rent houses in Tepatitlan.
Commuters and pioneers who are wishing to relocate and ascertain or simply distinguish information can use our online website, FRBO.com.
Vacation rental in Christiansted US Virgin Islands, Christiansted US Virgin Islands home rentals, and rental home in Christiansted
Distinguish, explore, and distinguish houses for rent, short term rentals in Reynosa, and homes for rent Reynosa Mexico.
Tulum property managers, property managers, town home owners, and property brokers list rent houses, vacation homes for rent by owner Tulum, holiday rentals Tulum Mexico, and Tulum Mexico apartment rentals.
Relocate and conceive rental home Queretaro and apartment rentals in Queretaro.
Join our convenient classified ads, studio online MLS, and rustic listings mailing list for Tulum Mexico vacation rentals and Tulum rental properties.
Originate and relocate short term rentals in Acapulco Mexico and rent houses in Acapulco Mexico.
Ascertain and find holiday rentals in Loreto and Loreto homes for rent.
You can inspect the convenient classified advertisements and beach classifieds under Tulum Mexico houses for rent and apartments for rent in Tulum.
You can light upon and glimpse rent houses Tulum Mexico and condo rentals in Tulum.
Take up your expedition online day after tomorrow, this week, this weekend, or on Friday for your homes for rent by owner Tulum Mexico, Tulum real estate rentals, and rent house in Tulum.
Ferret out and discover Alamos Mexico condo rentals and Alamos Mexico rent house.
Notice, devise, and ferret out short term rentals, vacation rental in Cananea Mexico, and Cananea Mexico vacation rental.
We imagined and created our for rent by owner site, FRBO.com to be enticing and well-formed.
Colleagues and schoolmates examine, comb, and inspect our webpage and invent decadent lodge, lakeside house, penthouse villa, and mountain timeshare.
Send charming, nice, and exquisite poop sheet regarding Tulum Mexico rental houses, Tulum houses for rent, and vacation homes for rent by owner in Tulum Mexico found on our website, FRBO.com.
Short term rentals in Parksville and bed and breakfast rentals Parksville
Vacation homes in The Baths and The Baths for rent by owner homes
Learn strange, peculiar, and startling reports in Tulum Mexico and record rent houses in Tulum Mexico.
Unused rustic home, beachfront chalet, lake vacation home, and decadent ranch are convenient in the near-at-hand turf of Tulum Mexico.
Glimpse, ferret out, and identify Cholula Mexico vacation homes, rental houses in Cholula Mexico, and rent house Cholula.
Learn and detect houses for rent in Dzidzantun Mexico and houses for rent Dzidzantun Mexico.
Conceive and perceive vacation homes in Mulege Mexico and Mulege Mexico real estate rentals.
Notice, learn, and dig up San Luis Rio Colorado Mexico home rentals, San Luis Rio Colorado Mexico houses for rent, and homes for rent by owner in San Luis Rio Colorado Mexico.
Find and design rental homes Tixtla De Guerrero Mexico and apartments for rent in Tixtla De Guerrero Mexico.
Espy and recognize apartment rentals and home rentals in Nuevo Laredo Mexico.
Identify and distinguish Cordoba apartments for rent and home rentals Cordoba.
Observe, come across, and look up rent houses in Chihuahua Mexico, Chihuahua Mexico rental houses, and condo rentals in Chihuahua.
This website, FRBO.com encloses territory, neighborhood, township, and quarter compilations, infrequently.
Homes for rent by owner in Peggy s Cove Canada, Peggy s Cove Canada home rentals, and holiday rentals Peggy s Cove
|
|
