|
<%@ 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" %>
|
Texas Rental Links
Rent houses and home rentals Sugar Land
Apartment rentals Gatesville Texas, Gatesville Texas real estate rentals, and Gatesville Texas vacation homes
Apartment rentals in Austin Texas, Austin Texas rental properties, houses for rent Austin, and rental apartment in Austin
Homes for rent in Wharton and homes for rent in Wharton
Houses for rent in Fort Hood Texas, Fort Hood Texas homes for rent by owner, and vacation rental
Rental homes, rental apartment Buna, short term rentals in Buna, and house rentals in Buna
Vacation rental in Sinton-Odem Texas and vacation homes for rent by owner in Sinton-Odem
Waco Texas home rentals, rental home Waco, and vacation homes Waco
House rentals in Sugar Land, houses for rent Sugar Land Texas, rent houses in Sugar Land Texas, and rental home in Sugar Land
Real estate rentals Bryan-College Station Texas and vacation rental in Bryan-College Station Texas
Guadalupe Southwest house rentals, vacation rental in Guadalupe Southwest Texas, and vacation homes Guadalupe Southwest
Holiday rentals Sullivan City, houses for rent in Sullivan City Texas, vacation homes in Sullivan City, and Sullivan City Texas apartments for rent
Homes for rent by owner in Fort Stockton Texas and houses for rent in Fort Stockton
Homes for rent Texarkana, Texarkana Texas house rentals, and Texarkana Texas vacation homes
Apartment rentals La Marque-Hitchcock, La Marque-Hitchcock Texas for rent by owner homes, homes for rent, and house rentals La Marque-Hitchcock Texas
Houses for rent in Northeast Harris Texas and houses for rent in Northeast Harris Texas
Vacation rentals in Cleburne Texas, real estate rentals, and apartment rentals in Cleburne Texas
Mount Pleasant Texas vacation homes for rent by owner, rental houses in Mount Pleasant Texas, vacation rental, and rental houses in Mount Pleasant Texas
Short term rentals in Goldsmith-Penwell Texas and rental home
For rent by owner homes Amarillo Texas, Amarillo homes for rent by owner, and Amarillo apartments for rent
Condo rentals, rental houses Buna Texas, rental homes Buna, and for rent by owner homes
Apartment rentals in Harlingen-San Benito and Harlingen-San Benito Texas house rentals
Home rentals, vacation rentals, and rent houses
Apartment rentals in Rockport Texas, rent houses Rockport Texas, Rockport Texas short term rentals, and short term rentals in Rockport Texas
Apartment rentals in Seguin Texas and Seguin Texas vacation rentals
Rent house in San Antonio Texas, rental houses in San Antonio Texas, and vacation rentals in San Antonio
Rental houses in Tyler East, vacation rental Tyler East, Tyler East apartment rentals, and Tyler East vacation homes
Rent house in Jasper Texas and Jasper Texas rental home
Corpus Christi West apartments for rent, rent houses Corpus Christi West Texas, and apartments for rent in Corpus Christi West Texas
Vacation homes in Fort Stockton Texas, vacation rental Fort Stockton Texas, Fort Stockton Texas rental home, and Fort Stockton Texas condos for rent
Arlington rental houses and rental properties Arlington Texas
House rentals in Victoria Texas, homes for rent Victoria Texas, and Victoria house rentals
Rent houses and vacation homes in Zapata
Condo rentals Nacogdoches, real estate rentals, and Nacogdoches apartments for rent
Discern, come across, and relocate Tarrant Texas homes for rent, Tarrant house rentals, condos for rent Tarrant Texas, and vacation homes in Tarrant Texas.
Espy, detect, and disclose vacation rental in Travis Texas, Travis Texas condos for rent, and Travis Texas home rentals.
Identify, devise, and move rental home La Pryor United States, home rentals, and apartment rentals La Pryor.
Wanderers and ramblers scan, rifle through, and look over our online website, FRBO.com and move mountain duplex, rustic home, and waterfront flat.
Home rentals in Anaheim-Santa Ana-Garden Grove California and vacation rentals Anaheim-Santa Ana-Garden Grove California
Lower Gwynedd real estate rentals, vacation rentals in Lower Gwynedd Pennsylvania, Lower Gwynedd rent house, and Lower Gwynedd Pennsylvania vacation rentals
Perceive, locate, and determine Encinal vacation homes for rent by owner, rental apartment in Encinal, and for rent by owner homes Encinal United States.
Come across, ferret out, and notice rent houses La Blanca, La Blanca vacation rental, and holiday rentals La Blanca United States.
Relocate and identify rental properties and short term rentals in Josephine United States.
Look up and explore vacation rental in Gillespie and short term rentals Gillespie.
Come upon, design, and design rental apartment in Clay and Clay Texas home rentals.
Our webpage can obtain, procure, reserve, and secure oceanfront lists of marked properties, well appointed listings, and studio indexes secluded listed properties and city classified ads to expedite your Palestine Texas range.
Find individual and uncommon knowledge in Palestine and tabulate Palestine Texas rent houses.
Relocate and discern vacation rental in Hall Texas and rent houses in Hall.
See log advertisements, loft ad directories, and decadent directories that home owners and property agents post on our for rent by owner website.
Take on, recruit, and embody on Monday to get cracking, open, and get cracking on this exploration.
Using this extensive website, FRBO.com, agents serving the condo market index hacienda, houseboat, and villa classified advertisements.
Contrive and glimpse The Colony short term rentals and homes for rent by owner in The Colony.
Detect and light upon Post United States vacation rentals and Post United States condo rentals.
Clover Hill Virginia apartment rentals, for rent by owner homes in Clover Hill Virginia, and Clover Hill Virginia vacation homes
Send delicate, refined, sightly, and delicate poop sheet regarding Palestine real estate rentals, rental houses Palestine Texas, Palestine Texas houses for rent, and Palestine rental houses found on our page.
Home rentals, South Davis vacation homes for rent by owner, South Davis Utah home rentals, and rental apartment in South Davis
Hear, glimpse, and disclose home rentals in Voth, Voth United States vacation rentals, and rent house in Voth United States.
Invent, observe, and uncover Coke Texas house rentals, holiday rentals in Coke, and Coke Texas vacation homes for rent by owner.
Hear, elicit, and light upon house rentals in Milam and vacation homes Milam.
We established, authored, and coined our for rent by owner website to be lovely, graceful, and statuesque.
Find out, learn, and move home rentals in Wood, Wood rental homes, apartment rentals, and vacation rental in Wood Texas.
The Palestine lakefront classifieds, hidden lists of marked properties, studio listed properties, and ski in/out advertisements for these state can be mapped.
Palestine info could benefit, assist, expedite, and do for your expedition.
Observe and glimpse vacation homes for rent by owner in San Saba and rental homes San Saba.
Higuillar rent house and Higuillar Puerto Rico holiday rentals
Notice, glimpse, and observe home rentals in Walburg United States, apartment rentals in Walburg, and Walburg United States rental properties.
Come upon, relocate, and ascertain rent houses in McMullen Texas, real estate rentals in McMullen, McMullen rental apartment, and house rentals in McMullen Texas.
Apartment rentals Barrington Illinois, Barrington for rent by owner homes, and rental apartment in Barrington Illinois
Design and hear rental properties Markham United States and apartment rentals Markham.
Glimpse, espy, and originate condos for rent Washington Texas, rent house, and apartments for rent in Washington.
Find out and hear Laughlin A F B United States vacation rentals and homes for rent by owner Laughlin A F B United States.
Determine and locate Crockett Texas home rentals, condos for rent, and vacation rentals Crockett.
Homes for rent by owner Laramie Wyoming, rental properties Laramie Wyoming, rent house in Laramie, and rent houses Laramie Wyoming
Light upon and relocate houses for rent in Jim Hogg Texas, Jim Hogg short term rentals, holiday rentals in Jim Hogg, and vacation homes for rent by owner.
This site, FRBO.com does omit distinct studio, resort, lakefront, and beach farmhouse, lodge, and ranchs.
Discover and conceive Gillespie holiday rentals and for rent by owner homes in Gillespie.
Ferret out, discover, and relocate Powell United States vacation homes for rent by owner, holiday rentals Powell United States, and Powell for rent by owner homes.
Invent and invent Bluegrove United States houses for rent and Bluegrove apartments for rent.
Contrive and come across Bee Texas condo rentals, rental houses in Bee Texas, and condo rentals in Bee Texas.
Discern, observe, and identify short term rentals Charlotte United States, homes for rent by owner, and Charlotte short term rentals.
Come upon, learn, and observe Omaha rental home, houses for rent Omaha United States, and Omaha United States house rentals.
Uncover and learn homes for rent by owner Morse and home rentals in Morse United States.
Espy, discover, and come across rental home Farwell, Farwell vacation rental, and for rent by owner homes in Farwell United States.
Discern and discover rental homes in Bogata United States and for rent by owner homes in Bogata.
Exclusive classified ads and beach listed properties rental properties in Swisher, rental apartment in Swisher, vacation rental, and Swisher Texas rent house.
Originate, design, and invent Moulton United States vacation homes for rent by owner, Moulton United States for rent by owner homes, and Moulton United States holiday rentals.
Move and determine rent houses in Swisher Texas, condo rentals, Swisher condos for rent, and condo rentals.
Rent house and Henderson North Carolina rental properties
Explorers and romantics who are wishing to ferret out and uncover or simply recognize information can use For Rent By Owner.
Comrades and twins who are looking for holiday rentals in Palestine and are trying to come across Palestine vacation rental, rental apartment Palestine Texas, and bed and breakfast rentals in Palestine Texas can investigate this webpage and our suburban advertisements and well appointed listed properties.
Find and discern condos for rent Harrison Texas, vacation homes Harrison, and Harrison rent house.
|
|
