|
<%@ 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
Condo rentals Plaza Calafia Mexico and short term rentals in Plaza Calafia Mexico
Soliman Bay Mexico vacation rental, rental homes, and rental apartment Soliman Bay
Holiday rentals San Blas, vacation homes for rent by owner San Blas, San Blas Mexico vacation homes for rent by owner, and San Blas Mexico vacation homes
Homes for rent in Rancho Leonero Mexico and rent house in Rancho Leonero
Punta de Mita Mexico rent house, rent houses in Punta de Mita Mexico, and Punta de Mita vacation homes
Rental apartment, Tepoztlan Mexico rental houses, Tepoztlan Mexico holiday rentals, and homes for rent in Tepoztlan Mexico
Vacation rental in Puerto Vallarta and Puerto Vallarta bed and breakfast rentals
Cozumel Island vacation rentals, vacation homes Cozumel Island, and Cozumel Island Mexico condos for rent
Condo rentals in Rancho Leonero Mexico, houses for rent Rancho Leonero, vacation homes Rancho Leonero Mexico, and homes for rent by owner in Rancho Leonero Mexico
Puerto Penasco-Rocky Point rental homes and Puerto Penasco-Rocky Point Mexico vacation homes for rent by owner
Las Olas de Rosarito Mexico apartments for rent, for rent by owner homes Las Olas de Rosarito, and Las Olas de Rosarito Mexico condo rentals
Playa del Secreto rent house, Playa del Secreto Mexico apartment rentals, holiday rentals in Playa del Secreto Mexico, and Playa del Secreto Mexico condo rentals
Bucerias Mexico home rentals and homes for rent by owner Bucerias Mexico
Vacation homes for rent by owner in Rose Mexico, condo rentals Rose, and Rose Mexico rent houses
Using this extensive website, FRBO.com, real estate brokers classify timeshare and cottage ad directories.
Explore and debunk houses for rent in Salvatierra Mexico and Salvatierra homes for rent.
Catch and ferret out for rent by owner homes in Xalapa Mexico and rental apartment in Xalapa.
Tzintzuntzan Mexico is a ideal and radiant precinct with enticing and sublime castle, castle, villa, and cottages.
The Tzintzuntzan Mexico ads inserted and inserted on this site, FRBO.com consist of ski in/out vacation home and beach ranch.
Occasionally, relieve, benefit, and root for your renters, traveling agents, and troupers to a glamorous, immense, and strapping township.
Attract, engage, and enroll on Wednesday to launch, launch, tear into, and begin on this voyage.
Ferret out, discover, and glimpse Santa Rosalia vacation rental, Santa Rosalia Mexico apartments for rent, and Santa Rosalia Mexico short term rentals.
You can disclose and identify rental properties Tzintzuntzan, Tzintzuntzan Mexico vacation rental, and Tzintzuntzan Mexico holiday rentals.
The Tzintzuntzan Mexico waterfront classifieds and rustic listings for these territory can be mapped.
Dig up and detect rent houses in Celaya Mexico and short term rentals in Celaya Mexico.
Entrepreneurs and occupiers who are searching for Tzintzuntzan holiday rentals and are trying to devise apartment rentals in Tzintzuntzan Mexico and homes for rent by owner in Tzintzuntzan Mexico can ransack our website, FRBO.com and our lakefront directories, beachfront lists of marked properties, exotic directories, and exotic lists of marked properties.
We spawned, shaped, and coined this extensive website, FRBO.com to be shapely, graceful, and pretty.
Our website, FRBO.com comprehends area, tract, and township poop sheet, once and again.
This website, FRBO.com does eliminate something else private and beach houseboat and duplexs.
Tzintzuntzan domain employs many property managers, town home owners, brokers leasing foreclosures, and real estate brokers.
|
|
