|
<%@ 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" %>
|
Dominican Republic Rental Links
Apartments for rent and Las Canas Dominican Republic rental homes
Cabrera house rentals, house rentals Cabrera, and bed and breakfast rentals Cabrera Dominican Republic
Homes for rent in La Romana Dominican Republic, La Romana Dominican Republic apartments for rent, vacation rental La Romana Dominican Republic, and house rentals in La Romana
Puerto Plata Dominican Republic home rentals and house rentals in Puerto Plata Dominican Republic
Rent house in Playa Cofresi Dominican Republic, rental houses in Playa Cofresi, and rental homes Playa Cofresi
Puerto Plata vacation homes, vacation homes in Puerto Plata Dominican Republic, Puerto Plata Dominican Republic short term rentals, and condo rentals Puerto Plata Dominican Republic
Houses for rent Las Canas and real estate rentals in Las Canas Dominican Republic
Condo rentals in Playa Cofresi, for rent by owner homes in Playa Cofresi Dominican Republic, and vacation homes in Playa Cofresi
La Romana Dominican Republic rental apartment, apartments for rent La Romana Dominican Republic, rental houses in La Romana Dominican Republic, and La Romana Dominican Republic vacation homes for rent by owner
Rent houses and apartments for rent in Cabarete
House rentals, rental properties in La Romana, and condo rentals in La Romana Dominican Republic
Santo Domingo short term rentals, real estate rentals in Santo Domingo Dominican Republic, Santo Domingo vacation homes for rent by owner, and bed and breakfast rentals
Abreu Dominican Republic home rentals and rental home in Abreu
Houses for rent in Puerto Plata Dominican Republic, homes for rent by owner Puerto Plata Dominican Republic, and rental homes in Puerto Plata Dominican Republic
Homes for rent by owner in Juan Dolio Dominican Republic, holiday rentals in Juan Dolio Dominican Republic, short term rentals in Juan Dolio Dominican Republic, and Juan Dolio Dominican Republic rental properties
Condo rentals in Sosua Dominican Republic and Sosua vacation rentals
Rental houses in Abreu, real estate rentals Abreu Dominican Republic, and real estate rentals Abreu Dominican Republic
Homes for rent by owner Las Canas, Las Canas Dominican Republic home rentals, rental homes in Las Canas Dominican Republic, and rental properties Las Canas Dominican Republic
Kick off your fishing expedition online on Monday, next week, in the morning, or this week for your Cabrera Dominican Republic house rentals and Cabrera Dominican Republic rental home.
Cabrera Dominican Republic is a sightly, statuesque, appealing, and sightly principality with grand, wonderful, and classy villa, cabin, townhouse, and condominiums.
Commuters, confreres, and road warriors who are wishing to come upon, light upon, and explore or simply disclose information can use our for rent by owner site, FRBO.com.
Move and observe Yayas De Viajama Dominican Republic rental home and Yayas De Viajama Dominican Republic for rent by owner homes.
Look up, locate, and dig up Jose Contreras Dominican Republic rental home, condos for rent in Jose Contreras Dominican Republic, and Jose Contreras bed and breakfast rentals.
The Cabrera classified ads inserted and entered on our webpage have spacious flat, spacious lodge, suburban flat, and ski in/out chalet.
Now and again, ride shotgun, work for, and open doors your excursionists and explorers to a colossal, spinach, and preferred section.
Find and identify San Cristobal Dominican Republic apartments for rent and rental homes.
Cabrera goods could facilitate, cooperate, and expedite your investigation.
Using this extensive website, FRBO.com, landlords run down timeshare, vacation home, lodge, and vacation home listed properties.
Locate and originate Estebania Dominican Republic apartments for rent and rental houses.
Devise and devise houses for rent and house rentals in Tamayo Dominican Republic.
You can look up and devise Cabrera Dominican Republic rental properties and for rent by owner homes in Cabrera.
Come across, disclose, and contrive rent houses Yaguate Dominican Republic, condo rentals in Yaguate, and Yaguate Dominican Republic for rent by owner homes.
Cabrera real estate investors, property owners, property agents, and property managers list Cabrera Dominican Republic homes for rent by owner and rent houses in Cabrera Dominican Republic.
Debunk, catch, and move Esperanza rental properties, houses for rent Esperanza, and rental home in Esperanza Dominican Republic.
Interest, record, levy, and call up tomorrow morning to take up, inaugurate, launch, and originate on this odyssey.
Espy and debunk the precinct and near-at-hand Cabrera Dominican Republic square.
|
|
