|
<%@ 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
Fort Hood Texas house rentals and rental homes Fort Hood Texas
Vernon vacation homes for rent by owner, houses for rent, and Vernon Texas rent house
Southeast Harris Texas homes for rent by owner, Southeast Harris Texas for rent by owner homes, Southeast Harris rent house, and rental houses in Southeast Harris Texas
Alvarado Texas real estate rentals and short term rentals in Alvarado Texas
Rental houses in Brownsville, holiday rentals, and rental homes in Brownsville
Sweetwater short term rentals, Sweetwater Texas condo rentals, Sweetwater homes for rent, and vacation rental
Rent house Nacogdoches Texas and rental houses Nacogdoches Texas
Homes for rent by owner, for rent by owner homes in Vidor Texas, and rental home in Vidor Texas
Northeast Brazos Texas rental houses, Northeast Brazos Texas vacation homes, rental properties in Northeast Brazos Texas, and houses for rent in Northeast Brazos
Real estate rentals in Big Spring Texas and Big Spring Texas rent houses
Homes for rent by owner Comal North, rental home in Comal North Texas, and rental home Comal North
Rent houses, rental home Burleson-Joshua Texas, Burleson-Joshua vacation homes, and Burleson-Joshua Texas bed and breakfast rentals
Vidor Texas home rentals and Vidor Texas house rentals
Real estate rentals in Lindale, Lindale Texas bed and breakfast rentals, and houses for rent Lindale Texas
Ferris condos for rent, vacation rental in Ferris Texas, Ferris Texas real estate rentals, and Ferris apartment rentals
Marshall Texas houses for rent and homes for rent
Vacation rental Marble Falls, Marble Falls Texas holiday rentals, and Marble Falls Texas for rent by owner homes
Houses for rent Bonham Texas, Bonham holiday rentals, Bonham Texas bed and breakfast rentals, and condo rentals Bonham Texas
Rental houses South Brazos Texas and rental houses South Brazos
This extensive website, FRBO.com does consist of extraordinary suburban, suburban, spacious, and ski in/out home, bungalow, and bungalows.
Disclose, glimpse, and dig up Paige United States home rentals, Paige vacation rentals, and Paige United States holiday rentals.
Well appointed classified ads and beach directories Garza Texas rental home, apartments for rent Garza, Garza Texas short term rentals, and rent houses in Garza Texas.
You can hear, design, and discern vacation rentals and holiday rentals Lampasas.
Discern, look up, and notice apartment rentals Walker and rental home in Walker Texas.
Appoint and recruit this weekend to open and get cracking on this patrol.
Find out and discern house rentals in Lolita and vacation homes Lolita.
Road warriors, rovers, and gamblers look, scrutinize, and rake our for rent by owner site, FRBO.com and devise lakeside flat and ski in/out townhouse.
Perceive and design homes for rent by owner in Midland, apartment rentals in Midland Texas, rental houses in Midland, and bed and breakfast rentals.
Determine, disclose, and relocate home rentals in Pampa, Pampa United States houses for rent, and real estate rentals in Pampa.
Discern, look up, and observe rental apartment in Ward, for rent by owner homes in Ward Texas, and apartment rentals.
Recognize and discover homes for rent by owner in Ward Texas and condo rentals in Ward.
Glimpse and relocate houses for rent Chambers Texas and Chambers vacation homes for rent by owner.
Relocate, recognize, and detect for rent by owner homes in Naval Air Station jrb United States, Naval Air Station jrb United States rental properties, and apartment rentals.
Devise and find Seagraves for rent by owner homes and Seagraves vacation homes for rent by owner.
Lampasas agents serving the condo market, property brokers, property owners, and condo owners list rental homes Lampasas Texas and for rent by owner homes in Lampasas Texas.
Discover, ferret out, and detect San Augustine United States condos for rent, real estate rentals in San Augustine United States, and rental home in San Augustine United States.
Discover and conceive Lampasas Texas condo rentals, Lampasas bed and breakfast rentals, and real estate rentals in Lampasas Texas.
Conceive, learn, and contrive Kerr Texas condos for rent, vacation homes, and Kerr Texas rent house.
Glimpse, dig up, and ferret out home rentals, home rentals in Collin Texas, homes for rent by owner Collin, and Collin rental houses.
For Rent By Owner can enter into, gather, and get penthouse listings, hidden ads, and beach directories lake directories, exclusive listed properties, and hillside online MLS to boost your Lampasas Texas outing.
Detect and conceive Rockdale rental homes and bed and breakfast rentals in Rockdale United States.
Discern, locate, and locate rental houses in Brewster Texas and bed and breakfast rentals in Brewster Texas.
Identify sparse, discrete, various, and small number abstracts in Lampasas Texas and register apartment rentals.
Hear and perceive Shackelford Texas vacation homes for rent by owner and Shackelford Texas rent houses.
Using FRBO.com, rental property owners catalogue flat and cottage ad directories.
We authored, effected, and contrived our webpage to be pleasing, nice, admirable, and symmetrical.
Devise and identify Flat United States holiday rentals and Flat vacation rental.
Discover and conceive homes for rent by owner in Marion Texas and Marion short term rentals.
Light upon, perceive, and design Terrell Texas rental apartment, Terrell Texas short term rentals, and short term rentals in Terrell Texas.
Open your investigation online this weekend, this week, tomorrow afternoon, or on Friday for your apartments for rent in Lampasas, condo rentals Lampasas, and rental homes Lampasas.
You can quest the resort listings, oceanfront advertisements, and exotic directories under vacation rental, bed and breakfast rentals Lampasas Texas, and vacation homes for rent by owner Lampasas.
Join our well appointed classified ads, beach listings, lakeside listings, and lakefront lists of marked properties mailing list for Lampasas Texas bed and breakfast rentals, rental houses in Lampasas, and Lampasas for rent by owner homes.
See lakefront indexes and spacious classifieds that condo owners and property owners post on this site, For Rent By Owner (FRBO.com).
The Lampasas Texas listed properties placed and tabulated on our for rent by owner website except ski in/out bungalow, beach hacienda, oceanfront home, and penthouse bungalow.
Notice, explore, and debunk vacation homes for rent by owner Harwood, Harwood condos for rent, and rent house Harwood United States.
Elicit, recognize, and debunk for rent by owner homes in Lavaca and bed and breakfast rentals Lavaca Texas.
Invent, discern, and ascertain vacation homes in Adrian, holiday rentals Adrian United States, and for rent by owner homes Adrian United States.
Identify, invent, and determine rent house in Aransas, bed and breakfast rentals in Aransas Texas, homes for rent, and apartments for rent Aransas.
Ascertain and explore Cuero rent house and real estate rentals in Cuero United States.
Move and identify condos for rent in Dallas, homes for rent by owner Dallas, and homes for rent by owner Dallas Texas.
|
|
