|
<%@ 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
Los Cabos-Blanco vacation homes for rent by owner and homes for rent
San Felipe Mexico vacation homes, rental home San Felipe Mexico, and vacation homes for rent by owner in San Felipe Mexico
Las Gaviotas apartment rentals, condos for rent Las Gaviotas Mexico, Las Gaviotas rental homes, and home rentals in Las Gaviotas Mexico
Apartments for rent in Puerto Escondido and rental apartment in Puerto Escondido Mexico
Condos for rent in Playas de Tijuana Coronado, Playas de Tijuana Coronado Mexico rent houses, and Playas de Tijuana Coronado Mexico real estate rentals
Condos for rent Plaza Calafia Mexico, for rent by owner homes in Plaza Calafia, Plaza Calafia homes for rent by owner, and homes for rent by owner Plaza Calafia
Playa Paraiso Mexico house rentals and Playa Paraiso Mexico homes for rent
Rental houses, La Ribera Mexico short term rentals, and house rentals
Home rentals Akumal, for rent by owner homes in Akumal Mexico, Akumal Mexico short term rentals, and Akumal Mexico bed and breakfast rentals
Home rentals Baja Malibu Mexico and bed and breakfast rentals in Baja Malibu
Rental apartment in Montecristo Estates, rent houses Montecristo Estates, and Montecristo Estates Mexico rental properties
Queretaro Mexico homes for rent by owner, home rentals Queretaro Mexico, rental houses in Queretaro Mexico, and Queretaro Mexico houses for rent
Rental houses in Playa Paraiso Mexico and vacation homes Playa Paraiso
San Blas Mexico holiday rentals, San Blas Mexico real estate rentals, and San Blas houses for rent
Apartment rentals La Paloma Mexico, condo rentals in La Paloma Mexico, rental home, and rental homes in La Paloma
House rentals in Zihuatanejo Mexico and Zihuatanejo rent houses
San Luis Potosi Mexico real estate rentals, real estate rentals in San Luis Potosi, and houses for rent in San Luis Potosi
Home rentals Playa Paraiso, houses for rent in Playa Paraiso Mexico, Playa Paraiso apartments for rent, and short term rentals
La Manzanilla Mexico vacation homes for rent by owner and short term rentals La Manzanilla Mexico
Home rentals in Teotitlan del Valle Mexico, apartment rentals, and homes for rent by owner Teotitlan del Valle
Rental houses Puerto Penasco-Rocky Point Mexico, real estate rentals in Puerto Penasco-Rocky Point, rent houses in Puerto Penasco-Rocky Point Mexico, and house rentals Puerto Penasco-Rocky Point Mexico
House rentals in Playa del Carmen Mexico and Playa del Carmen Mexico house rentals
Los Cabos Corridor apartments for rent, homes for rent in Los Cabos Corridor Mexico, and Los Cabos Corridor vacation homes for rent by owner
Condo rentals in Isla Mujeres, condo rentals Isla Mujeres, Isla Mujeres Mexico rent houses, and rental home
Tzintzuntzan Mexico rental apartment and rental houses Tzintzuntzan Mexico
Todos Santos Mexico condo rentals, holiday rentals in Todos Santos, and vacation homes Todos Santos
Rental home Ensenada, houses for rent Ensenada, Ensenada Mexico rent houses, and Ensenada Mexico condos for rent
Club Marena rent house and Club Marena vacation homes for rent by owner
The San Quintin loft classifieds, private advertisements, private listed properties, and studio directories for these city can be mapped.
Elicit and hear Tepatitlan Mexico rent houses and vacation homes.
Uncover, learn, and catch Zapopan real estate rentals, Zapopan vacation homes, and Zapopan rental apartment.
Recognize, espy, and come across rent house in Cozumel, for rent by owner homes, and holiday rentals Cozumel Mexico.
Elicit and move homes for rent by owner in Matamoros Mexico and homes for rent by owner in Matamoros Mexico.
San Quintin Mexico dominion employs many third party listing companies, land owners, home owners, and landlords.
Join our rustic directories, romantic classifieds, hillside classifieds, and hillside indexes mailing list for San Quintin Mexico bed and breakfast rentals, San Quintin Mexico rental properties, and home rentals in San Quintin Mexico.
You can come upon, find, and ascertain houses for rent and San Quintin Mexico bed and breakfast rentals.
Ascertain, devise, and dig up for rent by owner homes Cordoba, Cordoba Mexico apartments for rent, and Cordoba Mexico rental home.
Get going your shakedown online this weekend or on Sunday for your vacation homes for rent by owner San Quintin and homes for rent in San Quintin Mexico.
You can forage the hidden classified advertisements and hidden directories under bed and breakfast rentals in San Quintin Mexico, homes for rent in San Quintin, and vacation homes for rent by owner in San Quintin Mexico.
We made, fashioned, and fabricated this site, For Rent By Owner (FRBO.com) to be foxy, gorgeous, and delicate.
Elicit, contrive, and recognize bed and breakfast rentals Guaymas, vacation rentals, and apartments for rent in Guaymas Mexico.
Our page can appoint, engage, and sign on penthouse ads, private classified ads, and loft classifieds well appointed classifieds and hillside listings to abet your San Quintin Mexico exploration.
Move, ascertain, and ascertain home rentals Valles Mexico, Valles Mexico apartments for rent, and rent houses in Valles.
Townies and seafarers who are rummaging rental properties and are trying to glimpse for rent by owner homes in San Quintin and San Quintin rental homes can go through our page and our spacious advertisements, lakeside lists of marked properties, and oceanfront classified advertisements.
|
|
