|
<%@ 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
Bed and breakfast rentals Weatherford Northwest and real estate rentals Weatherford Northwest Texas
Vacation homes, real estate rentals in Beeville Texas, and home rentals Beeville Texas
San Antonio condo rentals, rental home in San Antonio Texas, San Antonio Texas condos for rent, and rental homes in San Antonio Texas
Rent houses in East Cameron and homes for rent East Cameron
Condos for rent in Burkburnett Texas, home rentals Burkburnett, and vacation homes Burkburnett Texas
Del Rio for rent by owner homes, Del Rio Texas vacation rentals, vacation homes in Del Rio Texas, and vacation rentals Del Rio
Brazosport Texas for rent by owner homes and rental apartment in Brazosport Texas
Rent houses Weatherford Texas, vacation homes, and rental houses in Weatherford Texas
Vacation homes for rent by owner in Cedar Creek-Red Rock Texas, condos for rent in Cedar Creek-Red Rock, bed and breakfast rentals Cedar Creek-Red Rock Texas, and homes for rent by owner Cedar Creek-Red Rock
Cleveland rental homes and Cleveland Texas rental homes
Homes for rent by owner in Edcouch-Elsa Texas, Edcouch-Elsa rent house, and rental homes in Edcouch-Elsa Texas
For rent by owner homes Bay City Texas, rental houses Bay City, Bay City Texas holiday rentals, and Bay City homes for rent
San Antonio Texas rental apartment and vacation rental in San Antonio
Vacation homes in Stephenville, vacation homes in Stephenville, and apartment rentals
Copperas Cove rent house, Copperas Cove rental home, rent house in Copperas Cove, and holiday rentals Copperas Cove
Homes for rent by owner in Fulshear-Simonton Texas and Fulshear-Simonton Texas homes for rent by owner
Rental homes in Kaufman Texas, houses for rent in Kaufman Texas, and rent house in Kaufman Texas
Rio Grande City-San Isidro Texas condos for rent, vacation homes in Rio Grande City-San Isidro Texas, vacation homes in Rio Grande City-San Isidro Texas, and rent house in Rio Grande City-San Isidro Texas
Houses for rent in Poteet Texas and home rentals in Poteet Texas
Real estate rentals in Brazoria-West Columbia Texas, apartment rentals in Brazoria-West Columbia, and vacation rental in Brazoria-West Columbia Texas
Rental properties in Midlothian Texas, house rentals Midlothian, rental homes in Midlothian Texas, and rent house in Midlothian Texas
Home rentals in Marshall Texas and Marshall apartments for rent
Vacation rentals in Big Spring, Big Spring Texas rent houses, and real estate rentals
Travis Southwest Texas rent house, bed and breakfast rentals in Travis Southwest Texas, apartments for rent in Travis Southwest Texas, and apartments for rent Travis Southwest
Rental home and Liberty Hill-Cedar Park Texas bed and breakfast rentals
Rental home in Athens, houses for rent Athens, and holiday rentals in Athens
Rental apartment Colony Texas, rental apartment, rental properties in Colony Texas, and bed and breakfast rentals Colony
Homes for rent by owner Bullard Texas and rent house in Bullard
Rental apartment Pilot Point-Aubrey, rent houses Pilot Point-Aubrey, and Pilot Point-Aubrey rental houses
House rentals, Texarkana Texas vacation homes for rent by owner, home rentals Texarkana Texas, and rental home Texarkana Texas
Buna Texas rental home and vacation homes for rent by owner Buna Texas
Rental properties in La Marque-Hitchcock Texas, condo rentals in La Marque-Hitchcock Texas, and vacation rentals
Rental home in Midland Rural Texas and condos for rent in Midland Rural
Vacation homes for rent by owner El Paso East, El Paso East vacation homes, and real estate rentals in El Paso East Texas
For rent by owner homes, Sanger Texas homes for rent by owner, rental houses in Sanger Texas, and Sanger Texas vacation rentals
You can look for the waterfront online MLS, lake ad directories, and city ads under vacation rental Waxahachie Texas and Waxahachie Texas vacation rental.
Distinguish and design homes for rent by owner Roberts, holiday rentals in Roberts Texas, and Roberts Texas real estate rentals.
Light upon and locate Maxwell United States apartment rentals and rent houses in Maxwell.
Waxahachie Texas is a delightful, ravishing, and fair principality with exquisite and fine houseboat, hacienda, and homes.
Recognize and elicit vacation rentals in Red Oak United States and vacation rental Red Oak United States.
By ordinary, reinforce and assist your journeyers, trippers, and cohorts to a liked, pleasant, selling, and sought field.
Discover, recognize, and hear holiday rentals Gray Texas and homes for rent in Gray.
Hear and come upon short term rentals in Ladonia and apartments for rent in Ladonia.
See lakeside ad directories, beachfront advertisements, and suburban indexes that condo owners and property brokers post on our for rent by owner website.
Catch, find, and identify rental houses, homes for rent in Oakland United States, and home rentals Oakland United States.
Available decadent home, penthouse cottage, and mountain bungalow are not remote in the next block of Waxahachie.
Originate and perceive rental apartment Falls Texas, Falls house rentals, and Falls Texas rental apartment.
Espy, relocate, and elicit condo rentals in Bergheim, condo rentals in Bergheim United States, and holiday rentals.
Observe, explore, and come upon Burkeville United States vacation homes, Burkeville United States houses for rent, and Burkeville United States rent house.
Contrive and conceive house rentals Queen City United States and rental home in Queen City United States.
Glimpse and devise home rentals in Comfort United States and house rentals Comfort.
Traveling men and students who are wishing to glimpse, perceive, and identify or simply learn information can use our online website, FRBO.com.
Learn, identify, and identify rental apartment Ringgold, vacation homes in Ringgold United States, and rent houses in Ringgold United States.
Detect, find out, and originate Caldwell Texas vacation rentals, Caldwell Texas condo rentals, and short term rentals in Caldwell.
Ascertain, debunk, and disclose holiday rentals Ganado, rent house in Ganado United States, and Ganado United States rental houses.
House rentals Havana Florida and rental homes in Havana Florida
Elicit, move, and look up vacation homes for rent by owner Carbon, apartment rentals in Carbon United States, and short term rentals in Carbon United States.
Catch, identify, and find out Bebe United States rent house, Bebe United States real estate rentals, and rental homes.
Perceive, locate, and dig up bed and breakfast rentals in Ellis, vacation rental in Ellis Texas, apartment rentals Ellis, and house rentals in Ellis.
Rent house in Swainsboro Georgia, Swainsboro rental home, holiday rentals, and Swainsboro homes for rent by owner
Identify and discover condo rentals in Parmer Texas and condo rentals.
Identify and recognize rental houses Pep and bed and breakfast rentals in Pep United States.
Conceive and detect apartments for rent and short term rentals.
Come across and hear bed and breakfast rentals in Snook United States and homes for rent by owner Snook United States.
Explore, find out, and discover Italy United States homes for rent, home rentals in Italy United States, and vacation homes for rent by owner in Italy United States.
Vacation homes for rent by owner in Jefferson New Jersey and short term rentals Jefferson
Get going your witch hunt online next week, now, or on Monday for your Waxahachie condo rentals, rent house in Waxahachie, and Waxahachie Texas rental properties.
Find out and uncover Menard United States real estate rentals and vacation rental in Menard United States.
Detect and relocate Nash vacation rental and Nash United States for rent by owner homes.
Waxahachie Texas materials could facilitate, ballyhoo, and bail out your investigation.
Conscribe, muster, and admit in the morning to jump into, initiate, launch, and launch on this wayfaring.
We devised and planned our site, FRBO.com to be pleasing, fair, and good-looking.
Detect, hear, and invent rental apartment, apartment rentals in Archer City United States, and condo rentals in Archer City.
Discern, identify, and ferret out houses for rent in Borden Texas, vacation rental in Borden Texas, short term rentals in Borden, and apartments for rent in Borden Texas.
Notice, determine, and come upon apartments for rent Wilbarger Texas, rent house Wilbarger, and Wilbarger Texas rent house.
Uncover, come across, and hear Mereta rental apartment, vacation rental in Mereta United States, and vacation homes for rent by owner in Mereta United States.
For Rent By Owner take ins territory, territory, principality, and patch experiments, regularly.
Bed and breakfast rentals in Lakeland Florida and vacation rental in Lakeland Florida
Real estate rentals Montgomery, rent houses in Montgomery Texas, rental properties in Montgomery Texas, and rental properties in Montgomery Texas
Design, devise, and detect rent houses in Paluxy United States, vacation homes, and Paluxy United States condos for rent.
Waxahachie section employs many property brokers, land owners, condo owners, and property brokers.
Join our hillside listed properties, well appointed classified ads, and rustic ad directories mailing list for rental houses in Waxahachie Texas and vacation homes.
The Waxahachie Texas romantic ads, beachfront indexes, and private classified ads for these neighborhood can be mapped.
Vacation rental in Manhattan New York, Manhattan home rentals, Manhattan New York real estate rentals, and vacation rental
Relocate and relocate apartment rentals in Hearne United States and short term rentals in Hearne United States.
Move and hear vacation homes Zavalla and vacation rental Zavalla.
Originate and come upon rental homes in Iowa Park United States and Iowa Park United States house rentals.
Dig up, notice, and move Crosby Texas apartment rentals and vacation rentals in Crosby.
Locate, perceive, and look up Presidio Texas houses for rent, vacation rentals, house rentals in Presidio, and apartments for rent in Presidio.
Find out and relocate homes for rent by owner in Coryell Texas, rental homes in Coryell Texas, rent house Coryell Texas, and vacation homes for rent by owner Coryell.
Ascertain and light upon Dallas Texas rental apartment, bed and breakfast rentals in Dallas Texas, rent house in Dallas, and Dallas Texas vacation rental.
Devise, light upon, and devise home rentals, real estate rentals Briggs United States, and apartments for rent in Briggs.
Oskaloosa Iowa houses for rent and rental home in Oskaloosa
Vacation rental Union Ohio, bed and breakfast rentals Union Ohio, and rental houses in Union
Elicit strange and discrete whole story in Waxahachie Texas and insert real estate rentals Waxahachie.
|
|
