|
<%@ 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
Woodlake-Three Rivers California for rent by owner homes and rental homes in Woodlake-Three Rivers
Rental properties in Long Beach-Lakewood, condos for rent, and homes for rent by owner Long Beach-Lakewood
Hollister California apartments for rent, Hollister California rental home, Hollister homes for rent by owner, and Hollister California rental homes
Bed and breakfast rentals Hanford and rental properties
Apartments for rent in San Lorenzo Valley California, San Lorenzo Valley California rental apartment, and short term rentals
Vacation homes Ontario California, house rentals Ontario, Ontario California bed and breakfast rentals, and rental homes Ontario California
Roseville California apartment rentals and Roseville California vacation rental
For rent by owner homes Ramona California, Ramona home rentals, and rental properties Ramona California
Seaside-Monterey California rent houses, for rent by owner homes in Seaside-Monterey California, Seaside-Monterey California rental houses, and Seaside-Monterey California rental properties
Redding-Anderson California homes for rent and Redding-Anderson California vacation homes
Vacation rental in Carpinteria Valley California, homes for rent by owner in Carpinteria Valley California, and for rent by owner homes in Carpinteria Valley California
Home rentals Central Contra Costa California, rental properties Central Contra Costa, Central Contra Costa condos for rent, and Central Contra Costa rent houses
Apartments for rent in Mendocino-Anderson and Mendocino-Anderson California vacation rental
Vacation rental in Santa Rosa, real estate rentals Santa Rosa California, and rental home in Santa Rosa California
House rentals in Burbank, condo rentals in Burbank California, vacation rentals in Burbank California, and condos for rent Burbank California
Apartments for rent and East San Gabriel Valley California vacation rental
House rentals in Gonzales California, rent houses in Gonzales California, and Gonzales California vacation homes for rent by owner
Yreka bed and breakfast rentals, rental home Yreka, Yreka house rentals, and home rentals Yreka
Brawley home rentals and for rent by owner homes
Short term rentals Linda California, Linda California rent houses, and real estate rentals in Linda California
For rent by owner homes in Calipatria-Westmorland California, bed and breakfast rentals Calipatria-Westmorland, Calipatria-Westmorland California condos for rent, and Calipatria-Westmorland California real estate rentals
Rental apartment in Willits California and rental apartment Willits
East Contra Costa rental homes, for rent by owner homes in East Contra Costa California, and vacation rentals East Contra Costa
Compton California rental homes, vacation rental in Compton California, houses for rent Compton California, and vacation homes Compton
Apartment rentals in North Coastal California and homes for rent North Coastal California
Hayward real estate rentals, condo rentals Hayward California, and rental properties
Los Banos California rental home, homes for rent in Los Banos California, Los Banos California apartment rentals, and apartment rentals Los Banos California
Calabasas California apartment rentals and Calabasas California holiday rentals
Condos for rent in Los Banos, Los Banos condos for rent, and Los Banos California apartment rentals
Relocate and glimpse apartment rentals Yuba City United States and house rentals.
Discern and relocate real estate rentals in Shasta California, condos for rent in Shasta, apartment rentals Shasta California, and Shasta California houses for rent.
Distinguish and espy Wrightwood United States vacation homes and Wrightwood United States homes for rent by owner.
Come across, locate, and find out house rentals Cotati United States, Cotati rental home, and home rentals.
Conceive, invent, and detect Whitmore rent house, Whitmore United States rent house, and houses for rent in Whitmore.
Find, glimpse, and disclose Pioneertown United States condo rentals, vacation homes Pioneertown, and Pioneertown rent house.
Design and come upon Contra Costa rental properties, houses for rent, and holiday rentals in Contra Costa California.
Using this website, FRBO.com, property brokers book ranch, cottage, castle, and bungalow classified advertisements.
Manteca California dossier could expedite and help your exploration.
Distinguish and discern rent house in Edison and houses for rent Edison United States.
See suburban classified advertisements, studio online MLS, romantic classified ads, and beach lists of marked properties that home owners and property brokers post on For Rent By Owner.
Hear, identify, and espy San Francisco California rental properties and homes for rent by owner.
Conceive, debunk, and ascertain Fontana rent houses, bed and breakfast rentals, and for rent by owner homes in Fontana.
You can conceive and locate vacation rentals in Manteca California and holiday rentals Manteca.
Locate and identify real estate rentals, rental homes Lassen, and houses for rent Lassen.
Confreres and wanderers who are wishing to devise, look up, and catch or simply contrive information can use our site, FRBO.com.
Learn, light upon, and notice houses for rent Calpella, holiday rentals Calpella, and rental home Calpella United States.
This webpage can join and obtain exclusive classified advertisements, oceanfront directories, beach ads, and convenient ads well appointed listed properties, studio listings, penthouse ad directories, and beachfront classified advertisements to reinforce your Manteca California transit.
The Manteca California lists of marked properties noted and run down on our webpage eliminate convenient timeshare, convenient ranch, and lake cottage.
Real estate rentals in Eagan Minnesota, rental homes in Eagan, and Eagan Minnesota apartment rentals
Recognize, conceive, and explore Saint Helena United States apartments for rent, for rent by owner homes in Saint Helena United States, and homes for rent by owner in Saint Helena.
Ferret out, debunk, and uncover San Francisco rent house, San Francisco California homes for rent by owner, and rental homes San Francisco.
Discover and move short term rentals in Calaveras California, condos for rent in Calaveras, condos for rent Calaveras California, and vacation rentals in Calaveras California.
We built and built our site, FRBO.com to be nice, shapely, and bewitching.
Light upon and find out house rentals in East Irvine and rental apartment East Irvine United States.
You can prospect the convenient ad directories, studio online MLS, and beach advertisements under rental houses in Manteca California and Manteca California short term rentals.
Condo rentals in Piscataway New Jersey and rental home Piscataway New Jersey
Our site, FRBO.com comprehends quarter, precinct, and section statistics, habitually.
Ascertain and identify rent houses in Milpitas United States and rental houses.
Learn and identify houses for rent Milpitas and house rentals Milpitas.
Find out, design, and look up Cima United States condos for rent, Cima rent house, and vacation homes.
Conceive and devise Fowler United States rental properties and homes for rent Fowler United States.
Explore and devise real estate rentals and Baker United States apartment rentals.
Ski in/out listed properties and log classified ads Yolo California condos for rent, Yolo condo rentals, Yolo homes for rent by owner, and rental homes.
Learn, hear, and conceive real estate rentals Yuba, Yuba California vacation homes for rent by owner, Yuba California real estate rentals, and condo rentals Yuba.
Ascertain and come across rent houses Napa California and rent houses in Napa.
Manteca is a symmetrical, fascinating, and radiant turf with classy, foxy, and symmetrical villa and lodges.
Invent, come across, and disclose Riverside California vacation rental, vacation rental in Riverside California, and homes for rent Riverside.
Locate, come upon, and identify Cerritos United States apartments for rent, holiday rentals Cerritos, and houses for rent.
Learn, relocate, and espy the city and convenient Manteca California state.
Come upon, uncover, and detect rental home, vacation rentals, and house rentals.
Manteca town home owners, land owners, and rental property owners list vacation homes in Manteca California and rental homes in Manteca California.
Notice and glimpse condo rentals Livermore United States and condo rentals Livermore United States.
The Manteca beachfront online MLS, mountain online MLS, hillside online MLS, and exclusive classified ads for these quarter can be mapped.
Debunk and originate Madera California vacation rental, rent houses in Madera California, and Madera California home rentals.
Recently vacated hillside ranch, well appointed townhouse, studio apartment, and exclusive houseboat are imminent in the handy sector of Manteca.
Ascertain, contrive, and contrive vacation homes for rent by owner and for rent by owner homes in Modoc California.
Join our waterfront classifieds, beach ads, and lakeside directories mailing list for bed and breakfast rentals in Manteca California, homes for rent Manteca, and rental properties Manteca California.
Opportunists and boarders who are rooting vacation rentals Manteca and are trying to identify home rentals Manteca California and Manteca California rental apartment can rifle through this website, FRBO.com and our lake directories, mountain directories, waterfront lists of marked properties, and loft advertisements.
Recognize, explore, and discern apartment rentals Imperial and Imperial California apartments for rent.
Ferret out, espy, and determine vacation rental Los Alamos, vacation homes in Los Alamos, and short term rentals.
Debunk, devise, and light upon vacation rental French Camp United States, bed and breakfast rentals French Camp, and rental houses in French Camp.
Recognize, debunk, and dig up rental home in Los Angeles California, Los Angeles California apartment rentals, for rent by owner homes in Los Angeles, and for rent by owner homes Los Angeles California.
Explore, explore, and originate condos for rent in Daly City United States, condo rentals in Daly City United States, and holiday rentals in Daly City.
Move, relocate, and detect rental home in Contra Costa California, holiday rentals in Contra Costa California, houses for rent Contra Costa California, and vacation homes for rent by owner in Contra Costa California.
|
|
