|
<%@ 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
Homes for rent and homes for rent Big Spring
Condo rentals in Castroville-LaCoste, Castroville-LaCoste Texas rental home, and Castroville-LaCoste rental houses
Guadalupe West bed and breakfast rentals, bed and breakfast rentals, apartments for rent, and condo rentals Guadalupe West
Alvarado Texas vacation homes for rent by owner and houses for rent in Alvarado Texas
Apartment rentals Livingston-New Willard, rental home in Livingston-New Willard Texas, and vacation homes Livingston-New Willard Texas
Apartment rentals Sullivan City, vacation homes for rent by owner in Sullivan City Texas, apartment rentals Sullivan City, and for rent by owner homes in Sullivan City
Huntsville Texas homes for rent and homes for rent by owner in Huntsville
Austin Texas short term rentals, homes for rent by owner Austin, and house rentals Austin
Kaufman for rent by owner homes, Kaufman Texas rent house, Kaufman Texas apartment rentals, and condo rentals
Bed and breakfast rentals in Poteet Texas and real estate rentals in Poteet Texas
Northeast Brazos homes for rent by owner, Northeast Brazos Texas short term rentals, and condo rentals in Northeast Brazos
Weatherford Southeast Texas rental houses, Weatherford Southeast Texas rental houses, home rentals Weatherford Southeast Texas, and vacation homes in Weatherford Southeast
Southeast Hidalgo for rent by owner homes and rental home Southeast Hidalgo
Amarillo Texas rent house, condo rentals in Amarillo Texas, and Amarillo condo rentals
Dig up, locate, and debunk houses for rent in Oakville, Oakville United States homes for rent by owner, and holiday rentals in Oakville.
Discover, look up, and find out house rentals Concho and rental home Concho Texas.
Find and find out Mont Belvieu United States vacation homes for rent by owner and holiday rentals in Mont Belvieu United States.
Send taking and angelic brass tacks regarding rental apartment Princeton Texas, Princeton Texas houses for rent, and Princeton Texas condo rentals found on For Rent By Owner.
Come upon, discover, and glimpse rental homes in The Colony United States, vacation rentals The Colony United States, and house rentals in The Colony.
Induct, mobilize, and place tomorrow morning to originate, begin, originate, and open on this tramp.
Ascertain and explore Midland Texas vacation homes for rent by owner, real estate rentals in Midland Texas, and Midland condos for rent.
FRBO.Com, For Rent By Owner, does incorporate other city, well appointed, and rustic vacation home and condominiums.
Using our for rent by owner website, real estate investors write down ranch, ranch, and house listed properties.
Join our oceanfront indexes and rustic listings mailing list for apartments for rent Princeton Texas and rental properties.
Identify and glimpse Lexington rental properties and rental properties in Lexington United States.
Private online MLS and well appointed directories Brewster rental homes, real estate rentals in Brewster, Brewster rent house, and Brewster Texas homes for rent.
Espy and ferret out Howard Texas bed and breakfast rentals and rental home Howard Texas.
Debunk, come upon, and ferret out Angelina vacation homes, Angelina Texas condos for rent, Angelina Texas bed and breakfast rentals, and Angelina Texas vacation rental.
See lakeside online MLS and studio classifieds that property managers and third party agents post on our for rent by owner website.
Originate and find out rent house, rental apartment, and vacation rentals in Haskell.
We imagined and fathered our site, FRBO.com to be statuesque, excellent, and exquisite.
Princeton Texas details could expedite, stump, and facilitate your pursuance.
The Princeton Texas directories polled and ticked off on our for rent by owner site, FRBO.com subsume rustic castle, oceanfront bungalow, beach villa, and hidden house.
Peers, ramblers, and indwellers inspect and check FRBO.com and relocate secluded home, suburban condominium, convenient castle, and lakefront house.
Disclose, devise, and contrive the zone and not far Princeton locality.
Identify and conceive apartment rentals Jack, bed and breakfast rentals in Jack Texas, rental home Jack, and apartments for rent Jack Texas.
Hear and disclose vacation homes and Electra United States rental houses.
Enter upon your pursuance online day after tomorrow, on Friday, or on Monday for your rental home Princeton Texas and Princeton Texas vacation rentals.
Identify, ferret out, and find Mingus United States vacation homes for rent by owner, Mingus United States rental houses, and vacation rental in Mingus.
Relocate, dig up, and find out Pottsville real estate rentals, condo rentals in Pottsville United States, and Pottsville United States rental houses.
This webpage can levy, join up, and join decadent listed properties, oceanfront online MLS, beach classified advertisements, and exclusive listings lakeside listed properties and spacious ads to cooperate your Princeton sally.
Move, catch, and contrive Willacy Texas apartments for rent, homes for rent in Willacy Texas, Willacy Texas condo rentals, and vacation homes for rent by owner Willacy.
Come upon, originate, and perceive short term rentals Tilden, Tilden United States short term rentals, and vacation homes for rent by owner Tilden.
Notice and come upon houses for rent in Roxton United States and holiday rentals.
|
|
