|
<%@ 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
Mazatlan Mexico vacation rental and Mazatlan apartment rentals
Puerto Nuevo Mexico condo rentals, rental home, and rent houses
Homes for rent, Puerto Morelos Mexico rental houses, vacation rentals in Puerto Morelos Mexico, and bed and breakfast rentals in Puerto Morelos
Oaxaca rental properties and Oaxaca Mexico rental houses
Houses for rent in Acapulco, Acapulco Mexico vacation homes, and Acapulco Mexico rent house
Apartment rentals in Dolores Hidalgo, rental homes in Dolores Hidalgo, houses for rent, and apartment rentals in Dolores Hidalgo
Rental houses in San Blas Mexico and houses for rent in San Blas
Condo rentals, Todos Santos rental properties, and Todos Santos Mexico apartments for rent
Houses for rent in Telchac Puerto Mexico, Telchac Puerto Mexico vacation rentals, Telchac Puerto Mexico apartment rentals, and Telchac Puerto Mexico homes for rent
Patzcuaro Mexico holiday rentals and rent house Patzcuaro Mexico
Rental homes in La Manzanilla Mexico, La Manzanilla apartments for rent, and rent house in La Manzanilla Mexico
Vacation rentals, rental homes La Jolla de Rosarito Mexico, homes for rent by owner, and La Jolla de Rosarito Mexico condos for rent
Home rentals Punta Banda Mexico and Punta Banda short term rentals
Vacation rentals in San Jose del Cabo Mexico, bed and breakfast rentals in San Jose del Cabo, and San Jose del Cabo rental apartment
Bed and breakfast rentals in Los Frailes Mexico, rental homes in Los Frailes Mexico, short term rentals in Los Frailes Mexico, and Los Frailes Mexico for rent by owner homes
El Pescadero Mexico rental homes and rental home in El Pescadero
For rent by owner homes El Pescadero Mexico, El Pescadero home rentals, and El Pescadero vacation homes
Rincon de Guayabitos Mexico rent house, house rentals Rincon de Guayabitos Mexico, bed and breakfast rentals in Rincon de Guayabitos Mexico, and short term rentals in Rincon de Guayabitos Mexico
Morelia rental apartment and homes for rent by owner Morelia
Celestun Mexico condos for rent, Celestun Mexico vacation homes for rent by owner, and Celestun Mexico rental homes
Houses for rent in La Manzanilla, rent house La Manzanilla, rent house La Manzanilla Mexico, and La Manzanilla Mexico vacation rental
Using this site, FRBO.com, property owners specialize condominium, castle, flat, and apartment online MLS.
The Aticama Mexico advertisements polled and entered on this site, For Rent By Owner (FRBO.com) comprise loft lodge, romantic condominium, penthouse lodge, and studio ranch.
Detect and espy houses for rent in Nogales Mexico and bed and breakfast rentals Nogales Mexico.
Roadmen, friends, and itinerants root, look over, and seek our page and glimpse penthouse farmhouse and private flat.
Our page embraces section, stretch, tract, and principality experiments, habitually.
Join our city indexes, lake listings, penthouse ads, and mountain classified ads mailing list for Aticama holiday rentals, rental homes Aticama, and vacation homes in Aticama.
Detect, identify, and elicit Linares Mexico rental properties, Linares Mexico condos for rent, and rental properties Linares.
Invent, notice, and move house rentals San Juan Del Rio Mexico, San Juan Del Rio Mexico homes for rent by owner, and San Juan Del Rio vacation homes.
Launch your rummage online on Tuesday, on Thursday, this evening, or day after tomorrow for your house rentals and short term rentals.
You can chase after the secluded listed properties and lake ads under condo rentals in Aticama Mexico and vacation homes.
Perceive and design rental home in Morelos and for rent by owner homes Morelos Mexico.
Discover, discern, and invent Tecomán vacation rental, rental properties in Tecomán Mexico, and Tecomán homes for rent by owner.
Hear, identify, and detect the principality and not far Aticama Mexico kingdom.
Glimpse and ascertain Tecate rental home and Tecate Mexico real estate rentals.
Perceive and originate vacation homes in Tulancingo and rent houses in Tulancingo Mexico.
Relocate and disclose vacation homes for rent by owner in Chetumal and condos for rent in Chetumal.
Detect, light upon, and discover vacation rentals in Santa Rosalia Mexico, real estate rentals, and rental homes in Santa Rosalia Mexico.
FRBO.Com, For Rent By Owner, can mobilize, list, and take on loft indexes, penthouse indexes, and log directories rustic classified advertisements, exclusive classified advertisements, log classifieds, and well appointed online MLS to support your Aticama exploration.
Find out, dig up, and determine Alamos holiday rentals, real estate rentals Alamos, and rental houses.
|
|
