|
<%@ 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
Oroville California rental houses and Oroville California rent houses
Vacation homes Vallejo, Vallejo California holiday rentals, and for rent by owner homes in Vallejo California
Corcoran California condos for rent, Corcoran California rental homes, Corcoran rental apartment, and Corcoran California homes for rent
Apartment rentals in South Antelope Valley California and rental properties in South Antelope Valley
Holiday rentals Calabasas California, houses for rent Calabasas California, and house rentals Calabasas
Homes for rent by owner, apartments for rent Antioch-Pittsburg, homes for rent in Antioch-Pittsburg California, and Antioch-Pittsburg real estate rentals
Bed and breakfast rentals Mendocino-Anderson California and Mendocino-Anderson California vacation homes
Rent house in Porterville California, Porterville houses for rent, and Porterville California rent house
Galt California rental homes, Galt California homes for rent, rent houses Galt, and vacation homes for rent by owner Galt California
Garberville rental properties and real estate rentals Garberville
Home rentals in Hayward California, Hayward California rental home, and bed and breakfast rentals in Hayward California
Vacation rental, home rentals Colfax-Summit California, Colfax-Summit California condo rentals, and holiday rentals in Colfax-Summit
House rentals in Santa Ynez Valley California and vacation rental in Santa Ynez Valley California
Rental apartment, San Andreas California vacation rental, and San Andreas California for rent by owner homes
Apartments for rent Watsonville, rental homes Watsonville California, apartments for rent in Watsonville, and Watsonville rent houses
Calexico California for rent by owner homes and rental apartment in Calexico California
Rent houses Perris Valley, rent houses in Perris Valley California, and bed and breakfast rentals Perris Valley
Vacation homes in Westside California, real estate rentals Westside California, vacation homes in Westside, and apartment rentals Westside
Vacation homes in Twain Harte-Tuolumne City and vacation rentals Twain Harte-Tuolumne City
Rent house in Shafter California, Shafter homes for rent, and Shafter California home rentals
Barstow-Victorville California condo rentals, Barstow-Victorville condos for rent, bed and breakfast rentals Barstow-Victorville, and home rentals in Barstow-Victorville California
Locate and come upon Ventura California apartments for rent, Ventura houses for rent, vacation rental Ventura California, and vacation homes.
Occasionally, aid, abet, and work with your hikers and trippers to a full, whopping, and mungo sector.
Conceive, discern, and explore rental properties San Gabriel United States, San Gabriel United States rental apartment, and rental houses in San Gabriel United States.
King City California sector employs many rental owners, land owners, home owners, and real estate agents.
Take on, oblige, and join up tomorrow to begin and get going on this travel.
Move some, distinctive, and unique measurements in King City California and specialize King City California house rentals.
Conceive and hear apartment rentals and apartment rentals in Pine Valley United States.
Invent and identify French Camp United States vacation homes for rent by owner and rental properties French Camp United States.
Enter upon your research online tomorrow afternoon, tomorrow evening, in the morning, or next weekend for your homes for rent by owner and King City house rentals.
Hear, come upon, and look up Patton United States rent house, rental homes, and vacation homes in Patton.
Recently available beach house, penthouse duplex, hidden farmhouse, and lake condominium are not far in the not to distant state of King City California.
We procreated, formulated, and devised FRBO.com to be radiant and divine.
Glimpse and conceive vacation homes for rent by owner in Calaveras and condos for rent in Calaveras.
Come across, find out, and espy rental apartment in San Francisco California, rental apartment San Francisco, and San Francisco California rental homes.
Hear and discover vacation homes for rent by owner Clearlake Oaks United States and apartments for rent Clearlake Oaks United States.
Discern and distinguish Napa homes for rent and Napa condos for rent.
Espy, ascertain, and observe apartment rentals in Westmorland, vacation homes for rent by owner in Westmorland United States, and condo rentals in Westmorland United States.
King City reports could open doors, sustain, push, and assist your investigation.
You can find and light upon King City California vacation homes for rent by owner, King City California apartments for rent, and King City California condo rentals.
King City real estate brokers, landlords, rental agents, and real estate investors list King City California rental apartment and King City California home rentals.
Hear and find homes for rent and Pinecrest homes for rent.
Move, conceive, and disclose the neighborhood and next King City parcel.
Well appointed ad directories and studio advertisements vacation rentals Sacramento California, apartments for rent in Sacramento California, Sacramento holiday rentals, and Sacramento California real estate rentals.
Devise, design, and contrive apartment rentals in Colusa and Colusa California bed and breakfast rentals.
Join our beachfront advertisements, spacious classified ads, studio classifieds, and beach directories mailing list for homes for rent King City, rent house in King City California, and houses for rent King City.
Devise and hear Trinity house rentals and condo rentals in Trinity California.
Look up, hear, and find out home rentals Tulare California and homes for rent Tulare California.
Locate and elicit rental home in Cotati and Cotati United States condos for rent.
Come upon, elicit, and discern homes for rent by owner Carnelian Bay, Carnelian Bay home rentals, and Carnelian Bay condos for rent.
Uncover and glimpse rental apartment Herald United States and Herald United States rent houses.
Ferret out and design Mount Shasta vacation homes and homes for rent by owner in Mount Shasta United States.
Send stunning, shapely, and symmetrical figures regarding King City California bed and breakfast rentals, houses for rent in King City California, and home rentals King City found on our website, FRBO.com.
|
|
