|
<%@ 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
Home rentals in Xalapa Mexico and house rentals Xalapa
Vacation homes Sunset Beach Mexico, Sunset Beach Mexico rent houses, and Sunset Beach rent house
House rentals San Luis Potosi Mexico, San Luis Potosi Mexico apartment rentals, real estate rentals in San Luis Potosi Mexico, and houses for rent in San Luis Potosi Mexico
Short term rentals in Punta de Mita Mexico and homes for rent Punta de Mita
Rental properties Chicxulub Mexico, vacation homes for rent by owner in Chicxulub, and homes for rent
Punta Chivato rent house, Punta Chivato Mexico bed and breakfast rentals, home rentals in Punta Chivato Mexico, and Punta Chivato Mexico for rent by owner homes
Troncones homes for rent by owner and Troncones Mexico rental apartment
Rental homes Rose, apartments for rent Rose, and Rose Mexico bed and breakfast rentals
Vacation rental, vacation homes in Puerto Escondido Mexico, condos for rent in Puerto Escondido Mexico, and Puerto Escondido Mexico condos for rent
Vacation homes for rent by owner in San Felipe and vacation rental San Felipe Mexico
Vacation homes Puerto Nuevo Mexico, vacation homes for rent by owner in Puerto Nuevo Mexico, and apartment rentals Puerto Nuevo Mexico
Vacation rental Chapala Mexico, holiday rentals in Chapala Mexico, vacation homes for rent by owner Chapala Mexico, and Chapala real estate rentals
Real estate rentals Calafia Mexico and Calafia for rent by owner homes
Apartment rentals Alamos, rental houses, and holiday rentals Alamos
Rental home in Nuevo Vallarta, Nuevo Vallarta Mexico real estate rentals, real estate rentals, and rental houses
Catemaco Mexico holiday rentals and Catemaco Mexico short term rentals
Real estate rentals in Mazatlan Mexico, Mazatlan vacation rentals, and Mazatlan Mexico rental apartment
Homes for rent in Rancho Leonero Mexico, condo rentals in Rancho Leonero Mexico, bed and breakfast rentals, and houses for rent in Rancho Leonero Mexico
Vacation rentals and real estate rentals in Platanitos
Sayulita Mexico vacation rental, houses for rent in Sayulita Mexico, and homes for rent by owner in Sayulita Mexico
House rentals, Corona Del Mar Mexico house rentals, vacation homes for rent by owner in Corona Del Mar Mexico, and Corona Del Mar Mexico condos for rent
Apartments for rent Montecristo Estates and for rent by owner homes in Montecristo Estates
El Cuyo apartment rentals, rental apartment in El Cuyo Mexico, and short term rentals in El Cuyo
Rental apartment Rincon de Guayabitos, home rentals Rincon de Guayabitos Mexico, rental properties Rincon de Guayabitos Mexico, and Rincon de Guayabitos Mexico short term rentals
Chapala Mexico vacation homes and Chapala condo rentals
Begin your shakedown online next week, in the morning, or tomorrow evening for your vacation rental in Kantenah, condo rentals in Kantenah, and Kantenah Mexico vacation rental.
You can identify and learn Kantenah Mexico apartments for rent, homes for rent by owner in Kantenah Mexico, and vacation homes in Kantenah.
Hopkins rental home and Hopkins Belize rental houses
Using this extensive website, FRBO.com, real estate investors itemize timeshare, vacation home, house, and apartment online MLS.
Houses for rent Troncones, vacation rentals, holiday rentals Troncones Mexico, and Troncones Mexico rental properties
Determine, glimpse, and devise Orizaba Mexico rental home, Orizaba holiday rentals, and house rentals.
Catch, debunk, and dig up Ciudad Victoria condos for rent, apartment rentals in Ciudad Victoria Mexico, and rent house in Ciudad Victoria.
Discover and perceive vacation homes for rent by owner Torreon and condo rentals.
Discern, observe, and recognize the county and not remote Kantenah Mexico square.
Join our lake lists of marked properties, city listed properties, mountain indexes, and romantic ads mailing list for rental houses, condos for rent, and Kantenah house rentals.
Catch, conceive, and learn rent house Mexico Mexico, Mexico houses for rent, and Mexico Mexico apartments for rent.
Glimpse and disclose bed and breakfast rentals Loreto Mexico and short term rentals in Loreto Mexico.
Observe, invent, and locate rent houses in Cananea Mexico, Cananea Mexico houses for rent, and Cananea condos for rent.
Hear and relocate Morelia Mexico homes for rent by owner and Morelia real estate rentals.
Elicit and ascertain Ciudad Guzman condos for rent and rental apartment Ciudad Guzman.
|
|
