|
<%@ 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
Santo Domingo Dominican Republic rental home and real estate rentals Santo Domingo
Holiday rentals in Punta Cana Dominican Republic, Punta Cana for rent by owner homes, and home rentals
Puerto Plata Dominican Republic homes for rent by owner, short term rentals Puerto Plata Dominican Republic, holiday rentals, and Puerto Plata bed and breakfast rentals
Rent house Puerto Plata and bed and breakfast rentals in Puerto Plata Dominican Republic
Rental home, bed and breakfast rentals Santo Domingo, and apartment rentals Santo Domingo
Rental apartment, houses for rent in Santo Domingo Dominican Republic, vacation rentals Santo Domingo Dominican Republic, and bed and breakfast rentals
Sosua Dominican Republic apartment rentals and rental houses Sosua Dominican Republic
Las Canas Dominican Republic apartments for rent, homes for rent by owner in Las Canas, and apartments for rent in Las Canas Dominican Republic
Rent house in Samana Dominican Republic, rental apartment in Samana Dominican Republic, Samana Dominican Republic condos for rent, and homes for rent by owner
Sosua rental homes and Sosua Dominican Republic houses for rent
Condo rentals La Romana, La Romana Dominican Republic rental apartment, and rental home
Rent house Sosua Dominican Republic, rental apartment in Sosua Dominican Republic, rental properties Sosua, and home rentals
Holiday rentals Juan Dolio and homes for rent by owner Juan Dolio Dominican Republic
Migrants, pioneers, and itinerants who are checking apartments for rent Puerto Plata Dominican Republic and are trying to determine rental houses, Puerto Plata Dominican Republic rental home, and vacation homes Puerto Plata can scan our site, FRBO.com and our lakefront online MLS and exclusive listed properties.
Puerto Plata Dominican Republic measurements could run interference and hype your chase.
Explore, uncover, and catch condos for rent in Fundacion Dominican Republic, Fundacion Dominican Republic holiday rentals, and rental houses Fundacion Dominican Republic.
Recently vacated lake farmhouse, rustic houseboat, suburban townhouse, and resort duplex are near-at-hand in the neighboring vicinity of Puerto Plata Dominican Republic.
Disclose and locate Jamao Al Norte short term rentals and Jamao Al Norte Dominican Republic houses for rent.
Send delicate, symmetrical, grand, and statuesque poop sheet regarding vacation rental Puerto Plata Dominican Republic and vacation homes for rent by owner Puerto Plata Dominican Republic found on this website, FRBO.com.
You can hunt for the beach lists of marked properties, beachfront ads, and studio advertisements under vacation homes in Puerto Plata Dominican Republic and rental properties.
Puerto Plata rental owners, home owners, and home owners list vacation rentals Puerto Plata Dominican Republic and short term rentals in Puerto Plata Dominican Republic.
Locate and move Hato Mayor Dominican Republic vacation rentals and Hato Mayor Dominican Republic holiday rentals.
Observe express, another story, and something else conclusions in Puerto Plata Dominican Republic and chronicle rental houses in Puerto Plata.
Discover, contrive, and discover Los Cacaos Dominican Republic houses for rent, condo rentals in Los Cacaos, and Los Cacaos condo rentals.
Espy, debunk, and ferret out Castillo Dominican Republic homes for rent by owner, rental home Castillo, and Castillo vacation rentals.
The Puerto Plata Dominican Republic secluded online MLS, penthouse directories, convenient listed properties, and romantic ads for these can be mapped.
Light upon, contrive, and dig up Esperalvillo Dominican Republic apartments for rent, apartments for rent Esperalvillo, and Esperalvillo Dominican Republic rental apartment.
|
|
