Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:54:49.620' ,`MLSNumber` = '39671779' ,`ListAgentFullName` = 'La Toya Burns' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913324' ,`Longitude` = '-94.019204' ,`PhotoCount` = '23' ,`PostalCode` = '77640' ,`RoomCount` = '3' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = '66th' ,`StreetNumber` = '2451' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER! BRING ALL OFFERS! DOUBLE LOT! Original Victorian designed home with good bones and solid wood construction. This home perched on a quiet street in the Port Acres community can make a great rental or with it\'s connecting lot, it can serve as the perfect canvas to redesign your own home. And BONUS, this home has NEVER FLOODED and has NO HOA or DEED RESTRICTIONS.' ,`Acres` = '0.5399' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '106.10 X 220 TR 3 LT 10 BLK 1 PORT ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '23518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = '' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Port Acres' ,`TaxAmount` = '2210' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983812' WHERE `Matrix_Unique_ID` = '206708733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:14:34.963' ,`MLSNumber` = '98587672' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297390' ,`Longitude` = '-94.928295' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Isles End' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Road' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOSTLY FURNISHED --BEAUTIFUL BAY FRONT HOME WITH PRIVATE POOL\r\nHome has the \"WOW\" Factor!\r\nThe kitchen and Family Room is wide open and ideal for entertaining with incredible views of Inter-coastal and Deer Island.\r\nTwo Primary\'s and Two Office Nooks!\r\nYou will love the pool entertainment area\r\nAsk about rental for one year-$4300.00 per month' ,`Acres` = '0.122' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 27 TIKI ISLAND SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '16127' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983812' WHERE `Matrix_Unique_ID` = '207730961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:05:27.677' ,`MLSNumber` = '8724419' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402663' ,`Longitude` = '-95.505243' ,`PhotoCount` = '20' ,`PostalCode` = '77318' ,`RoomCount` = '11' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Starlit Sky' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live your best life in the superior craftsmanship and incredible comfort of Hillmont luxury home plan. Design your ultimate home office or an innovative specialty room in the captivating front study. The epicurean kitchen provides a presentation island and ample room for food storage and meal prep. Your open-concept floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings. Unique personalities and individual styles shine in the spacious spare bedrooms and guest suites. Retire to the elegance of your deluxe Owners Retreat, featuring an everyday-spa bathroom and a wardrobe-expanding walk-in closet. The upstairs retreat is the perfect space to create a family movie theater or a fun and games parlor. Cherish your relaxing sunsets and breezy weekends from the shaded bliss of your delightful front and back covered patios.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9581' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983812' WHERE `Matrix_Unique_ID` = '208808294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:31:22.487' ,`MLSNumber` = '81014991' ,`ListAgentFullName` = 'Sharon Eddings' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.418855' ,`Longitude` = '-95.628872' ,`PhotoCount` = '24' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Palais Verde' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ATTRACTIVE single-story home in Bentwater on corner lot: Inviting home in quiet cul-de-sac with mature tree-shaded driveway. Leaded glass door welcomes you into light-filled living area with high ceilings, updated wood laminate floors, and brick fireplace. Space easily flows into sunny breakfast nook and kitchen with ample granite countertops with space for barstools and dedicated desk area. Open sight lines from kitchen encourage entertaining with second dining area close by. SS Frigidaire appliances, plenty of cabinet space, and large pantry. Private office with large windows and glass-paneled pocket doors near kitchen. Follow hallway to large primary bedroom and ensuite, with double vanities and large double closets. Opposite side of home opens to 2 bedrooms, offering privacy to family or guests, with Hollywood bathroom and walk-in closets. Iron fence borders open dog-friendly backyard. Social membership required; privacy fence OK per POA. Schedule your showing today!' ,`Acres` = '0.2565' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 07, BLOCK 4, LOT 5' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '11172' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '5581' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666983813' WHERE `Matrix_Unique_ID` = '209247938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:28:22.420' ,`MLSNumber` = '63848907' ,`ListAgentFullName` = 'Jessica Dabney' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586150' ,`Longitude` = '-95.237317' ,`PhotoCount` = '29' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Sageorchard' ,`StreetNumber` = '11107' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and Elegant fully upgraded home located near South Houston. Located on the cul de sac this open floor plan home full of natural light will surely captivate you. Not to mention its custom flooring, granite countertops and new stainless steel appliances. You wont regret calling this place home. Close to Beltway 8 and 45 South you will have easy access to anywhere in the city. Schedule your showing today.' ,`Acres` = '0.2296' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 43 SAGEMEADOW SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sagemeadow Sec 05' ,`TaxAmount` = '4991' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983813' WHERE `Matrix_Unique_ID` = '209783884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:05:04.247' ,`MLSNumber` = '13649855' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477689' ,`Longitude` = '-95.506234' ,`PhotoCount` = '41' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '485132.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgeport Path' ,`StreetNumber` = '2138' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Top-quality craftsmanship is matched with luxurious comforts to make The Devon a uniquely impressive family home plan. End each day and wake up refreshed in the delightful Owner’s Retreat, which includes a deluxe bathroom and walk-in closet. The chef’s specialty kitchen supports the full variety of cuisine exploration with a spacious pantry, extended countertops, and a full-function island. Your open floor plan offers soaring ceilings and a dynamic opportunity to design your ideal living space. Each spare bedroom provides a fantastic place for unique personalities to shine. Craft your perfect family lounge and movie theater in the cheerful upstairs retreat. How do you imagine your #LivingWeekley experience in this extraordinary new home plan?' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983813' WHERE `Matrix_Unique_ID` = '209944328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:12:06.293' ,`MLSNumber` = '8221083' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843444' ,`Longitude` = '-95.267876' ,`PhotoCount` = '9' ,`PostalCode` = '77028' ,`RoomCount` = '4' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Talton' ,`StreetNumber` = '8528' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION!!! September 2022 completion date. Located in the heart of Houston is this inviting 4 bedroom, 2 bath, 2 car garage oasis that awaits you. This is an energy efficient home with durable countertops, luxury laminate flooring, ceramic tiling, contemporary carpet and a spacious kitchen. The area is quiet and gives the feel of out of the city living but it is close to everything. This home is 10 minutes from downtown Houston, Minute Maid Park and BBVA Compass Stadium. No HOA and Low taxes!! The pictures are from a previously built home and is for illustration purposes only (colors and upgrades may be different).' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Silver Circle Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 1 BLOCK 1 SILVER CIRCLE PLAZA HOUSTON TEXAS 77028' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5287' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Silver Circle Plaza' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983813' WHERE `Matrix_Unique_ID` = '210896876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:56:02.173' ,`MLSNumber` = '5610776' ,`ListAgentFullName` = 'Diane Elaine Andrews' ,`ListOfficeName` = 'New Vision Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868846' ,`Longitude` = '-95.718203' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '291000.00' ,`Status` = 'Active' ,`StreetName` = 'Portlick' ,`StreetNumber` = '6610' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2245' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ALL NEW KITCHEN APPLIANCES INCLUDING REFRIGERATOR! WASHER & DRYER INCLUDED! NEW ROOF & WATER HEATER! NEW TILE FLOORING ON 1ST FLOOR! NEW CARPET ON 2ND FLOOR! NEW GRAY DESIGNER PAINT THROUGHOUT! RECENT A/C COMPRESSOR! Large 4 Bedroom Home with Gameroom. Formal Dining. Recent Ceiling Fans. Decorative Tile Flooring In Powder Room. Whirlpool Tub In Primary Bedroom With Separate Shower. Double Sinks In Primary Bedroom. Double Sinks In Secondary Bedrooms. Breakfast Bar In Kitchen For Extra Seating. Extra Large Utility Room Off Kitchen. GRANITE Kitchen Countertops. Garage Door Opener In Garage. Extension off Garage For Extra Storage. LIFETIME FOUNDATION TRANSFERABLE WARRANTY. Spacious Backyard For entertaining. Great Location. Easy Access To FM 529 For Shopping And Entertainment. Easy Access To 99 Grand Parkway. Near Katy Mills Mall And Typhoon Texas Waterpark.' ,`Acres` = '0.1148' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 5 BEAR CREEK MEADOWS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Creek Meadows' ,`TaxAmount` = '5465' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983813' WHERE `Matrix_Unique_ID` = '210937761' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:24:55.803' ,`MLSNumber` = '97721274' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537328' ,`Longitude` = '-95.755965' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '14' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Village' ,`StreetNumber` = '922' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Energy Saving Home on a Huge Private Cul De Sac Lots! Upgraded Front Porch Elevation & Huge Extended Covered Patio! Sprinkler System! Grand Entry with High Ceilings! Gorgeous Wood Like Vinyl Floors Throughout! French Doors open to your Wonderful Home Office! Guest Suite Down with Full Bathroom! Fabulous Family Area with Walls of Windows looks out to your Huge Private Backyard! Family Area flows into the Casual Dining & Magnificent Gourmet Kitchen features Beautiful Tall Cabinets, Subway Glass Tile Backsplash, Huge Eat In Working Station Island, Water Softener System, Undermount Sink, Stainless Steel Appliances, Wine Color & Walk In Pantry! Large Primary Suite with Sitting Area, High Ceilings, Luxurious Bathroom with His & Her Granite Countertops, Stunning Framed Mirrors, Deep Soaker Tub, Seamless Glass Shower, Tile Floors & Walk In Closet! Discover Upstairs French Doors that opens to Huge Media Room, Game Room, 2 Guest Bedrooms & Hollywood Bathroom! No Flooding! Great Location' ,`Acres` = '0.2058' ,`Area` = '30' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SUMMER PARK SEC 3, BLOCK 1, LOT 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8963' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Summer Park' ,`TaxAmount` = '6715' ,`TaxRate` = '2.8448' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983814' WHERE `Matrix_Unique_ID` = '211320690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:43:58.700' ,`MLSNumber` = '80638104' ,`ListAgentFullName` = 'Summer Bloom' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296649' ,`Longitude` = '-94.783583' ,`PhotoCount` = '49' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '1519' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a step back in time and see this very charming 1913 (per seller) corner lot home and enjoy soothing gulf breezes on your wraparound porch. Located 2.5 blocks from the seawall..it\'s a short walk to the beach. Abundance of original windows provide lots of natural light in living room and formal dining room. Original pocket doors w/original brass hardware. Hardwood floors downstairs, as well as high ceilings throughout. 60’s cast iron sink and butler panty. Utility room and a bathroom/shower on main level. All bedrooms upstairs & two additional enclosed spaces (one was the sleeping porch & other was the nanny\'s room). Upstairs bathroom has an iron clawfoot soaking tub/shower. Attic has lots of storage. Newer outside HVAC units (2). Fully fenced backyard, single detached oversized garage. Close to downtown, UTMB, shopping, dining. Vacation rentals allowed. Ready to rest, nest or invest? Come call this home! Schedule your showing today!' ,`Acres` = '0.0888' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S 45 FT OF LOTS 8 & 9 (1008-2) NE BL' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3870' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5947' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1913' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666983814' WHERE `Matrix_Unique_ID` = '211540021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:38:20.730' ,`MLSNumber` = '65976254' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157034' ,`Longitude` = '-95.056425' ,`PhotoCount` = '48' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '230769.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '145' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1642, ACRES 0.4200' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983814' WHERE `Matrix_Unique_ID` = '211932525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:52:00.550' ,`MLSNumber` = '84024526' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157082' ,`Longitude` = '-95.056628' ,`PhotoCount` = '40' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '233737.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '161' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1641, ACRES 0.4200' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983814' WHERE `Matrix_Unique_ID` = '211939300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:36:26.090' ,`MLSNumber` = '9156701' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157274' ,`Longitude` = '-95.056943' ,`PhotoCount` = '14' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '252985.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '177' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1640, ACRES .42' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Sec 5' ,`TaxAmount` = '704' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983814' WHERE `Matrix_Unique_ID` = '211942402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:33:59.007' ,`MLSNumber` = '27421809' ,`ListAgentFullName` = 'Virginia Hall' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924340' ,`Longitude` = '-95.078323' ,`PhotoCount` = '32' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Binnacle' ,`StreetNumber` = '430' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious log cabin on a large corner lot has so much to offer! A lovely covered front porch to enjoy coffee in the mornings and iced tea in the evenings welcomes you to into this wonderful home. Recent updates to the interior include new tub surrounds, fresh paint, new flooring and more! Large kitchen with breakfast bar overlooks the family room. Oversized 3-car garage, expansive back deck for entertaining, and a stunning fire pit feature in the back yard is surely to warm you on the cooler autumn and winter nights. Don\'t miss out on this beautifully unique home!' ,`Acres` = '0.1894' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 NEWPORT SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 03' ,`TaxAmount` = '4135' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983815' WHERE `Matrix_Unique_ID` = '211967268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:35:01.443' ,`MLSNumber` = '26857966' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.156755' ,`Longitude` = '-95.055323' ,`PhotoCount` = '38' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '233408.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '317' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.39' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 9, LOT 1461, ACRES .39' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '16988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983815' WHERE `Matrix_Unique_ID` = '211974635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:39:04.737' ,`MLSNumber` = '33716737' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157414' ,`Longitude` = '-95.057290' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '199460.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5117' ,`StreetNumber` = '18' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.35' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1639, ACRES .35' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1034' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983815' WHERE `Matrix_Unique_ID` = '211976130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:51:25.410' ,`MLSNumber` = '34846792' ,`ListAgentFullName` = 'Amber Quiroz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214318' ,`Longitude` = '-95.423391' ,`PhotoCount` = '46' ,`PostalCode` = '77385' ,`RoomCount` = '14' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Yearling Place' ,`StreetNumber` = '9961' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Beautifully built, HUGE 5 bedroom, 3 bathroom brick home featuring a formal dining room, 2 car garage, spacious backyard, impressive kitchen with granite countertops. Primary bedroom is upstairs and includes a huge bathroom with 2 sinks and lots of closet space! The home has a custom, built-in dog house for your pooch! The dog suite is 4\'x8\'. Save money with the solar panels, which pays for the lights and water heater electricity usage. The Tesla battery stores energy for outages. The Tesla app allows the homeowner to see how much the electricity company pays back. The neighborhood park is a short walk away and includes a playground, splash pad, pool, and picnic area. The Woodlands Mall, Market Street, and Medical Center are all less than 10 minutes away. There is an HEB, Starbucks, and several restaurants less than 5 minutes away. This home is built in a location for a quiet home life, & convenient access to everything Conroe and The Woodlands has to offer.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'S720810 - MONTGOMERY CREEK RANCH 10, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 10' ,`TaxAmount` = '5468' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983815' WHERE `Matrix_Unique_ID` = '212040189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:51:22.470' ,`MLSNumber` = '80873284' ,`ListAgentFullName` = 'Cyndee Henderson' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815132' ,`Longitude` = '-94.986874' ,`PhotoCount` = '27' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Basalt' ,`StreetNumber` = '4810' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see for yourself this awesome single story 4 Bedroom home! Very Well Maintained! Great neighborhood with a convenient walkway to the elementary school. Study or Formal Dining room off the spacious foyer. Kitchen features a gas stove and room for a breakfast nook. The Family room is large with a wonderful corner fireplace which will be fun to decorate for the upcoming holidays and cooler weather. Owners Suite is toward the back of the house and has a huge closet, vanity area, PLUS soaker tub with separate shower. 3 secondary bedrooms and a walk-through Jack & Jill bathroom which includes 2 sinks with vanities! This home is ready for your family to enjoy!' ,`Acres` = '0.1622' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 EASTPOINT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7065' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '193' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'EASTPOINT' ,`TaxAmount` = '6117' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983815' WHERE `Matrix_Unique_ID` = '212207894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:27:44.797' ,`MLSNumber` = '9248349' ,`ListAgentFullName` = 'Jessica Dabney' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749587' ,`Longitude` = '-95.594076' ,`PhotoCount` = '38' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '365900.00' ,`Status` = 'Active' ,`StreetName` = 'Nova' ,`StreetNumber` = '12030' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeously renovated home in the sought after neighborhood of Briar Lake Subdivision. Home is located in Houston\'s Energy Corridor. This fully upgraded 4 bed 2.5 bath is sure to impress. This traditional style home features brand new upgrades that compliment it\'s breathtaking floor-plan. Some upgrades include granite countertops , new stainless steel appliances, custom flooring throughout, alluring fixtures , and an array of natural light. This home will surely captivate you. Great location, close to I-10 , Beltway, West Park Tollway, and great shopping. Schedule your showing today!' ,`Acres` = '0.1985' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 7 BRIAR LAKE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8648' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '673' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Lk' ,`TaxAmount` = '7540' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983816' WHERE `Matrix_Unique_ID` = '212292201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:54:55.017' ,`MLSNumber` = '8430125' ,`ListAgentFullName` = 'Gregory Cordova' ,`ListOfficeName` = 'CENTURY 21 Western Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558739' ,`Longitude` = '-95.749676' ,`PhotoCount` = '49' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission Olive' ,`StreetNumber` = '710' ,`StreetSuffix` = 'Cove' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Call today to see this beautiful Del Webb Sweetgrass 3-bedroom home with generator and is only a 2-minute walk to the Del Webb Lakehouse! The home has 3 bedrooms, 2 ½ bathroom, study/library with French doors, tile throughout home (no carpet), open kitchen with under cabinet lighting, a large living room with corner gas fireplace, large primary bedroom, spacious primary bathroom, tankless water heater, sprinkler system, insulated garage door and GENERATOR! Come relax on your large covered patio and enjoy the peaceful backyard. Make this your home TODAY and enjoy the 27,000 sqft Lakehouse w/heated indoor/outdoor pool, spa, various clubs, 24hr fitness center & the active Del Webb lifestyle.' ,`Acres` = '0.2647' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 4, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb Richmond Sweetgrass' ,`TaxAmount` = '10654' ,`TaxRate` = '2.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983816' WHERE `Matrix_Unique_ID` = '212343430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:37:00.453' ,`MLSNumber` = '53726877' ,`ListAgentFullName` = 'Azalia Benjamin-Mathis' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823212' ,`Longitude` = '-95.552303' ,`PhotoCount` = '44' ,`PostalCode` = '77043' ,`RoomCount` = '7' ,`ListPrice` = '597900.00' ,`Status` = 'Active' ,`StreetName` = 'Durban' ,`StreetNumber` = '2807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2435' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a quiet, cul-de-sac street with mature oak trees, you will find this Spring Shadows gem that rivals new construction! Complete renovation including PEX PLUMBING, and electrical upgrades! The moment you enter, you will be amazed at the incredibly OPEN FLOOR PLAN and abundance of NATURAL LIGHT . Freshly painted walls, wide plank LVT and bright windows welcome you into the home. The kitchen is a chef\'s dream with ZLINE APPLIANCES, and QUARTZ counters. Find AMPLE STORAGE in CUSTOM white cabinets and full pantry! This entertainer\'s floor plan continues outside with a SPACIOUS covered patio, ready to host your next back yard BBQ. Enjoy this GREEN SPACE with little maintenance because of the forever green turf! All bedrooms are CONVENIENTLY located upstairs. The primary suite is spacious and has ELEGANT DETAILS such as gold fixtures and free-standing tub. A unique feature of this floor plan is the primary suite connects to another bedroom-IDEAL for a nursery, office or home gym!' ,`Acres` = '0.1768' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK W14 SPRING SHADOWS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Spring Shadows Sec 10' ,`TaxAmount` = '9804' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983816' WHERE `Matrix_Unique_ID` = '212362037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:51:17.767' ,`MLSNumber` = '54037451' ,`ListAgentFullName` = 'Diane Schiff' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654735' ,`Longitude` = '-95.060963' ,`PhotoCount` = '23' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '248000.00' ,`Status` = 'Active' ,`StreetName` = 'Redbud' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home in wonderful Fairmont Park East. This is an opportunity to create your dream home. Nice layout with all bedrooms up. Spacious living/dining area. Breakfast room with windows overlooking the large backyard. Indoor laundry room and attached garage. Primary bedroom has ensuite, second bathroom located upstairs for secondary bedrooms, half bath on main level for guest. Room sizes are approximate, please verify for accuracy. \r\nOwner/Agent' ,`Acres` = '0.1653' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 FAIRMONT PARK EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmont Park East Sec 01' ,`TaxAmount` = '5836' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983816' WHERE `Matrix_Unique_ID` = '212410576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:42:11.983' ,`MLSNumber` = '44518063' ,`ListAgentFullName` = 'Patricia Navarette' ,`ListOfficeName` = 'Texas Sage Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.962615' ,`Longitude` = '-95.704387' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '698000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgestone Park' ,`StreetNumber` = '26403' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 26403 Ridgestone Park Lane, Cypress, Texas. Located in the highly-sought after Blackhorse Community. Make plans to entertain year-round. This gorgeous home features stunning golf course views, lake views, its own pool, hot tub and a covered, outdoor kitchen! Home interior is generously spacious, offering 4 bedrooms and 3.5 baths. Soaring ceilings greet you upon entering the Foyer along with a beautiful, curved wrought-iron staircase. Tons of windows in family room over looking the pool and offering lots of interior light. Attached garage with workspace, laundry room and private Study. Kitchen over looks the Family room, has an eat-in bar and breakfast room, large center island for additional prep space, gas range, wall oven and Microwave. Cozy, stone fireplace in Family room. The Primary Bedroom is down stairs with huge ensuite, perfect spot to unwind at the end of a busy day. Upstairs has additional bedrooms, restrooms and game room. Call for a tour today!' ,`Acres` = '0.3528' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 BLACKHORSE RANCH SEC 1' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot,Water View' ,`LotSize` = '15368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blackhorse Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983816' WHERE `Matrix_Unique_ID` = '212512281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:25:08.440' ,`MLSNumber` = '68271094' ,`ListAgentFullName` = 'Jeri Bailey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.617070' ,`Longitude` = '-95.059849' ,`PhotoCount` = '21' ,`PostalCode` = '77331' ,`RoomCount` = '13' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Paradise' ,`StreetNumber` = '40' ,`StreetSuffix` = 'Trail' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME TO PARADISE! SPECTACULAR WATERVIEW TWO STORY HOME. This one of a kind home is situated on 2 lots (over 1/2 acre) and the home sits high on a hill giving you fantastic views of Lake Livingston. Layout is open and spacious w/living area open to the views and lots of natural light. Austin stone wood burning fireplace. Kitchen has stainless steel appliances, granite countertops, walk-in pantry & desk area w/ lots of cabinets. Updates include new paint, awning over sunroom, AC units, windows throughout house w/lifetime warranty, PEX plumbing in attic from upstairs bathroom to hot water heater. Updated bathrooms include walk-in shower, fixtures, flooring & paint. Oversized detached 2 car garage w/ full bathroom & upstairs unfinished bonus room. Views from every bedroom! Neighborhood is small, quiet & friendly w/amenities - boat ramp, park, swimming area & private pier. Sit on your wrapped porch or entertain in the sunroom. Come live where you are always \"Living on Lake Time\"' ,`Acres` = '0.6984' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARADISE COVE, BLOCK 7, LOT 25 & 26, ACRES .6984' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '30422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Paradise Cove' ,`TaxAmount` = '5190' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983817' WHERE `Matrix_Unique_ID` = '212517553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:13:09.020' ,`MLSNumber` = '96759224' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Ezelu Igweh' ,`SellingOfficeName` = 'B & G Realty' ,`Latitude` = '29.684270' ,`Longitude` = '-95.836299' ,`PhotoCount` = '28' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '439862.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ashlesha' ,`StreetNumber` = '10814' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Terrace, Elevation B). CURRENTLY UNDER CONSTRUCTION. Two story. 4 bedrooms. 3.5 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk in closet. Large Game Room and three additional bedrooms upstairs. Covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '0.1162' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5061' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983817' WHERE `Matrix_Unique_ID` = '212730401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:58:50.053' ,`MLSNumber` = '27217203' ,`ListAgentFullName` = 'Patrick Schott' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212485' ,`Longitude` = '-95.549184' ,`PhotoCount` = '45' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Brooksedge' ,`StreetNumber` = '59' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one story 4/2/2 located in the quiet neighborhood of Brooksedge in Alden Bridge. Approaching this home you are greeted with a generous covered front porch. Entering, the impressive foyer greets you with high ceilings and draws you in to appreciate all it has to offer. This split floor plan home offers the homeowner wonderful privacy. Some of the many features include a large inviting den with fireplace and high ceilings, a spacious primary suite, and a bright open kitchen with skylight and breakfast area. No carpet in this house. The chefs will love how much room there is to move around in the kitchen. Some of the many upgrades/updates include wood floors, energy efficient windows throughout installed 2018, roof replaced 2019, AC replaced 2021, tankless water heater installed 2022 and epoxy coating in garage 2022. The large backyard has plenty of room for a pool. A neighborhood park is nearby and there is easy access to many local amenities.' ,`Acres` = '0.1865' ,`Area` = '15' ,`BuilderName` = 'Plantation' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 58, BLOCK 3, LOT 51' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 58' ,`TaxAmount` = '7023' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983817' WHERE `Matrix_Unique_ID` = '212778805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:05:51.060' ,`MLSNumber` = '42074307' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.403429' ,`Longitude` = '-95.504612' ,`PhotoCount` = '40' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Starlit Sky' ,`StreetNumber` = '630' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle ambitions in The Woodlands Hills with the vibrant and innovative Milburn home plan. The Jack-and-Jill bedrooms and a separate front bedroom offer plenty of personal space for your growing residents and overnight guests. A quiet media room and enclosed front study present unparalleled opportunities to craft the family movie theater and home office you’ve been dreaming of. The streamlined kitchen provides an easy culinary layout for the resident chef with an extended pantry and prep area and a delightful view of the sunny family and dining spaces. Spend quality time together in the shade of your covered outdoor living. Your blissful Extended Owner’s Retreat offers an everyday escape from the outside world, and includes a spa-inspired en suite bathroom and a luxury walk-in closet.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9078' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983817' WHERE `Matrix_Unique_ID` = '213002247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:43:29.543' ,`MLSNumber` = '77655527' ,`ListAgentFullName` = 'Todd Neal' ,`ListOfficeName` = 'Neal Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676258' ,`Longitude` = '-95.731497' ,`PhotoCount` = '20' ,`PostalCode` = '77407' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Water Violet' ,`StreetNumber` = '5823' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the desirable neighborhood of Waterview Estates, this lovely 4 bedroom, 2 1/2 bathroom, well - maintained home is located only minutes away from Westpark Tollway and Highway 99 and just a short drive to Aliana and Waterview Shopping Centers! This home features a large Kitchen with an Island that opens up to the breakfast and oversized family room. All bedrooms, bathrooms and closets are spacious as well and the study is just perfect for a home office. Waterview Estates is known for its walking paths, parks, splashpad, tennis courts, baseball/soccer fields, and community pool. All per seller.\r\n\r\nSchedule your showing today!' ,`Acres` = '0.1279' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERVIEW ESTATES SEC 12, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5573' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '615' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterview Estates Sec 12' ,`TaxAmount` = '6616' ,`TaxRate` = '2.8929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983817' WHERE `Matrix_Unique_ID` = '213010361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:42:41.403' ,`MLSNumber` = '85433504' ,`ListAgentFullName` = 'Derek Boles' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659215' ,`Longitude` = '-95.530172' ,`PhotoCount` = '19' ,`PostalCode` = '77031' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Torcello' ,`StreetNumber` = '8708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently built townhome in a flourishing gated community. This home is gently lived in and will feel like new when you come to visit. Located at the end of the street for additional privacy. Spacious downstairs area with an updated kitchen. Upstairs hold 3 generous sized bedrooms and no back neighbors. Community is tucked away with little traffic. This is a great option for anyone looking to have a peaceful property as your next residence.' ,`Acres` = '0.0458' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 VENETIAN LUXURY HOMES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Venetian Luxury Homes' ,`TaxAmount` = '4170' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983818' WHERE `Matrix_Unique_ID` = '213118495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:51:36.103' ,`MLSNumber` = '25625672' ,`ListAgentFullName` = 'Sherry Williams' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523715' ,`Longitude` = '-95.048318' ,`PhotoCount` = '24' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '3017' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home in Meadow Bend: As you walk through the front door, there is a beautiful 2 story entryway that opens up to the formal dining area. Directly off the entryway is a spacious study with double glass doors. The semi-open floor plan has a large living area that leads to the kitchen, which boasts an abundance of counterspace, storage, an island and stainless-steel appliances. The primary bedroom contains an en-suite w/double vanities, soaking tub, frameless shower and a large walk-in closet. Upstairs you will find 2 additional bedrooms, 1 full bathroom, and a game room. Outside, enjoy the open backyard under the breezy covered palapa. Please view the attached feature sheet for more information.' ,`Acres` = '0.1653' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 LOT 14 BLK 4 MEADOW BEND SEC 5 PHASE 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Bend Sec 5 Ph 5 93' ,`TaxAmount` = '6310' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983818' WHERE `Matrix_Unique_ID` = '213234597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:18:26.947' ,`MLSNumber` = '7466898' ,`ListAgentFullName` = 'Dee Mayo' ,`ListOfficeName` = 'Cross Capital Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005626' ,`Longitude` = '-95.760586' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '438000.00' ,`Status` = 'Active' ,`StreetName` = 'Aster Petal' ,`StreetNumber` = '15010' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in the desirable community of Fairfield, This one story is located in a Cul-de-sac with an oversized yard. Features and extended Garage, beautiful tile floor in the foyer thru the living room. Formal dining has wood floors with crown modeling. Open kitchen with gorgeous 42\" cabinets, with breakfast bar area. Another feature in this home is the 2nd bath has 36\" door for easy access. The Primary bedroom has plantation shutters that open to view the spacious backyard. This home has been very well maintained by the owner, Solar screens along the back windows help save on energy cost. This home is move in ready and ready to enjoy all of Fairfield from the parks, to the pools and the rec center. It’s Zoned Cy-Fair school and within walking distance to Salyards Middle School. Come see this home to appreciate all it has to offer or contact listing agent for information.' ,`Acres` = '0.269' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 FAIRFIELD VILLAGE SOUTH SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11716' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SWENKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Village South Sec 03' ,`TaxAmount` = '8376' ,`TaxRate` = '2.746' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983818' WHERE `Matrix_Unique_ID` = '213248176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:04:29.877' ,`MLSNumber` = '43229080' ,`ListAgentFullName` = 'Christal Amboree' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = 'Maria Borrego' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.292681' ,`Longitude` = '-95.485052' ,`PhotoCount` = '28' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '248000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Epworth' ,`StreetNumber` = '1123' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Cayden Creek subdivision! Come and see why this charming 3 bedroom 2 bathroom house is one you\'ll love to call home. Enjoy your family while relaxing in the comfort of your open concept living room/kitchen or entertain some friends in your large backyard with a covered patio. Neighborhood playground and dog park. All appliances included and new carpet in primary bedroom!\r\nConveniently commute to The Woodlands & Downtown Houston w/easy access to I-45. In close proximity to Lake Conroe, restaurants, entertainment, and shopping.' ,`Acres` = '0.2214' ,`Area` = '19' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S336602 - CAYDEN CREEK 02, BLOCK 2, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9644' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cayden Creek 02' ,`TaxAmount` = '5472' ,`TaxRate` = '2.8863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666983818' WHERE `Matrix_Unique_ID` = '213253009' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:11:15.070' ,`MLSNumber` = '79400205' ,`ListAgentFullName` = 'Neil Silverman' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683388' ,`Longitude` = '-95.490770' ,`PhotoCount` = '43' ,`PostalCode` = '77096' ,`RoomCount` = '10' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Jason' ,`StreetNumber` = '5727' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 bedroom, 2.5 bath home in Meyerland, zoned to Bellaire Highschool. Home has formal dining and\r\nliving room as well as spacious family room. Good size kitchen with plenty of cabinets, ample counter space,\r\nas well as a breakfast room area. All bedrooms are good size. Great backyard, spacious enough for\r\nentertaining and adding a pool. FANTASTIC Location, zoned to Bellaire HS, short drive to Medical Center, Galleria, and Downtown. Room dimensions are approximate, please verify as well as school(s)\r\nenrollment availability that property is zoned for.(*Roof replaced March of 2016, *Never Flooded. *Per Seller)' ,`Acres` = '0.2197' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 10 MEYERLAND SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Meyerland Sec 10' ,`TaxAmount` = '9117' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983818' WHERE `Matrix_Unique_ID` = '213254110' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:29:33.990' ,`MLSNumber` = '2778034' ,`ListAgentFullName` = 'Jennifer Ciulla' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.419786' ,`Longitude` = '-95.560352' ,`PhotoCount` = '43' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreline' ,`StreetNumber` = '13821' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located perfectly within walking distance to lake Conroe, this charming home is move in ready! This home offers 3 bedrooms, a private study, formal dining room, and 2.5 bathrooms. The gourmet kitchen provides an abundance of space with granite countertops, and open to the light and bright family room. Retreat to the primary suite featuring a spa-like bathroom with a large soaker tub, separate shower, and a spacious walk-in closet. \r\n\r\nThis neighborhood has so much to offer! Tennis Courts, Playgrounds, large pavilion for gatherings, as well as a boat ramp. Amazing memories to be made here! \r\n\r\nSchedule your showing today' ,`Acres` = '0.2124' ,`Area` = '39' ,`BuilderName` = 'Anglia' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S659502 - LAKE CONROE HILLS 02, BLOCK 19, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '237' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Hills 02' ,`TaxAmount` = '7384' ,`TaxRate` = '2.2948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983819' WHERE `Matrix_Unique_ID` = '213331165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:45:00.990' ,`MLSNumber` = '22842264' ,`ListAgentFullName` = 'Robert Rhoades' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.163792' ,`Longitude` = '-95.495035' ,`PhotoCount` = '49' ,`PostalCode` = '77381' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Postvine' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this gorgeous open-concept 3 bed, 2.5 bath home nestled on a quiet street at the coveted front of The Woodlands! You\'ll find vaulted ceilings, beautiful wood floors, & high windows throughout this light, bright home. Gourmet kitchen features a 36” ZLine Dual Fuel gas range, Bosch dishwasher, Carrara marble backsplash, & granite counters. Open to living, dining, & breakfast rooms for easy entertaining! Remodeled master suite features TWO WALK-IN CLOSETS, double vanities, luxury step-in shower. Huge game rooms & 2 spacious beds up! Enjoy outdoor entertaining in your private backyard oasis & sparkling pool, featuring waterfall, sun deck, safety gate, & extensive stone & native landscaping. Auto sprinkler system, mosquito mister system, & additional shed storage! NEW HVAC systems! Walking distance to A+ Exemplary Sally K. Ride Elementary. Less than 5 minutes to Cynthia Woods Mitchell Pavilion, Market Street, Hughes Landing, and the most popular restaurants & entertainment!' ,`Acres` = '0.2124' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S972610 - WDLNDS VIL PANTHER CK 10, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SALLY RIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Village Panther Creek' ,`TaxAmount` = '7258' ,`TaxRate` = '2.0501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983819' WHERE `Matrix_Unique_ID` = '213370282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:48:14.640' ,`MLSNumber` = '49386589' ,`ListAgentFullName` = 'Maggie Pearson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Juan Alvarez' ,`SellingOfficeName` = 'BHGRE Gary GreeneLeague City' ,`Latitude` = '29.460688' ,`Longitude` = '-95.092382' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '305000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rustic Colony' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3 bedroom home with an office in Bay Colony Northpointe. Large backyard with a large patio. Wood Tile floors\r\nand carpet only in the bedrooms. Beautifully updated primary bathroom. Popular D.R. Horton floor. Lovely\r\nand convenient community. Make you appointment today! \r\nSeller will need a 3-4 day temporary leaseback' ,`Acres` = '0.1764' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY NORTHPOINTE SEC 2 (2005) ABST 19, BLOCK 1, LOT 4,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Northpointe' ,`TaxAmount` = '7848' ,`TaxRate` = '2.7847' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983819' WHERE `Matrix_Unique_ID` = '213397774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:05:33.870' ,`MLSNumber` = '73371772' ,`ListAgentFullName` = 'Stacey Adkins' ,`ListOfficeName` = 'One Solution Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745236' ,`Longitude` = '-95.581332' ,`PhotoCount` = '34' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland Springs' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 2011 Woodland Springs St. This 4 bedroom, 2 bathrooms 1 1/2-story home in the Energy Corridor, is freshly painted inside and out. The kitchen has a new backsplash and new quartz countertops, along with newer appliances, With Saltillo tiles in the living and kitchen area and luxury vinyl plank flooring used in bedrooms and halls. New gutters, new HVAC, new fence, new roof, and new driveway. A game room is located upstairs with a pool table. To top it all off enjoy your backyard with a swimming pool that comes with a brand-new Polaris cleaning system.  For your private tour, call today.' ,`Acres` = '0.1433' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 APRIL VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'April Village Sec 01' ,`TaxAmount` = '6409' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983819' WHERE `Matrix_Unique_ID` = '213398128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:22:29.540' ,`MLSNumber` = '4335943' ,`ListAgentFullName` = 'Lawrence Hegar' ,`ListOfficeName` = 'Deitra Robertson Real Estate,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.458333' ,`Longitude` = '-95.481386' ,`PhotoCount` = '26' ,`PostalCode` = '77378' ,`RoomCount` = '8' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Amber' ,`StreetNumber` = '1433' ,`StreetSuffix` = 'Cove' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your forever home! This property truly has it all. As soon as you enter the home you are immediately captured by the views from the wall of sliding glass doors overlooking 649 sq ft screened in porch and stocked pond. The entire home offers hardwood flooring along with tile. All doorways and hallways are extra wide allowing room for scooters or walkers. The kitchen boast corian countertops, large farm house sink, Kitchen Aide appliances, double convection ovens, induction stovetop, pot filler, premium energy star dishwasher (very quiet) along with a large island and a pass through to living room making it easy for entertaining. Whole house has foam insulation, including roof, garage, & exterior walls. Home is set up for generator and offers a Reme Halo HVAC whole home air purification system that destroys germs & viruses.' ,`Acres` = '1.39' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S454403 - EMERALD LAKES 03, BLOCK 3, LOT 29, ACRES 1.39' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '60548' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1554' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Lakes 03' ,`TaxAmount` = '7843' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983820' WHERE `Matrix_Unique_ID` = '213401757' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:45:58.273' ,`MLSNumber` = '68647724' ,`ListAgentFullName` = 'Colby Hebert' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = 'Adam Lambert' ,`SellingOfficeName` = 'Real Equity TX LLC' ,`Latitude` = '29.743817' ,`Longitude` = '-95.571768' ,`PhotoCount` = '28' ,`PostalCode` = '77042' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Olympia' ,`StreetNumber` = '11018' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one-owner brick home, located on a coveted cul de sac lot, is ready for you to put the finishing touches on it and call it your own. The possibilities here are endless. Walnut Bend is a highly desirable neighborhood, and quick access to I-10 and the Beltway makes it even more appealing for work and pleasure. Go shopping at City Centre or dine at your favorite local restaurant in just a few short minutes. Walk to the nearest parks and enjoy nature in the city with great walking trails and plenty of shade from the trees. Schedule a tour today!\r\n**This home has never flooded per seller**' ,`Acres` = '0.2411' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 BLK 4 LAKESIDE ESTATES SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '811' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Estates' ,`TaxAmount` = '9148' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983820' WHERE `Matrix_Unique_ID` = '213423032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:32:28.840' ,`MLSNumber` = '24023171' ,`ListAgentFullName` = 'Yvonne Pruneda' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = 'Arnell White' ,`SellingOfficeName` = 'Celebrity Homes Realty' ,`Latitude` = '29.599461' ,`Longitude` = '-95.528132' ,`PhotoCount` = '45' ,`PostalCode` = '77489' ,`RoomCount` = '9' ,`ListPrice` = '255990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Quail Feather' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 1903 Quail Feather Ct in the established neighborhood of Quail Green West. This impeccable newly renovated 4-bedroom, 2-bath home boasts an array of sleek finishes throughout and is a paradigm of modern suburban living. This 1,412SF home offers an open concept plan w/ kitchen, living, dining combo. Primary bedroom w/ensuite bath and walk-in closet. 2 secondary bedrooms w/full bath. Features of this home include high ceilings, wood burning fireplace, a light and bright kitchen equipped with granite countertops, modern backsplash, granite countertops, and a suite of appliances. Enjoy the outdoors w/a covered patio and fully fenced Backyard perfect for Kids & Pets.' ,`Acres` = '0.162' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL GREEN WEST SEC 1, BLOCK 10, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'E A JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Green West Sec 1' ,`TaxAmount` = '4027' ,`TaxRate` = '3.1174' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983820' WHERE `Matrix_Unique_ID` = '213480538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:34:35.423' ,`MLSNumber` = '9954520' ,`ListAgentFullName` = 'Mary Vergara' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765821' ,`Longitude` = '-95.882607' ,`PhotoCount` = '39' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Waverly Park' ,`StreetNumber` = '29815' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this stunner in Young Ranch! This is the former Lennar Model home and it has so many upgrades! \r\n4 bedroom/2.5 baths over 2600+ square feet of living space. Beautiful hardwood floors, white open kitchen, custom design touches throughout the home. This home is a smart home with several features like ring doorbell, wired for Amazon connect etc.\r\nLocated on a cul de sac in the Young Ranch master planned community with several pools, playgrounds, splash pads and walking trails.\r\nEasy access to I-10, Heritage Grand Parkway, and Westpark toll Road. There is nearby shopping, restaurants walking distance. The Texas Heritage Marketplace a large mixed use entertainment and retail space is already underway and is within walking distance from the community. Zoned to highly acclaimed Lamar Consolidated ISD schools!\r\n This home has so much to offer, don\'t miss out on this opportunity to buy this gorgeous home!' ,`Acres` = '0.1818' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'YOUNG RANCH SEC 1, BLOCK 2, LOT 27' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7965' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Young Ranch Sec 1' ,`TaxAmount` = '8925' ,`TaxRate` = '3.072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983820' WHERE `Matrix_Unique_ID` = '213555077' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:10:23.643' ,`MLSNumber` = '18559238' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062261' ,`Longitude` = '-95.228013' ,`PhotoCount` = '28' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Mill' ,`StreetNumber` = '21620' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exciting Three bedroom, two bathroom single story home! This home offers an open concept kitchen, breakfast and family room at back of the house. Vaulted ceilings throughout and arch details in the home. There is a fireplace in the family room. The two secondary bedrooms share a Jack and Jill bathroom. Tile in the entry, kitchen, breakfast and the bathrooms. The kitchen features laminate countertops and a farm style sink.' ,`Acres` = '0.1657' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S642400 - KINGS MILL 01, BLOCK 9, LOT 4' ,`LotDesciption` = 'Other' ,`LotSize` = '7219' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill 01' ,`TaxAmount` = '6038' ,`TaxRate` = '3.1831' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666983820' WHERE `Matrix_Unique_ID` = '213571991' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:00:29.437' ,`MLSNumber` = '3704929' ,`ListAgentFullName` = 'Richard Dricks' ,`ListOfficeName` = 'Bayou, REALTORS' ,`SellingAgentFullName` = 'Joshua Alley' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.406752' ,`Longitude` = '-95.003063' ,`PhotoCount` = '34' ,`PostalCode` = '77591' ,`RoomCount` = '13' ,`ListPrice` = '299900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sunstone' ,`StreetNumber` = '8313' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful home in the desirable Dickinson School District! This home features an open to kitchen living area, high ceilings, and stunning granite countertops with ample cabinet space. The primary bedroom leads into a separate tub and shower with dual sinks as well as a spacious walk in closet. The 1st floor includes a utility room with washer and dryer hookups and a room can be used as an office, play room, or 5th bedroom. The downstairs flooring has recently been replaced with a modern wood look. The garage has a builder included extension of an additional 97 square feet, perfect for a work area or storage without compromising space for vehicles. The upstairs game room overlooks the kitchen and living area and also leads to three additional bedrooms. The lot is located in a cul-de-sac, decreasing the likelihood of noisy through traffic. The community has walking paths, well kept playgrounds, ponds, and a dog park within walking distance. \r\n\r\nRoom sizes are approximate.' ,`Acres` = '0.1515' ,`Area` = '33' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PEARLBROOK SEC 4 (2017) ABST 180, BLOCK 2, LOT 9, ACRES 0.15' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '8907' ,`TaxRate` = '3.4928' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983821' WHERE `Matrix_Unique_ID` = '213612283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:53:25.847' ,`MLSNumber` = '36614592' ,`ListAgentFullName` = 'Errol Nolan' ,`ListOfficeName` = 'Olympic Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766621' ,`Longitude` = '-95.734620' ,`PhotoCount` = '22' ,`PostalCode` = '77450' ,`RoomCount` = '8' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Westgreen' ,`StreetNumber` = '1239' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2109' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and Check out this Opportunity! Spacious 4 bedroom Home with formal living and Dining large cover patio. Have tons of potential and great bones in a prime area.' ,`Acres` = '0.202' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 10B & 11A BLK 20 MEMORIAL PARKWAY SEC 6 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 06 R/P' ,`TaxAmount` = '4662' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983821' WHERE `Matrix_Unique_ID` = '213628515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:24:29.587' ,`MLSNumber` = '45049905' ,`ListAgentFullName` = 'Marnie Wyatt' ,`ListOfficeName` = 'Wyatt Realty Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501668' ,`Longitude` = '-95.459414' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '449999.00' ,`Status` = 'Active' ,`StreetName` = 'Pinedale' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Avenue' ,`City` = 'Arcola' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2967' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing custom home that has more to offer than you could imagine. When entering the home, you will the beautiful foyer with high ceilings, gorgeous tile flooring throughout and so much more. To your left is the office area that has a beautifully done grid accent wall. As you continue into the home you will notice the 12 ft. vaulted ceilings, and the 8ft doors. There is a generous sized media room that has integrated speakers with an audio receiver. The kitchen is open to the Living Room and it boasts elegance with its quartz countertops, an amazing 11 ft. quartz island, built in under cabinet lighting and lots of natural light. Please see the attached list of amenities this home has to offer.' ,`Acres` = '0.2024' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINEDALE MANOR, BLOCK 6, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinedale Manor' ,`TaxAmount` = '8651' ,`TaxRate` = '2.443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983821' WHERE `Matrix_Unique_ID` = '213741534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:46:40.120' ,`MLSNumber` = '48172931' ,`ListAgentFullName` = 'Courtney Okanlomo' ,`ListOfficeName` = 'Collective Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336337' ,`Longitude` = '-95.435423' ,`PhotoCount` = '35' ,`PostalCode` = '77301' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Glenn' ,`StreetNumber` = '1152' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the wooded preserve of Briar Grove, this spacious, Style Craft Builders, 1-story home has NO carpet, NO front neighbors, & sits on a sizeable lot! This uniquely appointed property is complete w/a gourmet kitchen, granite countertops, custom tiled backsplash, SS appliances, breakfast area, & tons of counter & cabinet space. The formal dining room opens up to the cozy family room w/fireplace & built-ins. The primary bedroom has a large walk-in closet, double sinks, and an oversized tub & separate shower. The remaining bedrooms are a nice size w/ample closet space. Enjoy your spacious backyard with concrete slab and side yards. Schedule a private tour today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Style Craft Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S267404 - BRIAR GROVE 04, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Briar Grove 04' ,`TaxAmount` = '4962' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983821' WHERE `Matrix_Unique_ID` = '213758412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:08:05.307' ,`MLSNumber` = '11626573' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135368' ,`Longitude` = '-95.318082' ,`PhotoCount` = '8' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21583' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ll be delighted by the attention to detail that makes The Stonewood a remarkable lifestyle home plan. Host unforgettable social gatherings and spend quiet nights together in the open-concept living spaces. The kitchen island and open dining area offer a streamlined variety of mealtime settings. Enjoy the exquisite sanctuary of your expanded Owner’s Retreat, which features an en suite bathroom and a walk-in closet. The spare bedrooms provide plenty of privacy and a place for out-of-town guests. Sip a cold beverage after a long day while you relax on your covered porch with splendid view of the tree-lined nature trail.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 05 Block 05' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983821' WHERE `Matrix_Unique_ID` = '213763056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:06:37.677' ,`MLSNumber` = '87459582' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135368' ,`Longitude` = '-95.318082' ,`PhotoCount` = '9' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Greylock' ,`StreetNumber` = '7408' ,`StreetSuffix` = 'Loop' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertain in style and live in comfort with this impressive new construction home in The Highlands! Gather in the open-concept dining and living areas for tasteful meals and memorable evenings together. The Epicurean kitchen splits prep, cooking, and presentation zones for greater culinary delight. Relax into your leisurely evenings on the breezy covered patio overlooking one of The Highlands many nature trails. A refreshing en suite bathroom and sprawling walk-in closet contribute to the everyday vacation of your Owner’s Retreat. Additional bedrooms on both floors ensure that everyone has an amazing place to make their own. Design the ideal space for your family to play, learn, and grow together in the expansive upstairs retreat.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47 Block 04' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983822' WHERE `Matrix_Unique_ID` = '213764045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:04:30.130' ,`MLSNumber` = '29478913' ,`ListAgentFullName` = 'DJ Arsenault' ,`ListOfficeName` = 'Texan Realtors.com, LLC' ,`SellingAgentFullName` = 'Brookes Cunningham' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.148153' ,`Longitude` = '-95.406300' ,`PhotoCount` = '40' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hunter' ,`StreetNumber` = '32427' ,`StreetSuffix` = 'Park' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2389' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tastefully updated 4 bed 2.5 bath located in the Master planned community of Imperial Oaks. Roof replaced 2021. Home is affordable, but functional w/ its generous open living & vaulted ceilings. Updates include, Wood look flooring, Stainless appliances, Granite counters, Private Patio & custom shelving in closet. Look for the secret area in the upstairs bedroom closet (bonus space great for reading, adventures, or storage). 3 pools & splash pads to choose from including dog park, Tennis court, Volleyball & Basketball courts. Zoned to amazing CISD schools such as Kaufman Elementary, Nearby Shopping, Hospital, Fine dining, Movie Theatre & Grocery. Come in and out of the neighborhood through multiple routes for easy access to The Woodlands, Market Street & Downtown Houston via the Grand Parkway. Less than 10 minutes to I-45, Grand Parkway & Hardy. Minutes to the future YMCA, You will enjoy the convenience of shopping and dining.' ,`Acres` = '0.1523' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS PARK 05, BLOCK 2, LOT 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Park 05' ,`TaxAmount` = '6511' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983822' WHERE `Matrix_Unique_ID` = '213782006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:15:36.253' ,`MLSNumber` = '48554465' ,`ListAgentFullName` = 'Kim Palomino' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201679' ,`Longitude` = '-95.446416' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Threadtail' ,`StreetNumber` = '8109' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive Highland Homes Middleton plan on a cul-de-sac street in the master planned community of Harpers Preserve adjacent to The Woodlands and zoned to Conroe ISD. This home has it all including a backyard paradise with pool, gazebo and large covered patio. With 5 bedrooms, study, formal dining, game room, media room and oversized 3-car garage there is nothing this house does not offer. Two bedrooms down, including the primary bedroom and a full bath. The main living area, both downstairs bedrooms, and the office have engineered hardwood. Upstairs are three more bedrooms, two full baths, game room and media room. This special home will not last long! The Upgrade List and Survey are in the Document Section.' ,`Acres` = '0.211' ,`Area` = '15' ,`BuilderName` = 'Highland' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572700 - HARPER\'S PRESERVE 01, BLOCK 8, LOT 51' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9190' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '15947' ,`TaxRate` = '3.0088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983822' WHERE `Matrix_Unique_ID` = '213813119' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:43:23.990' ,`MLSNumber` = '85063562' ,`ListAgentFullName` = 'Kan Chan' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Rosalinda Sierra' ,`SellingOfficeName` = 'Sierra Group Realty' ,`Latitude` = '29.866430' ,`Longitude` = '-95.198925' ,`PhotoCount` = '44' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mariposa Stream' ,`StreetNumber` = '10126' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice two story 4-bedroom 3 bathroom located in the 610 and I-10 East area. The home has a separate dining room and a large living room. The master bedroom has vaulted ceilings and the master bathroom has a garden sub with a separate walk-in shower. The home has a large back yard that is perfect for entertaining.' ,`Acres` = '0.1331' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 HIDDEN MEADOW SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'CARROLL ELEMENTARY SCHOOL (SHELDON)' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'HIDDEN MWADOW' ,`TaxAmount` = '5903' ,`TaxRate` = '3.0293' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983822' WHERE `Matrix_Unique_ID` = '213820923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:26:50.930' ,`MLSNumber` = '88093769' ,`ListAgentFullName` = 'Noreen Arleth' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Monica Dunn' ,`SellingOfficeName` = 'Orchard Brokerage' ,`Latitude` = '30.119072' ,`Longitude` = '-95.745103' ,`PhotoCount` = '49' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '399900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Turtle Creek' ,`StreetNumber` = '19615' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two-story home on approx 1.24+/- acre lot, fenced & cross-fenced. Unrestricted. Huge living area w/stained concrete floors. Wood-encased windows w/rosette trim. Open Kitchen, dining area. Updated cabinets, appliances and granite. The oversized island/breakfast bar and cook top are a nice touch for entertaining. Tons of extra counter space. One bedroom down has access to full bath and cedar-lined closet. This would also make a great office. Primary bedroom plus 2 secondary bedrooms up. Balcony overlooks pool and landscaped oasis. Spacious secondary bedrooms have cedar-lined window seats. 2 tiered covered deck w/view to in-ground 12\' deep pool w/dive board. Garage is 24x24 w/workbench and 6x8 dog kennel area. 12x24 insulated building w/electric & plumbed. Could easily be made into a \"guest house\". Also 12x20 storage shed with workbench, peg board and cabinets. Lots of wrap-around porches, covered decks! Low tax rate, ez access to 249, 2920, 99. No HOA fees - No HOA!' ,`Acres` = '1.2362' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TURTLE CREEK 01, BLOCK 5, LOT 5, ACRES 1.240' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '53849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Turtle Creek' ,`TaxAmount` = '3843' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983823' WHERE `Matrix_Unique_ID` = '213866048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:08:35.013' ,`MLSNumber` = '97794127' ,`ListAgentFullName` = 'Tiffany Romero' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.412646' ,`Longitude` = '-95.567391' ,`PhotoCount` = '36' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 830' ,`StreetNumber` = '13790' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT opportunity to live within walking distance of Lake Conroe. This home is an amazing 3 bedroom with so much character. It is on 2 lots almost 3/4 of an acre total. If you love to cook and entertain than this is your home!! The gorgeous kitchen and family room are located upstairs with 3 balconies to have views from the second floor. Family room and Kitchen both have cedar beams which makes it such a rustic living area with Texas feel. Backyard has a separate fenced in area great for a pet. This property would also make a fun weekend lake house or a great investment property or airbnb. Owner has Access to boat launch, clubhouse and community park. There are two entrances to the property, off of FM830 leads to front of home and off of Woodland Manor Dr in Lakeview Manor you can enter from the back of property. Downstairs AC 2020, New water heater 2022' ,`Acres` = '0.2353' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW MANOR, BLOCK 1, LOT 8 and 16' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '30928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Lakeview Manor' ,`TaxAmount` = '6814' ,`TaxRate` = '2.1633' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983823' WHERE `Matrix_Unique_ID` = '213879452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:06:15.850' ,`MLSNumber` = '40369700' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404771' ,`Longitude` = '-95.510237' ,`PhotoCount` = '13' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Fan Palm' ,`StreetNumber` = '326' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, community meeting center, full size gym, 17 acre park, tennis courts, dog parks, splash pad and lazy river. Timeless elegance and impeccable craftsmanship come together in the luxurious Cloverstone new home plan. Decorate and furnish your open-concept living space to perfectly fit your interior design style. The streamlined kitchen features a family gathering island and plenty of room for collaborative feast creation. Your two spare bedrooms offers large closets. Retire to the superb comfort of your Owner’s Retreat, which includes a pamper-ready bathroom and a deluxe glass enclosed shower and a walk-in closet.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 03' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666983823' WHERE `Matrix_Unique_ID` = '213929481' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213971298','1666983823','213971298','2022-10-28T07:32:30.843','27421167','Brian Chiu','Compass RE Texas, LLC','','','29.681062','-95.657753','26','77083','3','244900.00','Active','Evergreen Place','15327','Drive','Houston','2','0','3','1726','Single-Family','Welcome Home to this GORGEOUS REMODELED 3 bed/2 bath home in Mission Glen with UPGRADES galore! Brand NEW roof, A/C, flooring, interior and exterior paint, exterior siding, quartz countertops, and appliances! This home is LIGHT and BRIGHT and ready for new owners! You\'ll LOVE the beautiful natural light beaming through the HUGE windows throughout the home. Come make this home yours TODAY!','0.124','37','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Mission Bend Area','Central Gas','1','MISSION GLEN SEC 1, BLOCK 8, LOT 53, RP','Subdivision Lot','5401','Appraisal District','','326','0','','2','Gas Oven','0','','','Freestanding Range','','Composition','19 - Fort Bend','MISSION GLEN ELEMENTARY SCHOOL','BUSH HIGH SCHOOL','HODGES BEND MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Mission Glen Sec 1','4001','2.2857','Public Sewer,Public Water','1983','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:47:22.490' ,`MLSNumber` = '25879707' ,`ListAgentFullName` = 'Honor Hilton' ,`ListOfficeName` = 'Home Sweet Home RE Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.234604' ,`Longitude` = '-95.564072' ,`PhotoCount` = '49' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Weeping Willow' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3 bedroom, 2 bathroom, one story home located in Westwood. Some great features about this home include, large windows allowing for great natural lighting. All three bedrooms are very spacious, as well as both bathrooms that including double sinks. There is plenty of living room space, kitchen space and dining room space. This home also includes an office and a HUGE shop in the back. Welcome to your next home sweet home!' ,`Acres` = '0.4591' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S949504 - WESTWOOD 04, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '228' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood 04' ,`TaxAmount` = '6533' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983823' WHERE `Matrix_Unique_ID` = '214001903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:48:51.910' ,`MLSNumber` = '38779975' ,`ListAgentFullName` = 'Maggie Pearson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571811' ,`Longitude` = '-95.023002' ,`PhotoCount` = '42' ,`PostalCode` = '77586' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lori' ,`StreetNumber` = '1913' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously kept home in the charming city of Seabrook. Upon entry you are greeted by a formal living area which leads through French doors into the main living room. New carpet downstairs throughout all public areas and the staircase. Elegant remodeled Kitchen and breakfast nook open to the living room. Upstairs you will find 4 bedrooms and an oversized game room. Recent updates include water heater, AC, and appliances. Washer/dryer/refrigerator to remain with the home. Outside you will find a large storage shed/workshop with a new roof. Pool sized backyard and located on a cul de sac street. Seabrook trails, the public library, elementary and middle schools all within walking distance to the home! This home is ready for a new family, the only thing missing is you!' ,`Acres` = '0.1641' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 HARBOUR COVE ESTATES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '241' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Cove Estates' ,`TaxAmount` = '5397' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983823' WHERE `Matrix_Unique_ID` = '214025665' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214039512','1666983824','214039512','2022-10-28T07:35:39.290','43619475','Donna Norris','Keller Williams Realty - Clear Lake/ NASA','','','29.558958','-95.021542','45','77586','8','435000.00','Active','Staples','1009','Avenue','Seabrook','2','0','3','1887','Single-Family','NEARLY NEW - Lovely tree shaded elevated home near Back Bay Lagoon, Galveston Bay, area shops, restaurants, Kemah Boardwalk, marinas, city pool, parks, and miles of hike & bike trails in Old Seabrook. Neutral palette inside and out is done in farmhouse modern style. Features include luxury vinyl plank flooring in common areas, gorgeous marble fireplace surround, large island kitchen and huge Primary Suite. Recessed lighting accents 9\' ceilings throughout the home. Open plan offers large rooms and bathrooms with huge closets. Quartz countertops and custom upgraded touches to be found everywhere. Cat5e cable has been hard wired throughout the home, and terminates at electronics hub in utility room. Water softening system has also been added. Enjoy the coastal living lifestyle you\'ve been dreaming of in this peaceful tucked away location, where light bay breezes are felt year-round, neighbors are friendly, and schools are excellent. No MUD, no HOA and low taxes too!','','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Clear Lake Area','Central Gas','0','LT 8 BLK 43 SEABROOK','Cleared,Subdivision Lot','6250','Appraisal District','','','0','','0','','0','','','Gas Range','','Composition','9 - Clear Creek','BAY ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Old Seabrook','','','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:34:41.953' ,`MLSNumber` = '95048057' ,`ListAgentFullName` = 'Jamie Wills' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571842' ,`Longitude` = '-95.042819' ,`PhotoCount` = '30' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Ridge' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Drive' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming single story home in the desirable community of El Lago. Large formal living room overlooks the front yard with a curving wall of windows. This flexible space would make a great home office, dining room, or play area. The kitchen offers updated cabinetry with big, deep drawers, granite countertops, double convection ovens, and a 5-burner gas cooktop. The breakfast area is open the family room with corner fireplace and windows overlooking the backyard. At the back of the house is the primary bedroom and bathroom featuring a walk-in closet. There are also three secondary bedrooms plus an updated bathroom. Outside you\'ll find a spacious backyard with a covered patio area. El Lago is conveniently located and offers parks, playgrounds, and a covered basketball court. For a small fee, residents here have access to a boat ramp, the pool, a splash pad, tennis courts and fitness center. Children here attend highly rated CCISD schools.' ,`Acres` = '0.2204' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 10 EL LAGO SEC 4 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '38' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'El Lago' ,`TaxAmount` = '6310' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983824' WHERE `Matrix_Unique_ID` = '214078643' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214080032','1666983824','214080032','2022-10-28T06:29:21.937','80139793','Michelle Whitecotton','Markham Realty, Inc.','','','30.332932','-95.087773','36','77327','6','342000.00','Active','Wall','142','Street','Cleveland','2','0','3','2179','Single-Family','Timeless style with a premium location. Elegant renovations with irresistible class. This house is all of those things and more. Recently updated with new floors, granite countertops, paint, and tankless water heater. Outside updates include home generator, resurfaced driveway, pool gazebo and your own 10x16 workshop. Enjoy your morning coffee or favorite evening drink from any of the 3 patios with peaceful views. And there\'s still more..ample room to entertain guests on your spacious 1/2 acre, fully fenced backyard with separate entrance, pool, and room for all the outdoor games. This will be your best move yet! Call today to schedule your showing.','0.5152','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Cleveland Area','Central Electric','0','GOLFCREST, BLOCK 2, LOT 1-4, ACRES .5152','Cleared,Corner,Subdivision Lot','22442','Appraisal District','','','0','','2','Electric Oven','1','Gunite,In Ground','','Electric Range','','Tile','100 - Cleveland','SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Golfcrest','6988','2.5563','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:48:53.937' ,`MLSNumber` = '92669402' ,`ListAgentFullName` = 'Aaron Cruz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693204' ,`Longitude` = '-95.476671' ,`PhotoCount` = '29' ,`PostalCode` = '77401' ,`RoomCount` = '15' ,`ListPrice` = '1999000.00' ,`Status` = 'Active' ,`StreetName` = 'Valerie' ,`StreetNumber` = '5303' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '6236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom wood front door surround by beautiful stained glass, grand foyer leading to a private office with endless shelves. Huge formal living and dining rooms with wet bar. Chef\'s kitchen with new SS Wolf gas stove & double oven, SS double door commercial grade subzero refrigerator, 2 Asko dishwashers, walk-in pantry with a 120 bottle wine fridge. Flawless new red oak hardwood floors throughout. primary suite on the first floor features an elegant gas fireplace, gorgeous spa-like bathroom, quartz double sink vanity, frameless glass walk-in shower, soaking tub, huge walk-in closet. Second bedroom down with custom desk and en-suite. 2 half baths down. Two staircases lead you to the 4 bedrooms upstairs with crown molding, plantation shutters, built-in desk and en-suites (one Jack-n-Jill bath). Large game room with natural sky light and large windows overlooking the back yard. 4 car garage with two electric car charging ports. Per seller extensive renovations were done in 2021.' ,`Acres` = '0.47' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 12 BRAEBURN CNTRY CLUB ESTS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Braeburn Cntry Club Estates Sec 5' ,`TaxAmount` = '34491' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983824' WHERE `Matrix_Unique_ID` = '214088582' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T07:04:05.153' ,`MLSNumber` = '20721145' ,`ListAgentFullName` = 'Keith Buchanan' ,`ListOfficeName` = 'KMB Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858441' ,`Longitude` = '-95.713940' ,`PhotoCount` = '10' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Cozy Cabbin' ,`StreetNumber` = '19626' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully updated home in sought after Plantation Lakes subdivision. Award winning Cy-Fair schools. This home is located on a cul-de-sac street. New interior paint, new light fixtures, new tile throughout the living area, new carpet, new appliances, and new QUARTZ countertops. Hard to find one story with soaring ceilings. Open floor plan with tons of natural light. Don\'t miss out on this home.' ,`Acres` = '0.1193' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 PLANTATION LAKES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '516' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Lakes Sec 03' ,`TaxAmount` = '5267' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983824' WHERE `Matrix_Unique_ID` = '214099283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:33:17.683' ,`MLSNumber` = '97615634' ,`ListAgentFullName` = 'Geraldine Mills' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470641' ,`Longitude` = '-95.228340' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '1749000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridle Path' ,`StreetNumber` = '3016' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning property sits atop nearly three quarters of an acre on the highly desirable private cul-de-sac of Bridle Path Lane. This one-of-a-kind Sterling custom-built home is complete with five bedrooms with the primary and two of the secondary bedrooms with en-suite baths being on the first floor. Upstairs you’ll find a sprawling game room and two spacious bedrooms with a Hollywood style bath between them. This impressive home is also equipped with a media room, home office, gourmet kitchen, beautifully vaulted ceilings with wood beams, and the primary bedroom that opens to the back patio through gorgeous French doors. This home is a fabulous blend of functionality and style. Outside, you’ll be pleased to find a magazine-worthy backyard with ample green space, an amazing pool and spa area, outdoor fireplace, and an outdoor kitchen grilling area. Schedule an appointment to see this property for yourself, it is sure to impress.' ,`Acres` = '0.68' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 616, BLOCK 2, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '29785' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Sterling Ridge Estates' ,`TaxAmount` = '20019' ,`TaxRate` = '2.283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983824' WHERE `Matrix_Unique_ID` = '214137637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-28T06:52:09.917' ,`MLSNumber` = '34196494' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349896' ,`Longitude` = '-95.635980' ,`PhotoCount` = '30' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Rhonda' ,`StreetNumber` = '17693' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great investment property sitting on over 1.6 acres of NON-RESTRICTED land in Montgomery County! Built-in 2000, the home sits very largely with 2,867sq ft and consists of 5 bedrooms and 3 bathrooms. The property has a septic tank in place that pulls water from a well. On the lot, there is an electric pole that is used to power mobile homes, the owner used to have two mobile homes. OUT of the flood zone! This property is to be sold AS-IS.' ,`Acres` = '1.66' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S767200 - OLD OAK ESTATES, LOT 9, SERIAL UNKNOWN, MODEL NO L' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '72310' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Old Oak Estates' ,`TaxAmount` = '3605' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666983825' WHERE `Matrix_Unique_ID` = '214145198' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214152991','1666983825','214152991','2022-10-28T07:59:36.530','54994455','Justin Dickey','Keller Williams Professionals','','','30.026043','-95.084261','16','77336','6','234990.00','Active','Teton Hollow','24723','Trail','Huffman','2','0','3','1243','Single-Family','Brand New Colina Homes in Woodland Lakes - On Lake Houston CUL-De-Sac Lot, Ready November ! Colina Homes believes in building your dream home. This beautiful on large lot 2-Story 3 Bedrooms + 2 Full Baths + Covered Patio will surely make you feel right at home! Come see this open-concept home with space in all the right places. This beautiful Kitchen features Pewter Gray 42” Cabinets + Fantasy Brown Luxury Granite + Decorative Tile Back splash +Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! 6x24 Porcelain Tile Flooring at Entry, Kitchen, Dining, Family Room, Hallways, Utility & All Baths. Master Suite that boasts - Walk-in Closet, Marble Vanity Double Sinks , 5’Stand up Shower + 2” Faux Wood Blinds, , 16 SEER Air System, Radiant Barrier Decking + Vinyl Easy Clean Double Pane Windows, Garage Door Opener! This Energy Efficient home will SAVE you $$$!','','1','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Huffman Area','Central Electric','1','Lot 11 Block 2 Section 5','Water View','5760','Survey','','400','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','28 - Huffman','FALCON RIDGE ELEMENTARY SCHOOL','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Accompany','Builder','1','Traditional','Woodland Lakes','','3.35','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214155056','1666983825','214155056','2022-10-28T07:48:47.623','60961484','Guang Yang','Texas Signature Realty','','','29.579557','-95.587129','42','77479','10','398000.00','Active','Springfield Lakes','4535','Street','Sugar Land','2','1','4','2804','Single-Family','Situated in a great community and prime location ( zoned to TOP rated Clements High School with excellent middle and elementary schools ) this traditional brick home is filled with every convenience with close proximity to grocery stores( 99 Ranch Market, Jusgo Supermarket, Welfresh Market, HEB) restaurants, and shopping centers (First Colony Mall). An open concept floor plan filled with sunlight throughout the house, A large living space, Game room with master bedroom downstairs and three additional bedrooms upstairs makes one have to see this house, to appreciate the great vibe!','0.1578','29','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','2','Sugar Land South','Central Gas','1','LAKEFIELD SEC 2, BLOCK 2, LOT 9','Subdivision Lot','6872','Appraisal District','','780','0','','2','Electric Oven','0','','','','','Composition','19 - Fort Bend','AUSTIN PARKWAY ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Lakefield Sec 2','5878','2.1594','Water District','1993','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214161130','1666983825','214161130','2022-10-28T07:47:02.327','22669277','Chanel Chapman','Redfin Corporation','','','29.598497','-95.807842','46','77471','9','350000.00','Active','Mason','6202','Way','Rosenberg','2','0','3','2326','Single-Family','Showstopper! This exquisite 3 bedroom, 2 bath Rosenberg brick home is filled with tall ceilings, spacious rooms, and designer touches throughout. The moment you enter, you\'re met with a grand open space that is ideal for hosting guests! Versatile formal living or dining room. The Texas-sized living room is at the heart of the home and opens to the kitchen. Your new kitchen offers a large breakfast bar and island with a sink, built-in stainless steel appliances, a tiled backsplash, recessed lighting, ample prep space, and a pantry. The serene primary suite boasts a separate shower, a soaking tub, separate vanities, and a walk-in closet. The third bedroom is great to use as a comfortable home office or gym! You\'ll appreciate the excellent backyard with a covered patio and lots of yard space. Enjoy relaxing at the end of a long day under the big sky and green views. No backyard neighbors! Don\'t miss your chance to call this beautiful home your own! 3D tour is available online!','0.183','30','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Fort Bend County North/Richmond','Central Gas','1','KINGDOM HEIGHTS SEC 4, BLOCK 3, LOT 14','Other','7973','Appraisal District','','665','0','','2','Convection Oven','0','','','Gas Cooktop','','Other','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Kingdom Heights','6715','2.7948','Public Sewer,Water District','2018','Appraisal District'); --> New record created successfully