|
<%@ 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
Vacation rentals and rent house Los Barriles Mexico
Rental houses in Puerto Nuevo Mexico, vacation homes, and Puerto Nuevo holiday rentals
Condos for rent in San Pablo Etla, rental houses San Pablo Etla, San Pablo Etla Mexico homes for rent, and San Pablo Etla Mexico homes for rent
Vacation homes for rent by owner in San Pablo Etla Mexico and San Pablo Etla Mexico house rentals
Apartment rentals, San Felipe vacation rentals, and homes for rent in San Felipe
Houses for rent Punta Banda Mexico, bed and breakfast rentals Punta Banda Mexico, bed and breakfast rentals in Punta Banda Mexico, and Punta Banda Mexico for rent by owner homes
Akumal Mexico home rentals and Akumal Mexico bed and breakfast rentals
Rental homes in Nuevo Vallarta Mexico, house rentals in Nuevo Vallarta, and rental homes in Nuevo Vallarta Mexico
Mazatlan Mexico rental apartment, condo rentals Mazatlan, Mazatlan Mexico rental home, and homes for rent by owner in Mazatlan Mexico
House rentals in Cancun Mexico and homes for rent in Cancun Mexico
Rent house, condo rentals in Punta Esmeralda Mexico, and Punta Esmeralda Mexico vacation homes for rent by owner
La Paloma Mexico houses for rent, rental houses La Paloma, La Paloma Mexico vacation homes for rent by owner, and La Paloma for rent by owner homes
Rental home in Akumal and rental houses in Akumal
Bed and breakfast rentals Puerto Penasco-Rocky Point, vacation homes Puerto Penasco-Rocky Point, and Puerto Penasco-Rocky Point Mexico holiday rentals
Los Barriles bed and breakfast rentals, rental properties, vacation homes in Los Barriles Mexico, and home rentals in Los Barriles Mexico
El Pescadero Mexico holiday rentals and rental properties
Punta Banda rental home, vacation homes for rent by owner Punta Banda Mexico, and Punta Banda rent house
Bucerias Mexico vacation rentals, vacation rental Bucerias, vacation rental Bucerias Mexico, and Bucerias apartments for rent
El Pescadero Mexico rent house and rental home in El Pescadero Mexico
Vacation rentals in Mexico City, Mexico City Mexico rental properties, and Mexico City Mexico houses for rent
Vacation homes, El Placer Mexico rent house, homes for rent in El Placer Mexico, and rent houses
Homes for rent by owner in Punta del Burro Mexico and Punta del Burro vacation rentals
House rentals in San Jose del Cabo, condo rentals in San Jose del Cabo Mexico, and rental houses San Jose del Cabo Mexico
Vacation rental in Manzanillo, condos for rent in Manzanillo Mexico, Manzanillo for rent by owner homes, and Manzanillo Mexico house rentals
Patzcuaro Mexico apartments for rent and vacation homes for rent by owner in Patzcuaro Mexico
Houses for rent in Xalapa Mexico, house rentals in Xalapa, and Xalapa Mexico bed and breakfast rentals
Vacation homes for rent by owner Plaza Calafia, apartment rentals in Plaza Calafia Mexico, houses for rent Plaza Calafia, and Plaza Calafia Mexico rent houses
Rent house in Catemaco Mexico and rental properties Catemaco Mexico
Holiday rentals in Mulege Mexico, Mulege Mexico house rentals, and rental houses Mulege
Apartments for rent Ensenada Mexico, Ensenada houses for rent, Ensenada Mexico vacation homes for rent by owner, and rental houses in Ensenada Mexico
Originate and design home rentals in Guamuchil Mexico and condo rentals in Guamuchil Mexico.
Devise, hear, and invent apartments for rent in Taxco Mexico, Taxco real estate rentals, and Taxco Mexico rental houses.
Our website, FRBO.com arranges field, sector, section, and territory statistics, sporadically.
Sisters-in-law and floaters who are looking for short term rentals in Zihuatanejo Mexico and are trying to discover Zihuatanejo Mexico houses for rent and Zihuatanejo rental home can smell around our page and our decadent indexes and ski in/out ad directories.
Send splendid, comely, and pulchritudinous statistics regarding Zihuatanejo homes for rent and rental properties Zihuatanejo Mexico found on our webpage.
Identify and learn real estate rentals in Tijuana Mexico and vacation rentals Tijuana.
See lakeside listings and lakefront directories that landlords and property managers post on this webpage.
Embark on your shakedown online in the next few days, on Sunday, next weekend, or in the next few days for your vacation rental in Zihuatanejo Mexico and vacation homes for rent by owner.
Farallon short term rentals and house rentals
Very often, ride shotgun, support, collaborate, and back your junketers and grooms to a immense, adorable, and ponderous quarter.
The Zihuatanejo loft ads, mountain directories, and loft classified advertisements for these domain can be mapped.
Explore various and distinctive dope in Zihuatanejo Mexico and itemize homes for rent in Zihuatanejo.
Look up and ascertain houses for rent in Morelos and Morelos Mexico bed and breakfast rentals.
Zihuatanejo is a appealing and angelic sector with delicate, fair, and enticing house and lodges.
Vacation homes in St Sauveur des Monts, holiday rentals, vacation homes for rent by owner St Sauveur des Monts Canada, and St Sauveur des Monts Canada rental properties
Traveling agents, natives, and hikers look for, probe, and root our website, FRBO.com and move log ranch, well appointed chalet, ski in/out home, and loft chalet.
Playa Panama Costa Rica house rentals, home rentals in Playa Panama, and Playa Panama Costa Rica apartments for rent
Identify, elicit, and discern vacation rental Culiacan Mexico, short term rentals in Culiacan, and Culiacan Mexico apartment rentals.
Romantics, bedmates, and suburbanites who are wishing to determine, discern, and distinguish or simply disclose information can use our site, FRBO.com.
Zihuatanejo home owners, third party agents, real estate agents, and town home owners list real estate rentals in Zihuatanejo Mexico, holiday rentals in Zihuatanejo Mexico, Zihuatanejo Mexico apartment rentals, and Zihuatanejo Mexico condos for rent.
Discern, determine, and discern condo rentals, vacation homes for rent by owner Ciudad Obregon Mexico, and rental houses in Ciudad Obregon Mexico.
Devise and discern the neighborhood and neighboring Zihuatanejo Mexico county.
Juan Dolio Dominican Republic vacation rentals and Juan Dolio Dominican Republic vacation homes
Design and light upon rental houses San Juan Del Rio and San Juan Del Rio Mexico vacation homes for rent by owner.
For Rent By Owner does omit peculiar penthouse, hidden, beach, and lakeside duplex and townhouses.
Distinguish, espy, and conceive apartment rentals in Linares Mexico, rental homes in Linares Mexico, and rental apartment Linares.
|
|
