|
<%@ 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" %>
|
Venezuela Rental Links
Short term rentals in Gran Roque Venezuela and rent house
Rental properties El Yaque, El Yaque for rent by owner homes, and condo rentals in El Yaque Venezuela
Rental houses in Gran Roque, rental houses in Gran Roque Venezuela, Gran Roque Venezuela rental home, and rent houses in Gran Roque Venezuela
Bed and breakfast rentals Puerto la Cruz and rental apartment
Vacation homes for rent by owner, bed and breakfast rentals in La Guardia Venezuela, and house rentals
For rent by owner homes Porlamar Venezuela, Porlamar Venezuela condos for rent, homes for rent in Porlamar, and apartments for rent Porlamar
Homes for rent by owner in Gran Roque Venezuela and Gran Roque Venezuela real estate rentals
La Guardia Venezuela holiday rentals, La Guardia real estate rentals, and rental apartment in La Guardia Venezuela
Houses for rent in El Yaque, El Yaque Venezuela vacation homes, condo rentals El Yaque Venezuela, and El Yaque houses for rent
El Yaque real estate rentals and for rent by owner homes El Yaque Venezuela
House rentals Paraguachi Venezuela, condos for rent, and Paraguachi Venezuela homes for rent by owner
Rental houses Paraguachi, Paraguachi Venezuela houses for rent, condos for rent in Paraguachi Venezuela, and Paraguachi Venezuela for rent by owner homes
Houses for rent in Porlamar Venezuela and Porlamar vacation rental
Sabana de Guacuco Venezuela holiday rentals, Sabana de Guacuco Venezuela rental apartment, and rental houses Sabana de Guacuco Venezuela
Paraguachi Venezuela house rentals, homes for rent in Paraguachi, rent house, and houses for rent in Paraguachi Venezuela
La Guardia apartment rentals and home rentals in La Guardia
Ranchos de Chana Venezuela home rentals, Ranchos de Chana Venezuela condo rentals, and condos for rent in Ranchos de Chana Venezuela
El Yaque house rentals, El Yaque Venezuela apartment rentals, vacation homes in El Yaque, and home rentals
Rental apartment in El Salado Venezuela and homes for rent El Salado
La Guardia Venezuela rental homes, La Guardia Venezuela rental homes, and rental houses in La Guardia Venezuela
Houses for rent in Pampatar Venezuela, short term rentals in Pampatar, Pampatar Venezuela apartment rentals, and home rentals in Pampatar
Houses for rent in Porlamar Venezuela and rental home in Porlamar Venezuela
La Guardia is a grand and pulchritudinous tract with sightly, delightful, and bewitching home, apartment, flat, and haciendas.
Design, explore, and find out condo rentals Bachaquero, condo rentals Bachaquero, and homes for rent Bachaquero.
This website, FRBO.com does incorporate singular domain lakefront and beachfront cottage, duplex, and townhouses.
Kick off your research online on Friday, this weekend, tomorrow morning, or on Sunday for your La Guardia Venezuela vacation homes, La Guardia vacation rentals, and short term rentals in La Guardia.
Come upon, find out, and come across Araure Venezuela short term rentals, rental houses in Araure Venezuela, and Araure Venezuela holiday rentals.
The La Guardia Venezuela classified ads posted and tabbed on this webpage seat decadent castle, private timeshare, beachfront home, and oceanfront home.
Using this webpage, rental property owners book ranch and castle indexes.
Identify, locate, and dig up rental apartment Apartaderos, rental properties, and Apartaderos Venezuela rental apartment.
See exclusive directories, exotic ad directories, resort classified advertisements, and mountain ad directories that property owners and third party agents post on our site, FRBO.com.
La Guardia Venezuela tract employs many rental owners and property brokers.
Look up, ferret out, and learn Caraballeda Venezuela condo rentals, Caraballeda vacation rentals, and rental homes Caraballeda Venezuela.
La Guardia rental property owners and property brokers list rental houses La Guardia Venezuela, rent houses in La Guardia, and La Guardia rent house.
Recently available lakefront villa, spacious condominium, and spacious chalet are not remote in the contiguous dominion of La Guardia Venezuela.
Ascertain, find out, and explore Carupano Venezuela rent houses, vacation homes, and vacation homes for rent by owner in Carupano Venezuela.
Invent and dig up San Casimiro Venezuela holiday rentals and San Casimiro vacation homes for rent by owner.
Glimpse and look up rent house Trujillo Venezuela and bed and breakfast rentals.
You can look up and uncover rental homes in La Guardia and house rentals La Guardia Venezuela.
Determine, detect, and move for rent by owner homes in Tia Juana Venezuela, rent houses in Tia Juana, and rental properties in Tia Juana.
Learn, debunk, and invent Maracaibo Venezuela rental houses, Maracaibo Venezuela vacation rentals, and for rent by owner homes Maracaibo Venezuela.
Find something else, unconventional, and small number details in La Guardia Venezuela and enter vacation rentals La Guardia.
Explore, find out, and look up rental homes, condo rentals in Turen Venezuela, and rental properties in Turen Venezuela.
Appoint and reserve on Saturday to take up and get going on this march.
Roomers and trekkers who are wishing to discover, observe, and observe or simply locate information can use our website, FRBO.com.
The La Guardia Venezuela loft indexes, beach lists of marked properties, and lake advertisements for these dominion can be mapped.
Espy and glimpse rent house San Antonio Del Tachira and house rentals in San Antonio Del Tachira Venezuela.
|
|
