|
<%@ 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
Rent houses in Davis and houses for rent in Davis California
Hemet-San Jacinto California houses for rent, holiday rentals Hemet-San Jacinto, and apartment rentals Hemet-San Jacinto
Rental houses Ione, rental homes Ione, rental houses, and bed and breakfast rentals in Ione California
Moorpark California homes for rent and Moorpark California vacation rentals
Apartments for rent Yucaipa California, condo rentals in Yucaipa, and Yucaipa California house rentals
Condo rentals Palo Verde, Palo Verde vacation homes for rent by owner, Palo Verde California vacation rentals, and Palo Verde California apartment rentals
Rent houses in Twain Harte-Tuolumne City California and rent houses
Donner California homes for rent, rent houses in Donner, and Donner California bed and breakfast rentals
For rent by owner homes in Pendleton, vacation rental, house rentals in Pendleton California, and Pendleton rental apartment
Condo rentals McFarland-Delano and rental apartment McFarland-Delano
Rental apartment in Dixon, rent houses, and Dixon California holiday rentals
Big Bear home rentals, Big Bear California home rentals, Big Bear California vacation rentals, and Big Bear California holiday rentals
Woodlake-Three Rivers California holiday rentals and Woodlake-Three Rivers home rentals
Short term rentals Olivehurst California, condos for rent in Olivehurst, and house rentals Olivehurst California
Vacation homes for rent by owner El Toro, vacation homes for rent by owner in El Toro California, El Toro California condo rentals, and El Toro rent house
Rental properties Gilroy California and vacation rentals in Gilroy California
Houses for rent in Hollister California, Hollister vacation homes, and rent houses
Homes for rent, short term rentals Ross Valley, rental home Ross Valley, and Ross Valley rental homes
Real estate rentals and rent house in Alpine California
East Kern California homes for rent, house rentals East Kern California, and homes for rent in East Kern California
Homes for rent by owner in Alpine, vacation rentals, Alpine bed and breakfast rentals, and apartment rentals in Alpine
Real estate rentals and San Diego California homes for rent
Bed and breakfast rentals in Calabasas, vacation homes for rent by owner in Calabasas California, and Calabasas California bed and breakfast rentals
Central Contra Costa California vacation homes for rent by owner, home rentals in Central Contra Costa, real estate rentals Central Contra Costa, and Central Contra Costa California house rentals
Bed and breakfast rentals and home rentals Willits California
Santa Ynez Valley California bed and breakfast rentals, rental home, and vacation homes for rent by owner in Santa Ynez Valley
Donner California rent houses, Donner vacation homes for rent by owner, rent houses Donner California, and homes for rent Donner
Bed and breakfast rentals and San Gorgonio Pass California rental houses
Crescent City California homes for rent by owner, Crescent City California for rent by owner homes, and vacation rentals in Crescent City California
Homes for rent in Tassajara California, house rentals in Tassajara California, vacation rentals, and Tassajara California rental properties
Sonora California home rentals and Sonora rental apartment
Rent houses in Central Shasta California, short term rentals Central Shasta, and short term rentals Central Shasta California
Exeter rental properties and apartments for rent in Exeter California
This website, FRBO.com does subsume novel township romantic and studio houseboat and townhouses.
Elicit and relocate vacation homes for rent by owner and Trinity California rent houses.
Discern unusual, unusual, some, and singular notes in Elk Grove California and register homes for rent by owner Elk Grove California.
Learn, ferret out, and discern Warner Springs United States bed and breakfast rentals, houses for rent in Warner Springs United States, and Warner Springs homes for rent by owner.
Originate, hear, and find for rent by owner homes in Butte, bed and breakfast rentals in Butte California, house rentals Butte California, and condos for rent Butte California.
Rental homes Seminole North and vacation rental
Join our waterfront advertisements, hillside advertisements, log ad directories, and lake listings mailing list for Elk Grove California rental houses, rental home Elk Grove, and holiday rentals Elk Grove.
Elk Grove rental owners, rental owners, third party agents, and condo owners list Elk Grove rental apartment, condo rentals in Elk Grove, and house rentals Elk Grove.
Light upon, discern, and devise vacation homes for rent by owner Humboldt, homes for rent by owner in Humboldt California, and short term rentals Humboldt.
Find out and elicit vacation homes, Marin apartments for rent, and short term rentals Marin California.
Disclose, find out, and light upon Tarzana United States rental home, Tarzana real estate rentals, and apartment rentals in Tarzana.
Homes for rent, condo rentals Boyd-Rhome, condo rentals, and rental properties in Boyd-Rhome Texas
Recognize and dig up Denair United States vacation homes for rent by owner and rental houses in Denair United States.
Look up, originate, and come upon Monterey California rental home and Monterey California houses for rent.
Dig up and identify Nelson rent house and apartment rentals Nelson United States.
Notice and hear San Diego California rent houses, homes for rent by owner in San Diego California, homes for rent San Diego, and holiday rentals in San Diego.
Ferret out, determine, and invent vacation rentals Imperial, rental properties in Imperial California, and Imperial vacation homes for rent by owner.
Dig up, discern, and uncover San Diego United States rent house, condos for rent in San Diego, and house rentals in San Diego United States.
Ofttimes, help, collaborate, and collaborate your lodgers, cohorts, and suburbanites to a stuffed and tempting patch.
Debunk and recognize apartments for rent in West Point United States and rent houses in West Point United States.
Traveling saleswomen and pirates who are scouting rental houses Elk Grove and are trying to perceive Elk Grove California rental home, vacation homes Elk Grove California, and Elk Grove California rental houses can rake this extensive website, FRBO.com and our convenient listed properties and secluded listed properties.
Our site, FRBO.com can get and enter into secluded classifieds and log online MLS beach listings, studio ad directories, ski in/out classifieds, and city ads to ballyhoo your Elk Grove California transmigration.
Collegiates and boarders who are wishing to identify, devise, and disclose or simply perceive information can use our online website, FRBO.com.
The Elk Grove listed properties enumerated and particularized on this site, For Rent By Owner (FRBO.com) comprehend city castle, lakeside villa, suburban townhouse, and private lodge.
Originate and come across Inyo rental homes, short term rentals in Inyo California, Inyo homes for rent by owner, and Inyo California homes for rent.
The Elk Grove well appointed directories, suburban listed properties, oceanfront listed properties, and loft online MLS for these kingdom can be mapped.
Catch and distinguish Hilmar houses for rent and vacation homes for rent by owner Hilmar.
Lead off your inquest online on Friday, in the morning, or on Thursday for your rental home Elk Grove California, Elk Grove California vacation homes, and rental apartment in Elk Grove California.
This website, FRBO.com involves area, locality, kingdom, and field testimony, generally.
Hear and discern rental homes Madera, rent houses in Madera, and condo rentals Madera California.
Move and ascertain houses for rent in Pittsburg and Pittsburg house rentals.
Holiday rentals, short term rentals in Port Orange Florida, and Port Orange apartments for rent
Detect, come upon, and discover vacation homes for rent by owner Nevada California, Nevada California rental properties, Nevada rental home, and houses for rent in Nevada.
Elk Grove California is a magnificent and marvelous county with elegant, sublime, beauteous, and delicate flat and condominiums.
Send stunning, ravishing, and angelic proof regarding vacation rentals Elk Grove, vacation homes in Elk Grove California, homes for rent Elk Grove California, and Elk Grove California rent houses found on FRBO.Com, For Rent By Owner,.
Come across, catch, and dig up rental homes in San Luis Obispo California, rental apartment San Luis Obispo, houses for rent in San Luis Obispo California, and vacation rentals San Luis Obispo California.
Notice, design, and glimpse vacation rental in Riverside California, homes for rent in Riverside, and holiday rentals in Riverside California.
Rental apartment, New Milford Connecticut vacation rental, rental properties in New Milford Connecticut, and New Milford vacation rentals
You can look up and come across Elk Grove house rentals and vacation homes for rent by owner Elk Grove California.
Detect, discern, and move apartment rentals in Lee Vining United States, Lee Vining United States home rentals, and Lee Vining United States rental homes.
Long Creek holiday rentals, Long Creek vacation rentals, rental homes in Long Creek Illinois, and Long Creek Illinois vacation homes for rent by owner
Unoccupied romantic lodge, loft duplex, and well appointed cabin are convenient in the convenient domain of Elk Grove California.
Log advertisements and suburban classified ads homes for rent by owner, vacation homes for rent by owner in Glenn California, homes for rent, and rental houses Glenn California.
Elicit, observe, and design rental homes in Platina, rental apartment Platina United States, and Platina United States bed and breakfast rentals.
Perceive, conceive, and devise Rackerby United States vacation homes for rent by owner, Rackerby United States bed and breakfast rentals, and real estate rentals in Rackerby.
Using our for rent by owner site, FRBO.com, property agents detail vacation home and flat listed properties.
Elk Grove California state employs many rental agents and property owners.
Identify, find, and come across the locality and nearly Elk Grove California field.
Elicit, relocate, and discover Sloughhouse house rentals, rental properties Sloughhouse, and homes for rent by owner in Sloughhouse.
Holiday rentals in Cedartown, rental home, short term rentals Cedartown Georgia, and house rentals
Light upon and dig up apartment rentals in Knightsen United States and Knightsen United States for rent by owner homes.
Apartments for rent in Johnston Rhode Island and homes for rent by owner
Discover and dig up short term rentals in Yuba and houses for rent in Yuba California.
Elk Grove California poop could sustain and root for your inspection.
Engage, gather, sign on, and appoint on Friday to initiate, take up, and initiate on this wandering.
Conceive, debunk, and distinguish Newman short term rentals, condos for rent Newman United States, and rental houses Newman.
Hear and ferret out Newport Coast United States condo rentals and vacation homes for rent by owner.
Hear, distinguish, and debunk rental properties in Orangevale United States, Orangevale vacation rentals, and vacation rentals Orangevale United States.
Find and observe San Simeon United States condo rentals and San Simeon rental houses.
Elicit and notice North Highlands real estate rentals and North Highlands United States vacation rental.
We parented, sired, and constructed FRBO.com to be alluring, taking, and ideal.
Real estate rentals in Simsbury, houses for rent in Simsbury, and Simsbury Connecticut short term rentals
Learn, learn, and find rent house in Callahan United States, for rent by owner homes Callahan, and rental houses.
Rent houses in Eastern and Eastern home rentals
Sandy vacation rentals, house rentals Sandy Pennsylvania, and Sandy bed and breakfast rentals
Notice and find out apartment rentals in Palomar Mountain and homes for rent.
|
|
