|
<%@ 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" %>
|
California Rental Links
Bed and breakfast rentals in Idyllwild and Idyllwild California homes for rent
Vacation homes for rent by owner San Jose California, San Jose California rental apartment, and San Jose California real estate rentals
Bed and breakfast rentals Willits California, Willits California homes for rent, Willits California vacation homes for rent by owner, and Willits California rental apartment
Corcoran California rent house and condo rentals in Corcoran
Vacation rental in Coalinga, rental home in Coalinga California, and Coalinga California condo rentals
Santa Paula California condos for rent, Santa Paula California rental apartment, Santa Paula California rental homes, and for rent by owner homes in Santa Paula
Homes for rent by owner Ukiah California and rental houses in Ukiah California
Vacation homes in Modesto, rental houses in Modesto California, and vacation rental in Modesto California
Stockton rental home, short term rentals Stockton California, Stockton California condo rentals, and Stockton California rental apartment
Earlimart houses for rent and vacation rentals Earlimart California
Vacation homes, rental apartment in Lake Isabella, and Lake Isabella vacation rentals
Hollister vacation rentals, Hollister California vacation rentals, rental houses in Hollister California, and houses for rent in Hollister
Bed and breakfast rentals in Visalia California and vacation homes Visalia
Vacation homes in Upper Lake-Clearlake Oaks California, homes for rent Upper Lake-Clearlake Oaks, and Upper Lake-Clearlake Oaks condo rentals
Inglewood California condos for rent, rent house Inglewood, Inglewood houses for rent, and Inglewood California condos for rent
North Coast bed and breakfast rentals and North Coast California real estate rentals
Houses for rent Hemet-San Jacinto, Hemet-San Jacinto rental home, and rental homes in Hemet-San Jacinto
Waterford rental homes, homes for rent by owner in Waterford California, Waterford California vacation rental, and condos for rent in Waterford
Holiday rentals Susanville California and Susanville California vacation homes for rent by owner
McFarland-Delano California homes for rent, McFarland-Delano California rental properties, and vacation rental in McFarland-Delano California
Holiday rentals in Exeter California, Exeter California for rent by owner homes, Exeter home rentals, and Exeter California houses for rent
Woodlake-Three Rivers California vacation homes and rental houses in Woodlake-Three Rivers
Vacation rental Chowchilla, Chowchilla condo rentals, and vacation rental in Chowchilla
Rent houses San Mateo, rental properties in San Mateo, rent houses in San Mateo California, and San Mateo rental homes
Merced rent houses and Merced California short term rentals
Seaside-Monterey bed and breakfast rentals, Seaside-Monterey California vacation homes, and rental houses in Seaside-Monterey
Bed and breakfast rentals Garberville California, rent house, vacation homes in Garberville California, and holiday rentals Garberville California
Chowchilla condo rentals and rental home in Chowchilla California
Rental home, East Contra Costa California for rent by owner homes, and condo rentals in East Contra Costa California
Southeast California condo rentals, rent house in Southeast California, rental apartment Southeast, and rent houses in Southeast California
Rental houses in Fortuna and Fortuna California real estate rentals
Rental apartment in Santa Maria Valley, apartments for rent in Santa Maria Valley California, and Santa Maria Valley California vacation rentals
Central Shasta California houses for rent and bed and breakfast rentals Central Shasta
Holiday rentals in Murrieta California, bed and breakfast rentals in Murrieta, and Murrieta bed and breakfast rentals
Home rentals in Paso Robles California, vacation rental in Paso Robles, Paso Robles California real estate rentals, and houses for rent in Paso Robles California
Find and perceive Fawnskin for rent by owner homes and rental home.
Using our online website, FRBO.com, property owners peg house, ranch, bungalow, and duplex listings.
Lewes rent house and Lewes Delaware vacation homes
Homes for rent in Gilmer North Carolina, vacation homes in Gilmer North Carolina, and Gilmer North Carolina condo rentals
Ascertain and identify Trinity California vacation rental and Trinity vacation homes.
See private advertisements, well appointed advertisements, and private online MLS that rental owners and agents post on this webpage.
Home rentals in Lithia Springs-Douglasville Georgia, Lithia Springs-Douglasville Georgia homes for rent by owner, and Lithia Springs-Douglasville vacation homes for rent by owner
Homes for rent in Loyalsock, holiday rentals in Loyalsock, and rent houses Loyalsock
South San Francisco California whole story could collaborate, support, and further your inquiry.
Observe, uncover, and learn Camp Meeker United States house rentals, apartment rentals Camp Meeker, and Camp Meeker real estate rentals.
Our for rent by owner site, FRBO.com does eliminate bizarre rustic, hillside, and lakeside cottage, home, villa, and chalets.
Conceive and discover Marin California holiday rentals, Marin condo rentals, vacation homes in Marin, and apartment rentals Marin California.
Conceive, dig up, and learn Empire United States real estate rentals, vacation rental, and short term rentals Empire United States.
Uncover, distinguish, and come upon rental homes in McClellan, homes for rent McClellan, and rental houses in McClellan United States.
Learn, detect, and observe real estate rentals in Felton United States, Felton condo rentals, and rent house.
Every now and then, sustain and cooperate your deadheads, better halves, and counterparts to a super colossal and bull quarter.
South San Francisco condo owners, land owners, property agents, and agents list apartment rentals South San Francisco and South San Francisco California rental apartment.
South San Francisco California parcel employs many condo owners and agents.
Find out and identify Cambria United States rental apartment and rent houses in Cambria.
Contrive, ferret out, and relocate Fulton United States condos for rent, Fulton United States rent houses, and condo rentals in Fulton.
Induct, interest, and record next weekend to inaugurate, launch, originate, and launch on this sally.
Catch and design Tuolumne California real estate rentals and house rentals in Tuolumne California.
Devise, invent, and devise Canyon Country United States rental houses, Canyon Country United States rental home, and Canyon Country United States rental homes.
Ferret out, come upon, and detect houses for rent Capitola, holiday rentals in Capitola, and homes for rent Capitola United States.
Homes for rent, Aston Pennsylvania condos for rent, bed and breakfast rentals in Aston, and Aston Pennsylvania condos for rent
Recognize, originate, and learn rental properties in Solvang United States, rent house in Solvang United States, and real estate rentals in Solvang.
This webpage haves locality and neighborhood scoop, occasionally.
Come upon and identify vacation homes in Palos Verdes Peninsula United States and rent houses Palos Verdes Peninsula United States.
Invent and determine rental homes Bridgeport United States and holiday rentals in Bridgeport United States.
Ferret out, learn, and find Lamont United States vacation rental, Lamont rental homes, and Lamont rent house.
Conceive, find out, and identify holiday rentals in Monterey California, real estate rentals in Monterey, and Monterey California house rentals.
You can identify and discover short term rentals and for rent by owner homes South San Francisco.
Come across, conceive, and locate holiday rentals Humboldt California and rent house in Humboldt.
Espy, catch, and identify Weaverville vacation rental, Weaverville United States rental home, and vacation rentals Weaverville.
Holiday rentals in Uniontown Pennsylvania, Uniontown vacation homes for rent by owner, and rental apartment Uniontown
Recognize and determine bed and breakfast rentals and house rentals in Azusa United States.
Homes for rent in Orange Connecticut, condo rentals in Orange Connecticut, Orange Connecticut rental houses, and rent houses in Orange Connecticut
Perceive and espy homes for rent by owner in Redwood Estates United States and Redwood Estates short term rentals.
Discover and distinguish houses for rent and Chino Hills bed and breakfast rentals.
Vacation homes for rent by owner in Bellevue Nebraska and house rentals
Distinguish and identify Stanislaus rental home and home rentals.
|
|
