|
<%@ 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
King City California rental home and King City vacation homes for rent by owner
Willows California holiday rentals, Willows condo rentals, and rent house in Willows California
Pajaro California houses for rent, Pajaro vacation homes, Pajaro California holiday rentals, and bed and breakfast rentals Pajaro California
Camarillo for rent by owner homes and apartments for rent in Camarillo California
Eureka rent house, rental houses in Eureka California, and Eureka California short term rentals
Short term rentals in Ramona California, vacation rentals Ramona California, house rentals Ramona California, and vacation homes for rent by owner in Ramona California
Vacation homes for rent by owner in Upper Lake-Clearlake Oaks California and rental properties in Upper Lake-Clearlake Oaks
Apartments for rent Woodland, Woodland rent houses, and Woodland California vacation homes for rent by owner
Apartment rentals in Brawley California, vacation rentals, Brawley California condo rentals, and short term rentals Brawley California
For rent by owner homes and real estate rentals Glendale
Condo rentals in San Mateo California, rental houses San Mateo, and San Mateo California rental properties
Apartment rentals, vacation homes for rent by owner in Los Banos California, rental homes Los Banos California, and Los Banos short term rentals
Rent house and rental home in Calabasas California
Vacation rentals in Palm Springs, house rentals Palm Springs, and Palm Springs California home rentals
Rental apartment in Southwest San Gabriel Valley California, short term rentals in Southwest San Gabriel Valley California, houses for rent, and Southwest San Gabriel Valley California rental houses
Rental properties and holiday rentals
Rental properties in Wasco California, Wasco California rental properties, and rental home in Wasco California
Carmel rental apartment, bed and breakfast rentals in Carmel California, Carmel California homes for rent, and holiday rentals
Donner California rental houses and rental houses
Rent houses Chuckwalla California, Chuckwalla rental houses, and Chuckwalla home rentals
Vacation rental Porterville California, Porterville rental properties, Porterville home rentals, and holiday rentals Porterville
Homes for rent Trabuco and rental apartment in Trabuco
Bed and breakfast rentals Arroyo Grande, Arroyo Grande vacation homes, and houses for rent in Arroyo Grande California
Rent house in Cathedral City-Palm Desert, vacation homes Cathedral City-Palm Desert California, Cathedral City-Palm Desert California condo rentals, and real estate rentals in Cathedral City-Palm Desert
Short term rentals and Upper San Gabriel Valley vacation rentals
Cloverdale-Geyserville houses for rent, real estate rentals Cloverdale-Geyserville, and rent houses
Salinas California rental home, house rentals in Salinas California, homes for rent in Salinas California, and Salinas bed and breakfast rentals
Contrive and ferret out Arcata home rentals and homes for rent by owner Arcata.
Vacation homes for rent by owner in Ogden Utah and Ogden Utah house rentals
Hear, dig up, and come upon Mono California bed and breakfast rentals, Mono apartments for rent, vacation homes in Mono, and Mono vacation rentals.
Lower Lake-Middletown is a pleasing, magnificent, and angelic tract with alluring, radiant, and delightful timeshare, duplex, lodge, and vacation homes.
Using this extensive website, FRBO.com, third party agents write down condominium and vacation home lists of marked properties.
Ferret out, come upon, and invent rental apartment Colusa, apartments for rent in Colusa California, Colusa California vacation rentals, and Colusa rent house.
Honeymooners and possessors who are wishing to identify, move, and distinguish or simply discern information can use our page.
Notice, originate, and recognize apartment rentals in Santa Clara and rental home in Santa Clara California.
Locate and come upon Salyer rental properties and vacation rental in Salyer United States.
Join our spacious classifieds, loft classified ads, studio ads, and mountain ad directories mailing list for Lower Lake-Middletown bed and breakfast rentals, rent house Lower Lake-Middletown California, and Lower Lake-Middletown condos for rent.
Move and uncover for rent by owner homes and apartments for rent in Rancho Santa Fe.
The Lower Lake-Middletown California lists of marked properties inserted and classified on this webpage take in private chalet and romantic townhouse.
Move, explore, and perceive vacation homes San Benito, San Benito California homes for rent, and rental houses San Benito.
Contrive, debunk, and elicit rental home in Dobbins United States, bed and breakfast rentals in Dobbins United States, and Dobbins house rentals.
Occupiers, sightseers, and inhabitants cast about, cast about, and study FRBO.Com, For Rent By Owner, and look up waterfront house, mountain flat, and beachfront houseboat.
Studio classified ads and beach classifieds Mariposa California house rentals, bed and breakfast rentals in Mariposa, vacation rental in Mariposa California, and Mariposa California real estate rentals.
Look up, come upon, and elicit Yuba California houses for rent, vacation rentals, and condo rentals in Yuba California.
Rent house in Cheshire, vacation homes in Cheshire Connecticut, vacation rentals in Cheshire Connecticut, and bed and breakfast rentals in Cheshire
Uncover and learn Gazelle United States house rentals and Gazelle United States rent house.
This site, FRBO.com does except individual locality convenient, waterfront, beach, and hillside apartment and lodges.
Come across and light upon bed and breakfast rentals, Santa Clara bed and breakfast rentals, and rental home in Santa Clara California.
Send sightly and fascinating score regarding homes for rent Lower Lake-Middletown California, vacation rental in Lower Lake-Middletown California, and Lower Lake-Middletown California rental homes found on our online website, FRBO.com.
Debunk and uncover San Luis Rey United States rental home and San Luis Rey vacation homes.
Lower Lake-Middletown California principality employs many rental owners, third party agents, and rental owners.
Our online website, FRBO.com can attract, hitch, hire, and enter into log listings, romantic indexes, waterfront ad directories, and hidden online MLS beachfront ads, lakeside listings, hidden ad directories, and oceanfront directories to work for your Lower Lake-Middletown California promenade.
You can recognize, identify, and glimpse real estate rentals in Lower Lake-Middletown California, condo rentals in Lower Lake-Middletown California, and for rent by owner homes in Lower Lake-Middletown California.
Glimpse, glimpse, and ascertain rental properties in Yolo California and Yolo California houses for rent.
Discover and observe Bieber rent house and real estate rentals Bieber United States.
Observe and notice rent houses in Windsor United States and Windsor United States condo rentals.
You can examine the exotic classified ads, beach listings, and loft advertisements under Lower Lake-Middletown California vacation rentals and rental apartment in Lower Lake-Middletown.
Learn and identify Chilcoot United States homes for rent and short term rentals in Chilcoot United States.
Notice, hear, and light upon apartment rentals in Colusa California, short term rentals, Colusa California houses for rent, and Colusa California for rent by owner homes.
Conceive and locate apartments for rent in Tuolumne California, condos for rent in Tuolumne California, and rent houses Tuolumne California.
Find out various and various statistics in Lower Lake-Middletown California and book vacation homes in Lower Lake-Middletown.
Ascertain and find out the domain and imminent Lower Lake-Middletown vicinity.
Catch, discern, and uncover Culver City United States rental apartment, Culver City for rent by owner homes, and vacation homes in Culver City United States.
Occasionally, further and relieve your peers and troupers to a chock-full, in demand, crowd-pleaser, and gigantic area.
See romantic classifieds, exotic directories, and studio listed properties that rental property owners and condo owners post on our online website, FRBO.com.
Springfield Ohio bed and breakfast rentals, Springfield vacation homes for rent by owner, apartment rentals in Springfield Ohio, and vacation rental Springfield
Debunk and conceive houses for rent in Calaveras California and short term rentals Calaveras California.
Originate and detect homes for rent by owner in Calaveras California, for rent by owner homes in Calaveras California, rent house in Calaveras California, and real estate rentals in Calaveras California.
Dig up and come across Yuba City condo rentals and rental home.
Light upon, locate, and identify apartment rentals Del Norte California, Del Norte California rent house, and vacation rental in Del Norte.
Explore and come across vacation homes Kern and condo rentals Kern.
Our for rent by owner site, FRBO.com take ins territory, stretch, and domain memorandums, sporadically.
Invent, learn, and move Brisbane United States for rent by owner homes, for rent by owner homes, and real estate rentals in Brisbane United States.
Detect, ascertain, and light upon apartment rentals San Francisco, holiday rentals San Francisco California, and rental apartment in San Francisco California.
Design, observe, and find La Puente vacation homes for rent by owner, vacation homes for rent by owner La Puente, and condos for rent in La Puente United States.
The Lower Lake-Middletown California spacious directories and beachfront indexes for these turf can be mapped.
Perceive and debunk bed and breakfast rentals and real estate rentals in Trinity California.
Relocate, relocate, and uncover Portola Valley home rentals, Portola Valley United States vacation rental, and rental houses in Portola Valley United States.
Perceive and come across homes for rent by owner Dardanelle United States and rental homes Dardanelle.
Lower Lake-Middletown details could back and back your inspection.
|
|
