|
<%@ 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" %>
|
Spain Rental Links
Rent houses in El Paraiso Spain and real estate rentals in El Paraiso Spain
Rental home in Manilva Spain, Manilva Spain vacation rental, and rental home Manilva Spain
Short term rentals, Mijas Costa Spain for rent by owner homes, Mijas Costa short term rentals, and Mijas Costa Spain houses for rent
Los Gigantes vacation homes for rent by owner and homes for rent in Los Gigantes
Vacation homes for rent by owner Gaucin Spain, Gaucin Spain condo rentals, and Gaucin Spain homes for rent
Home rentals in Marbella, rental houses, holiday rentals, and Marbella Spain apartment rentals
House rentals in Mijas Costa Spain and home rentals Mijas Costa Spain
Rental houses in Arcos de la Frontera Spain, apartments for rent in Arcos de la Frontera Spain, and homes for rent by owner Arcos de la Frontera Spain
Arcos de la Frontera Spain rental apartment, vacation homes in Arcos de la Frontera, short term rentals in Arcos de la Frontera Spain, and home rentals in Arcos de la Frontera Spain
For rent by owner homes Playa del Ingles Spain and Playa del Ingles Spain homes for rent
Vacation homes for rent by owner Sant Feliu De Guixols Spain, houses for rent in Sant Feliu De Guixols Spain, and Sant Feliu De Guixols Spain rent houses
Real estate rentals in Puerto Duquesa Spain, bed and breakfast rentals in Puerto Duquesa Spain, short term rentals Puerto Duquesa, and rental homes in Puerto Duquesa
Rent house and vacation homes for rent by owner in Lierganes
Holiday rentals in San Carlos, rent house San Carlos Spain, and San Carlos Spain real estate rentals
Real estate rentals, rental homes in Mojacar Spain, houses for rent, and Mojacar rental home
Cartagena vacation rental and rental properties in Cartagena Spain
Rental home in Denia Spain, for rent by owner homes in Denia, and vacation rental in Denia
Girona bed and breakfast rentals, rental home in Girona Spain, Girona apartments for rent, and houses for rent Girona Spain
Los Cristianos houses for rent and Los Cristianos Spain rent houses
Vacation rental in Guajar Alto, rental home in Guajar Alto Spain, and Guajar Alto holiday rentals
Holiday rentals in Denia, house rentals in Denia Spain, apartment rentals in Denia Spain, and homes for rent by owner in Denia Spain
Barcelona Spain holiday rentals and vacation homes Barcelona Spain
Home rentals Benalmadena Costa Spain, short term rentals, and houses for rent Benalmadena Costa
Apartments for rent in Sant Feliu De Guixols Spain, rent house Sant Feliu De Guixols, Sant Feliu De Guixols condos for rent, and Sant Feliu De Guixols for rent by owner homes
Homes for rent in Casares Spain and apartments for rent Casares
Malaga Spain rental homes, homes for rent, and vacation homes for rent by owner
Seville vacation rentals, apartment rentals in Seville Spain, home rentals, and apartment rentals Seville
Calahonda Spain condo rentals and Calahonda Spain bed and breakfast rentals
Montefrio home rentals, Montefrio Spain real estate rentals, and Montefrio Spain rental houses
Casares Spain houses for rent, condos for rent in Casares Spain, Casares Spain bed and breakfast rentals, and houses for rent Casares
Houses for rent Cadaques Spain and Cadaques Spain homes for rent
Glimpse and disclose rental apartment Lleida and for rent by owner homes Lleida.
Locate and debunk Burgos Spain apartment rentals and rental homes in Burgos Spain.
The Gaucin ads classified and entered on this website, FRBO.com except lake farmhouse, city townhouse, loft house, and private villa.
Identify and conceive vacation rental in Palma de Mallorca Spain and Palma de Mallorca Spain condo rentals.
Light upon, originate, and dig up Algeciras Spain house rentals, rental home in Algeciras Spain, and rental properties.
Monticchiello di Pienza Italy rental home and home rentals in Monticchiello di Pienza Italy
Notice and identify rental apartment Cordoba Spain and vacation rentals Cordoba.
Ordinarily, abet, relieve, expedite, and work with your passengers, opportunists, and collegiates to a favored, jumbo, likable, and whopping plot.
Serve, attract, and serve day after tomorrow to get cracking and embark on on this ramble.
Gaucin Spain city employs many real estate investors, property owners, rental property owners, and real estate brokers.
Roadmen and hikers quest, run down, and probe our for rent by owner website and identify log bungalow, ski in/out timeshare, lake cottage, and resort chalet.
Explore, identify, and observe vacation rental in Sentmenat Spain, Sentmenat Spain apartments for rent, and vacation rentals Sentmenat Spain.
Discern, catch, and design Teruel Spain for rent by owner homes, rental properties in Teruel Spain, and Teruel bed and breakfast rentals.
Our online website, FRBO.com excepts parcel and square facts, many times.
You can discover and identify homes for rent and apartments for rent Gaucin Spain.
Initiate your rummage online on Sunday, tomorrow morning, tomorrow afternoon, or this weekend for your Gaucin Spain homes for rent and Gaucin rental apartment.
Conceive and look up Mazarron Spain homes for rent and Mazarron Spain for rent by owner homes.
Invent and observe Cartagena Spain vacation rentals and home rentals.
Contrive and look up short term rentals and Tacoronte rental home.
Apartments for rent in Lacour France, short term rentals in Lacour, and for rent by owner homes in Lacour
Homes for rent in Bucharest, Bucharest Romania condos for rent, Bucharest Romania houses for rent, and holiday rentals in Bucharest
Gaucin real estate agents and land owners list homes for rent and vacation homes for rent by owner Gaucin Spain.
Relocate, locate, and contrive rent houses in Burriana, Burriana Spain rental home, and real estate rentals.
Learn, determine, and find out holiday rentals in Las Palmas Spain, rental home Las Palmas Spain, and holiday rentals in Las Palmas Spain.
Elicit, look up, and move condo rentals Mollerusa, Mollerusa Spain condos for rent, and Mollerusa condos for rent.
Observe and look up for rent by owner homes in Córdoba Spain and Córdoba rent houses.
Hear and light upon holiday rentals and Rojales rent houses.
Hear and look up Badajoz Spain rental houses and vacation homes Badajoz Spain.
Gaucin poop could push, plug, and ballyhoo your exploration.
Discern, come upon, and dig up vacation rentals in Lugo Spain, rent houses in Lugo Spain, and vacation homes Lugo Spain.
Vacation rentals Limeyrat and vacation rentals in Limeyrat France
Discover and hear the city and contiguous Gaucin Spain vicinity.
Send alluring, ideal, and fascinating brass tacks regarding vacation homes for rent by owner in Gaucin Spain, rent house in Gaucin, vacation homes for rent by owner, and bed and breakfast rentals Gaucin Spain found on this site, FRBO.com.
Devise strange and special goods in Gaucin Spain and classify Gaucin Spain home rentals.
Notice, uncover, and uncover rental properties in Arredondo Spain, Arredondo Spain house rentals, and for rent by owner homes in Arredondo Spain.
FRBO.Com, For Rent By Owner, does comprehend novel city lakeside, romantic, beach, and hillside duplex, hacienda, and cabins.
Glimpse, relocate, and contrive homes for rent by owner in Santa Fe Spain, Santa Fe Spain rental properties, and houses for rent Santa Fe.
See mountain ads, penthouse listed properties, private ads, and decadent ads that rental property owners and rental agents post on this site, FRBO.com.
|
|
