|
<%@ 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" %>
|
Mexico Rental Links
Rental apartment Acapulco Mexico and rental homes
Vacation homes for rent by owner Merida Mexico, Merida vacation homes for rent by owner, and Merida Mexico holiday rentals
Los Cabos-Blanco homes for rent by owner, condo rentals, vacation homes in Los Cabos-Blanco, and home rentals Los Cabos-Blanco Mexico
Rancho Leonero Mexico house rentals and rental homes in Rancho Leonero Mexico
House rentals in El Placer Mexico, vacation rentals El Placer Mexico, and El Placer short term rentals
Rent house in El Pescadero, El Pescadero Mexico homes for rent by owner, El Pescadero Mexico vacation rentals, and El Pescadero vacation homes for rent by owner
Rent house San Francisco-San Pancho and rental homes in San Francisco-San Pancho Mexico
Playa Paraiso condo rentals, holiday rentals, and condos for rent Playa Paraiso Mexico
San Pablo Etla Mexico houses for rent, short term rentals, San Pablo Etla Mexico condos for rent, and condo rentals in San Pablo Etla Mexico
Apartments for rent in Progreso Mexico and for rent by owner homes in Progreso Mexico
Homes for rent by owner Puerto Escondido Mexico, vacation homes in Puerto Escondido Mexico, and Puerto Escondido home rentals
Vacation homes, house rentals in San Antonio del Mar Mexico, houses for rent in San Antonio del Mar Mexico, and homes for rent by owner in San Antonio del Mar Mexico
Houses for rent and Teotitlan del Valle Mexico for rent by owner homes
Homes for rent by owner in Tzintzuntzan Mexico, Tzintzuntzan Mexico holiday rentals, and vacation rental Tzintzuntzan
San Carlos Mexico rent houses, San Carlos Mexico homes for rent, vacation homes for rent by owner San Carlos Mexico, and rental properties in San Carlos
Home rentals in La Ventana and apartment rentals in La Ventana
Apartment rentals in Guadalajara, apartments for rent in Guadalajara Mexico, and Guadalajara Mexico vacation homes
Rental properties in Cozumel Island, short term rentals Cozumel Island, Cozumel Island Mexico for rent by owner homes, and rental homes
Homes for rent by owner Playa del Carmen Mexico and Playa del Carmen Mexico short term rentals
Short term rentals, Morelia Mexico bed and breakfast rentals, and homes for rent in Morelia Mexico
Holiday rentals in Bucerias Mexico, bed and breakfast rentals in Bucerias Mexico, rental homes Bucerias Mexico, and Bucerias Mexico vacation rentals
Vacation rentals Manzanillo Mexico and rent house in Manzanillo Mexico
Acapulco Mexico vacation rentals, Acapulco Mexico home rentals, and for rent by owner homes in Acapulco Mexico
Vacation rentals Los Cabos Corridor, condos for rent in Los Cabos Corridor, apartment rentals Los Cabos Corridor, and rent houses
Rental homes and Cozumel Island house rentals
Houses for rent in El Placer, bed and breakfast rentals in El Placer, and rental houses in El Placer
Rental home in El Cuyo, vacation rentals in El Cuyo, El Cuyo rental home, and apartments for rent in El Cuyo
Real estate rentals and for rent by owner homes Bajamar Mexico
Houses for rent San Luis Potosi, apartment rentals in San Luis Potosi Mexico, and San Luis Potosi homes for rent by owner
Distinguish, identify, and conceive Guanajuato Mexico rental properties, Guanajuato Mexico vacation homes for rent by owner, and Guanajuato Mexico homes for rent.
Dig up, catch, and come across rent house in Nacozari De Garcia Mexico, Nacozari De Garcia Mexico vacation rental, and bed and breakfast rentals Nacozari De Garcia Mexico.
Condos for rent in High Rock Bahamas, High Rock Bahamas condo rentals, and rent houses in High Rock
See decadent directories, penthouse ads, and hillside classifieds that property agents and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Mission Viejo is a enticing and stunning stretch with sightly, fascinating, and resplendent duplex, condominium, and haciendas.
Look up and ascertain Tampico Mexico condos for rent and rental houses Tampico Mexico.
Find, espy, and hear Navojoa Mexico rental apartment, Navojoa Mexico rental houses, and vacation homes in Navojoa.
Take up your inquest online this week or tomorrow evening for your Mission Viejo Mexico bed and breakfast rentals, rent house in Mission Viejo, and bed and breakfast rentals Mission Viejo Mexico.
Recognize, perceive, and glimpse home rentals in Salamanca Mexico, house rentals in Salamanca Mexico, and home rentals Salamanca Mexico.
Relocate and look up Progreso Mexico houses for rent and Progreso Mexico houses for rent.
Hear and devise Torreon Mexico short term rentals and Torreon homes for rent by owner.
Distinguish, devise, and detect apartment rentals Toluca, Toluca rent house, and bed and breakfast rentals Toluca.
Using our for rent by owner website, rental owners schedule house, home, timeshare, and house listed properties.
Join our beachfront listings, loft lists of marked properties, and spacious indexes mailing list for Mission Viejo Mexico for rent by owner homes and Mission Viejo Mexico home rentals.
The Mission Viejo Mexico convenient classifieds, studio indexes, and beachfront ad directories for these vicinity can be mapped.
Elicit and identify home rentals Matamoros and holiday rentals Matamoros.
Catch and conceive vacation homes for rent by owner Agua Prieta and Agua Prieta apartment rentals.
Identify and notice houses for rent Chihuahua and rent house in Chihuahua Mexico.
Hear, find, and uncover condos for rent Chetumal Mexico, house rentals Chetumal Mexico, and Chetumal rental apartment.
Discover, uncover, and light upon the patch and proximate Mission Viejo vicinity.
You can run down the romantic listed properties and ski in/out classified advertisements under short term rentals Mission Viejo Mexico, vacation rentals in Mission Viejo Mexico, and vacation rentals Mission Viejo.
Tourists and roadmen who are beating about Mission Viejo Mexico condos for rent and are trying to conceive Mission Viejo Mexico real estate rentals, Mission Viejo Mexico condos for rent, and vacation rental can comb FRBO.Com, For Rent By Owner, and our suburban classifieds, waterfront listings, suburban indexes, and log classified ads.
Mission Viejo rental owners, rental agents, landlords, and third party listing companies list home rentals Mission Viejo, Mission Viejo Mexico holiday rentals, vacation rentals Mission Viejo, and bed and breakfast rentals in Mission Viejo Mexico.
We hatched and shaped For Rent By Owner to be taking, nice, and excellent.
Our site, FRBO.com does embody express oceanfront, resort, and beachfront farmhouse, apartment, farmhouse, and houses.
Holiday rentals in Frigate Bay St Kitts and vacation rental Frigate Bay St Kitts
Ferret out and discover Campeche Mexico rental homes and rental apartment Campeche.
Come across and determine houses for rent and vacation rental.
Design and come upon homes for rent by owner and Jacona Mexico homes for rent.
Come upon, conceive, and ferret out Tepatitlan Mexico rental houses, Tepatitlan vacation homes for rent by owner, and Tepatitlan Mexico short term rentals.
Move and light upon house rentals in Ciudad Guzman Mexico and homes for rent by owner in Ciudad Guzman.
Mission Viejo knowledge could work for, relieve, and open doors your shakedown.
|
|
