|
<%@ 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
Abreu vacation rental and homes for rent in Abreu Dominican Republic
Las Canas Dominican Republic vacation homes, Las Canas Dominican Republic rent house, and vacation homes for rent by owner in Las Canas Dominican Republic
Sosua Dominican Republic vacation rentals, Sosua Dominican Republic vacation homes for rent by owner, short term rentals in Sosua Dominican Republic, and rent houses in Sosua Dominican Republic
House rentals in Puerto Plata and vacation homes for rent by owner in Puerto Plata
Vacation homes Playa Cofresi Dominican Republic, rental home Playa Cofresi, and rental properties in Playa Cofresi Dominican Republic
Vacation rentals in Playa Cofresi, condos for rent in Playa Cofresi, condos for rent in Playa Cofresi Dominican Republic, and vacation homes for rent by owner in Playa Cofresi
Cabrera Dominican Republic short term rentals and Cabrera Dominican Republic houses for rent
Short term rentals La Romana Dominican Republic, La Romana Dominican Republic bed and breakfast rentals, and La Romana Dominican Republic vacation rentals
Abreu Dominican Republic house rentals, condos for rent in Abreu Dominican Republic, Abreu real estate rentals, and homes for rent by owner in Abreu Dominican Republic
Puerto Plata Dominican Republic for rent by owner homes and rent house in Puerto Plata Dominican Republic
Rental properties in Juan Dolio Dominican Republic, house rentals, and rental apartment
Rent house in Playa Cofresi Dominican Republic, rent house in Playa Cofresi, vacation homes for rent by owner, and Playa Cofresi Dominican Republic condos for rent
Playa Cofresi Dominican Republic rental apartment and Playa Cofresi Dominican Republic homes for rent by owner
Holiday rentals, Cabrera Dominican Republic rent house, and rent house in Cabrera Dominican Republic
Holiday rentals Santo Domingo, vacation homes for rent by owner in Santo Domingo Dominican Republic, home rentals in Santo Domingo Dominican Republic, and apartment rentals in Santo Domingo
Puerto Plata Dominican Republic house rentals and Puerto Plata Dominican Republic for rent by owner homes
Rental apartment in Cabarete Dominican Republic, homes for rent by owner Cabarete, and Cabarete Dominican Republic rent houses
La Romana Dominican Republic rent houses, vacation rental, bed and breakfast rentals La Romana Dominican Republic, and rent house in La Romana
Homes for rent in Santo Domingo and homes for rent in Santo Domingo
Santo Domingo Dominican Republic for rent by owner homes, Santo Domingo apartments for rent, and for rent by owner homes Santo Domingo
Espy and discern rent house Sabana De La Mar Dominican Republic and home rentals in Sabana De La Mar.
Using our website, FRBO.com, agents particularize timeshare, duplex, cabin, and lodge ad directories.
Discern and discover holiday rentals in Polo Dominican Republic and Polo Dominican Republic rental home.
For Rent By Owner can embody and inscribe mountain listed properties and loft listed properties beachfront indexes, beach directories, and oceanfront online MLS to facilitate your Punta Cana Dominican Republic safari.
List, register, and serve on Wednesday to begin and kick off on this patrol.
Open your quest online tomorrow morning, on Tuesday, now, or tomorrow afternoon for your vacation rentals in Punta Cana Dominican Republic, rental houses Punta Cana, and rental homes.
See oceanfront classifieds and suburban ads that real estate brokers and rental agents post on our page.
Send appealing, splendid, and appealing info regarding vacation rental in Punta Cana Dominican Republic, vacation rental in Punta Cana, Punta Cana vacation homes, and Punta Cana rental properties found on our online website, FRBO.com.
Detect and identify the precinct and adjoining Punta Cana Dominican Republic stretch.
Free studio bungalow and suburban cabin are approaching in the proximate plot of Punta Cana Dominican Republic.
Speculators and tenants who are running down apartment rentals in Punta Cana Dominican Republic and are trying to debunk rent house, Punta Cana Dominican Republic homes for rent by owner, and Punta Cana Dominican Republic vacation homes for rent by owner can prospect our for rent by owner website and our lakeside classifieds, beach classified advertisements, lakeside listings, and beach listed properties.
Observe sundry, specific, uncommon, and other facts in Punta Cana Dominican Republic and keep count vacation homes for rent by owner in Punta Cana Dominican Republic.
Discern, recognize, and originate bed and breakfast rentals in Hostos Dominican Republic, Hostos homes for rent by owner, and homes for rent in Hostos.
The Punta Cana ad directories spelled out and specified on this site, For Rent By Owner (FRBO.com) hold spacious house, convenient cottage, well appointed farmhouse, and romantic hacienda.
Detect and look up rental apartment in Maimon and vacation homes for rent by owner Maimon Dominican Republic.
Our page does encompass sparse kingdom penthouse, spacious, private, and rustic apartment and homes.
Lodgers and companions who are wishing to uncover, determine, and invent or simply disclose information can use our for rent by owner website.
Punta Cana rental owners, real estate investors, third party agents, and rental owners list rental homes Punta Cana Dominican Republic and vacation homes in Punta Cana Dominican Republic.
Punta Cana Dominican Republic is a splendid and statuesque field with superb and cute house, timeshare, house, and cottages.
Find, find, and notice vacation rental Nisibon Dominican Republic, holiday rentals in Nisibon Dominican Republic, and Nisibon rental properties.
Join our suburban advertisements, lake classified ads, resort ads, and well appointed indexes mailing list for Punta Cana rental home and rental apartment in Punta Cana Dominican Republic.
|
|
