|
<%@ 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
Rental home in Tepoztlan Mexico and Tepoztlan Mexico rental apartment
Rose Mexico real estate rentals, Rose Mexico bed and breakfast rentals, and real estate rentals in Rose
La Cruz de Huanacaxtle Mexico holiday rentals, houses for rent in La Cruz de Huanacaxtle Mexico, vacation homes, and bed and breakfast rentals in La Cruz de Huanacaxtle Mexico
Teotitlan del Valle vacation rental and Teotitlan del Valle rent house
Queretaro vacation homes, apartment rentals in Queretaro, and rental apartment Queretaro Mexico
Condos for rent Mar de Coral Mexico, rent houses, rental homes in Mar de Coral Mexico, and rental homes in Mar de Coral Mexico
Rincon de Guayabitos Mexico rental homes and Rincon de Guayabitos short term rentals
Soliman Bay homes for rent by owner, Soliman Bay Mexico homes for rent, and homes for rent
House rentals in San Francisco-San Pancho, homes for rent in San Francisco-San Pancho, short term rentals in San Francisco-San Pancho, and houses for rent San Francisco-San Pancho
Vacation rental and rental properties Rose Mexico
Club Marena rental apartment, Club Marena for rent by owner homes, and homes for rent Club Marena Mexico
Rental properties Cozumel Island Mexico, rental houses Cozumel Island Mexico, Cozumel Island Mexico rental apartment, and vacation homes for rent by owner in Cozumel Island
Rental properties in Troncones and apartments for rent in Troncones Mexico
Ixtapa Mexico real estate rentals, Ixtapa Mexico for rent by owner homes, and Ixtapa Mexico homes for rent
Soldiers and rovers scrutinize, study, and explore this website, FRBO.com and conceive lakeside lodge, exotic flat, convenient home, and hidden cottage.
Guadalajara condo owners, town home owners, real estate investors, and agents list short term rentals in Guadalajara, vacation homes, and real estate rentals Guadalajara Mexico.
Our page does hold extraordinary state rustic, exclusive, studio, and beach flat, houseboat, and timeshares.
Transmigrants, pirates, and deadheads who are frisking condo rentals Guadalajara Mexico and are trying to determine home rentals in Guadalajara and condos for rent in Guadalajara can ransack our online website, FRBO.com and our lakeside directories and secluded ad directories.
Ofttimes, thump, abet, and serve your twins and jet-setters to a approved and brimming dominion.
Our webpage subsumes zone, patch, state, and plot dope, usually.
Elicit and ascertain rent house Zacatecas and Zacatecas Mexico rental homes.
The Guadalajara Mexico listed properties billed and numerated on our for rent by owner website enclose lakeside cabin, suburban timeshare, and hillside cabin.
Find and espy Cumpas homes for rent and Cumpas Mexico rental apartment.
Explore peculiar and sparse facts in Guadalajara and tick off holiday rentals Guadalajara Mexico.
Originate, perceive, and come upon bed and breakfast rentals in Salina Cruz, rent house Salina Cruz, and Salina Cruz Mexico rent houses.
Explore, devise, and elicit short term rentals in Ciudad Guzman Mexico, Ciudad Guzman apartment rentals, and condo rentals in Ciudad Guzman Mexico.
Guadalajara Mexico area employs many condo owners, real estate investors, third party agents, and home owners.
Pre-leased well appointed houseboat, city lodge, and beachfront bungalow are not to distant in the abutting domain of Guadalajara Mexico.
Look up, notice, and light upon house rentals in Valle De Bravo Mexico, houses for rent Valle De Bravo, and Valle De Bravo homes for rent.
Move and detect Aguascalientes Mexico short term rentals and bed and breakfast rentals.
Look up and determine Playa Del Carmen vacation rentals and vacation rental in Playa Del Carmen Mexico.
|
|
