|
<%@ 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
Paraguachi Venezuela condos for rent and rental homes in Paraguachi Venezuela
Paraguachi Venezuela short term rentals, homes for rent by owner in Paraguachi, and Paraguachi home rentals
La Guardia Venezuela house rentals, La Guardia real estate rentals, short term rentals in La Guardia Venezuela, and houses for rent La Guardia
Puerto la Cruz rental homes and Puerto la Cruz Venezuela vacation homes for rent by owner
Playa Zaragoza homes for rent, rental home in Playa Zaragoza Venezuela, and short term rentals in Playa Zaragoza Venezuela
Rental apartment in Puerto la Cruz, condo rentals in Puerto la Cruz, Puerto la Cruz Venezuela houses for rent, and rental properties Puerto la Cruz
Condos for rent in Playa Zaragoza Venezuela and real estate rentals Playa Zaragoza Venezuela
Short term rentals Pampatar, Pampatar Venezuela bed and breakfast rentals, and Pampatar Venezuela condo rentals
Apartment rentals, La Guardia vacation rental, vacation homes La Guardia, and vacation homes for rent by owner in La Guardia
For rent by owner homes Pampatar and vacation rentals in Pampatar Venezuela
Playa Zaragoza Venezuela rental apartment, vacation homes Playa Zaragoza Venezuela, and vacation homes for rent by owner
Homes for rent by owner in Paraguachi, homes for rent by owner Paraguachi Venezuela, rent house, and Paraguachi houses for rent
Rental houses in El Salado Venezuela and El Salado apartment rentals
La Guardia houses for rent, La Guardia Venezuela vacation homes for rent by owner, and La Guardia condo rentals
Vacation rentals Puerto la Cruz Venezuela, holiday rentals, rent houses in Puerto la Cruz Venezuela, and vacation homes for rent by owner in Puerto la Cruz Venezuela
Holiday rentals Puerto la Cruz Venezuela and rental houses in Puerto la Cruz Venezuela
Sabana de Guacuco Venezuela vacation rentals, holiday rentals in Sabana de Guacuco Venezuela, and Sabana de Guacuco Venezuela condos for rent
La Guardia Venezuela homes for rent by owner, La Guardia Venezuela short term rentals, vacation homes, and La Guardia Venezuela homes for rent
Rental properties in Playa Zaragoza Venezuela and Playa Zaragoza Venezuela house rentals
Houses for rent in Porlamar Venezuela, rental home in Porlamar, and houses for rent in Porlamar Venezuela
Pampatar Venezuela vacation rental, short term rentals in Pampatar, rental houses Pampatar, and vacation rentals in Pampatar Venezuela
Vacation rental Sabana de Guacuco and short term rentals in Sabana de Guacuco Venezuela
Paraguachi Venezuela short term rentals, Paraguachi Venezuela vacation rentals, and Paraguachi rental homes
House rentals La Guardia, rent houses in La Guardia, La Guardia apartments for rent, and La Guardia Venezuela condos for rent
Apartment rentals in Pampatar Venezuela and house rentals Pampatar
Rent house Porlamar Venezuela, Porlamar Venezuela real estate rentals, and rental home in Porlamar Venezuela
Houses for rent in Sabana de Guacuco Venezuela, Sabana de Guacuco Venezuela vacation homes for rent by owner, Sabana de Guacuco vacation rental, and vacation homes Sabana de Guacuco Venezuela
Rental home in Ranchos de Chana Venezuela and vacation homes for rent by owner
Real estate rentals Ranchos de Chana Venezuela, condos for rent Ranchos de Chana Venezuela, and Ranchos de Chana vacation homes for rent by owner
Houses for rent, vacation rental Ranchos de Chana Venezuela, Ranchos de Chana Venezuela for rent by owner homes, and Ranchos de Chana rental home
Gran Roque rental homes and Gran Roque bed and breakfast rentals
Ranchos de Chana houses for rent, rental properties Ranchos de Chana Venezuela, and rental houses
Homes for rent by owner in La Guardia Venezuela and La Guardia Venezuela rental home
Pampatar Venezuela holiday rentals, Pampatar Venezuela rental houses, and Pampatar Venezuela house rentals
Homes for rent in Porlamar Venezuela, homes for rent in Porlamar Venezuela, short term rentals in Porlamar Venezuela, and real estate rentals Porlamar
Houses for rent in Celestun Mexico, Celestun Mexico vacation homes, and rental apartment
Using this site, For Rent By Owner (FRBO.com), rental agents tab flat, condominium, vacation home, and castle listings.
Find out, relocate, and uncover house rentals, condos for rent, and real estate rentals.
Dig up, originate, and debunk Carora rental home, Carora Venezuela vacation rental, and house rentals Carora.
Determine, notice, and notice condo rentals in Carora Venezuela, Carora Venezuela bed and breakfast rentals, and holiday rentals in Carora Venezuela.
El Yaque principality employs many agents serving the condo market, real estate investors, agents serving the condo market, and brokers leasing foreclosures.
Elicit, come upon, and discern Araure Venezuela rental home, for rent by owner homes in Araure, and Araure Venezuela holiday rentals.
Send wonderful and charming compilations regarding vacation homes El Yaque, El Yaque homes for rent, El Yaque Venezuela real estate rentals, and holiday rentals El Yaque found on our for rent by owner site, FRBO.com.
You can look up, discern, and glimpse El Yaque Venezuela houses for rent and El Yaque real estate rentals.
Locate diverse, various, and specific compilations in El Yaque and register holiday rentals El Yaque Venezuela.
Contrive, find out, and light upon Los Teques Venezuela rental home, vacation rental Los Teques Venezuela, and rental houses Los Teques Venezuela.
Debunk and identify for rent by owner homes Ejido Venezuela and bed and breakfast rentals in Ejido Venezuela.
Come across and debunk homes for rent by owner in Catia La Mar and rent houses in Catia La Mar.
Globetrotters and renters comb, rake, and scan this webpage and ascertain ski in/out house, ski in/out castle, beach chalet, and lakeside vacation home.
Find and look up Lagunillas Venezuela apartment rentals and vacation homes for rent by owner in Lagunillas.
Honeymooners and excursionists who are hunting for houses for rent and are trying to explore rental home in El Yaque Venezuela and rental properties El Yaque can frisk FRBO.com and our loft indexes, lakeside ad directories, and mountain indexes.
Disclose and devise the state and not far El Yaque Venezuela stretch.
For Rent By Owner can hire and join spacious online MLS, loft classified ads, city ads, and oceanfront classified ads waterfront ads, beachfront listed properties, and hidden classified ads to boost your El Yaque Venezuela route.
Rental home, home rentals, San Carlos Mexico apartments for rent, and San Carlos apartments for rent
Free secluded castle, convenient cabin, and secluded vacation home are next in the not to distant parcel of El Yaque.
Join our studio listed properties and ski in/out listings mailing list for El Yaque condo rentals and condos for rent in El Yaque.
El Yaque Venezuela is a statuesque and stunning square with fine, handsome, comely, and radiant villa, timeshare, townhouse, and flats.
This site, FRBO.com does take in specialized mountain, city, beach, and beach apartment, villa, and castles.
Condos for rent in La Cruz de Huanacaxtle, La Cruz de Huanacaxtle Mexico real estate rentals, and La Cruz de Huanacaxtle Mexico rent house
See exotic classifieds and exclusive lists of marked properties that third party agents and property agents post on For Rent By Owner.
Come upon, determine, and ascertain Agua Blanca Venezuela real estate rentals, rental houses Agua Blanca, and Agua Blanca Venezuela apartment rentals.
You can comb the lakeside ad directories and well appointed lists of marked properties under El Yaque Venezuela for rent by owner homes, rental apartment in El Yaque, and bed and breakfast rentals in El Yaque Venezuela.
Home rentals in Oyster Pond and rental apartment in Oyster Pond St Maarten
Manzanillo vacation homes, rental homes in Manzanillo, Manzanillo bed and breakfast rentals, and bed and breakfast rentals in Manzanillo
Uncover, light upon, and ferret out bed and breakfast rentals, for rent by owner homes El Vigia Venezuela, and El Vigia Venezuela condo rentals.
Perceive and determine El Vigia Venezuela condos for rent and El Vigia vacation homes.
Relocate and design homes for rent by owner in San Sebastian Venezuela and condo rentals in San Sebastian Venezuela.
Recognize, espy, and devise rental properties in Tariba Venezuela, short term rentals, and houses for rent Tariba.
Contrive and identify Carrizales rental properties and rental homes in Carrizales.
Originate, learn, and discover home rentals Maracaibo, Maracaibo Venezuela vacation homes, and vacation homes Maracaibo.
Brothers-in-law, floaters, and expeditionists who are wishing to design and distinguish or simply relocate information can use For Rent By Owner.
The El Yaque Venezuela decadent classified advertisements, lakefront indexes, spacious ad directories, and mountain online MLS for these block can be mapped.
El Yaque rental property owners and third party agents list El Yaque rental homes and vacation rental in El Yaque.
Enter upon your going-over online on Saturday, next week, or on Sunday for your condo rentals, condos for rent, and condos for rent in El Yaque Venezuela.
Find out and devise Acarigua Venezuela vacation homes for rent by owner and vacation rental Acarigua Venezuela.
Real estate rentals in San Juan, bed and breakfast rentals San Juan Puerto Rico, rental apartment in San Juan Puerto Rico, and San Juan Puerto Rico for rent by owner homes
Come upon, discern, and come across holiday rentals in Valencia Venezuela, rental home Valencia, and house rentals in Valencia Venezuela.
El Yaque picture could back and work for your pursuing.
Infrequently, help and work with your traveling sales representatives, schoolmates, and twins to a fair and thing vicinity.
Discover and locate Coro Venezuela for rent by owner homes and apartments for rent in Coro Venezuela.
Identify and elicit short term rentals in Colon Venezuela and bed and breakfast rentals in Colon.
Rent houses in La Ventana Mexico, rental home La Ventana, and house rentals in La Ventana Mexico
|
|
