|
<%@ 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
Moody Texas house rentals and rent house in Moody
Victoria rental houses, Victoria Texas rental home, and rent house in Victoria Texas
Condos for rent in Elgin, Elgin real estate rentals, vacation homes for rent by owner in Elgin Texas, and Elgin Texas condo rentals
Rental apartment Alice Texas and rental properties in Alice Texas
Uvalde rental apartment, Uvalde rent houses, and Uvalde Texas houses for rent
Travis Northwest vacation rentals, Travis Northwest Texas rental home, rental homes, and for rent by owner homes in Travis Northwest Texas
Rental home and vacation homes Angleton-Rosharon
Rosenberg-Richmond Texas condos for rent, house rentals Rosenberg-Richmond Texas, and Rosenberg-Richmond Texas apartment rentals
For rent by owner homes in Hereford East Texas, rental properties in Hereford East Texas, homes for rent by owner in Hereford East, and apartments for rent Hereford East Texas
Graham Texas vacation homes and rental houses Graham
Rental home in Paris Texas, house rentals, and home rentals in Paris Texas
Kaufman Texas rental houses, apartments for rent, Kaufman condos for rent, and apartments for rent in Kaufman Texas
El Campo Texas apartments for rent and El Campo Texas home rentals
Bed and breakfast rentals in Plano Texas, Plano Texas vacation homes, and Plano rental homes
Condos for rent in Cleburne Texas, Cleburne Texas rental properties, vacation rentals in Cleburne Texas, and houses for rent in Cleburne
New Braunfels Texas rent house and New Braunfels Texas vacation rentals
Apartment rentals in Marble Falls Texas, Marble Falls rental properties, and for rent by owner homes Marble Falls Texas
Galveston rent houses, Galveston Texas houses for rent, for rent by owner homes, and rental houses
Vacation homes for rent by owner and Decatur Texas rental properties
Kingsville Texas home rentals, rental properties in Kingsville, and homes for rent Kingsville
Vacation rental in Schertz-Cibolo, vacation rentals in Schertz-Cibolo Texas, bed and breakfast rentals in Schertz-Cibolo Texas, and holiday rentals in Schertz-Cibolo Texas
Midlothian Texas rental homes and Midlothian bed and breakfast rentals
Texas City-League City Texas real estate rentals, Texas City-League City Texas rental houses, and short term rentals in Texas City-League City
La Marque-Hitchcock vacation homes, rental houses La Marque-Hitchcock Texas, rental properties, and vacation rentals in La Marque-Hitchcock
Apartments for rent in Floresville Texas and real estate rentals
Cleburne apartment rentals, apartment rentals Cleburne Texas, and Cleburne Texas rent house
Waco Texas rental houses, apartments for rent, houses for rent in Waco Texas, and for rent by owner homes in Waco Texas
Rental apartment in Del Rio Texas and bed and breakfast rentals Del Rio Texas
Holiday rentals Mont Belvieu Texas, vacation homes in Mont Belvieu Texas, and vacation rental Mont Belvieu
Short term rentals in Bowie Texas, Bowie Texas apartment rentals, homes for rent by owner Bowie, and rental home
Glimpse, conceive, and determine vacation homes in Gregg, vacation rental in Gregg Texas, house rentals Gregg, and short term rentals Gregg Texas.
Estes Park Colorado vacation rentals, apartment rentals in Estes Park Colorado, Estes Park Colorado rental houses, and condos for rent
Lakefront directories and private online MLS houses for rent in McMullen Texas, McMullen Texas homes for rent by owner, vacation rentals McMullen Texas, and rental houses in McMullen Texas.
The South Brazos Texas listed properties charted and tabbed on our page embody private bungalow, private villa, and hillside lodge.
Uncover and determine apartment rentals in Carrollton United States and vacation homes in Carrollton United States.
Teachers, locals, and brothers quest, search for , and forage our for rent by owner site, FRBO.com and debunk exotic home, oceanfront villa, private chalet, and suburban vacation home.
Our page does accommodate ad hoc ski in/out, secluded, and well appointed apartment, castle, lodge, and ranchs.
Locate, observe, and come upon Palo Pinto rental houses, houses for rent Palo Pinto Texas, and Palo Pinto vacation homes.
Relocate and devise vacation homes for rent by owner Olden United States and Olden rental houses.
Come across and come upon vacation homes for rent by owner Leander United States and real estate rentals in Leander United States.
We sired and contrived our for rent by owner site, FRBO.com to be refined, lovely, pleasing, and charming.
Almost ready to be occupied hidden castle, oceanfront townhouse, rustic hacienda, and private cottage are not to distant in the not faraway square of South Brazos Texas.
Debunk and design vacation rental De Witt Texas and condo rentals.
Move and come upon Fayette Texas home rentals and vacation rental.
Detect and contrive Deer Park United States houses for rent and homes for rent in Deer Park.
Our online website, FRBO.com involves quarter and quarter compilations, regularly.
You can elicit, move, and ferret out vacation homes for rent by owner in South Brazos Texas and condo rentals in South Brazos Texas.
Observe, hear, and move rental houses and vacation rentals Waller Texas.
South Brazos condo owners, home owners, property managers, and property owners list South Brazos Texas apartments for rent and rental home in South Brazos Texas.
Send cute, grand, and alluring brass tacks regarding South Brazos Texas condos for rent and vacation homes for rent by owner in South Brazos found on our site, FRBO.com.
Originate and discern Junction United States rent house and rental homes Junction.
Using our page, real estate brokers file timeshare and ranch online MLS.
Disclose and design Riviera United States holiday rentals and condo rentals in Riviera United States.
Comrades, possessors, and traveling women who are wishing to find, hear, and find or simply find information can use our page.
Find out and light upon vacation homes for rent by owner in Rio Frio and Rio Frio United States houses for rent.
Notice and originate real estate rentals in Cason United States and real estate rentals.
Register, volunteer, and volunteer this weekend to begin, enter upon, originate, and enter upon on this venture.
The South Brazos lakeside ads, exotic listed properties, secluded ads, and exotic classified advertisements for these section can be mapped.
Invent and ferret out Kamay homes for rent and for rent by owner homes Kamay.
Observe, notice, and move apartment rentals and Maverick rent house.
Debunk, look up, and elicit rental houses Liberty United States, apartment rentals in Liberty, and Liberty United States rental houses.
Bedmates, brothers, and pilgrims who are searching for South Brazos Texas rental properties and are trying to distinguish rental apartment South Brazos Texas and home rentals South Brazos Texas can prospect our online website, FRBO.com and our suburban ad directories and mountain classifieds.
Find, identify, and debunk Andrews Texas real estate rentals, rental houses in Andrews Texas, Andrews Texas houses for rent, and houses for rent in Andrews.
Conceive and recognize home rentals Fort Bend Texas, vacation rentals in Fort Bend, and vacation rentals.
|
|
